DatabaseLesson 15Free preview

Create Demo Database

This lesson is part of PostgreSQL · All levels

Summary

Creating a training-specific demo database is a wise step before exploring SQL commands. You're going to create a separate database, define some interrelated tables, and then fill them with sample data. That way, all experiments are safe and easily repeated at any time.

Key points

Create a separate database dedicated to training to keep other application data secure.
Prepare some relational tables to practice JOIN and aggregation.
Fill with enough sample data to test the filters and the clusters.
Save the schema in the file .sql so that it can be easily recreated.

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.