Create an Entity Relationship Diagram (ERD) also found here: Creating an Entity Relationship Diagram for Pagila The data and the question sets will be included.ĥ.

Provide resources and a link to a Github repository detailing these steps. Download and load the Pagila database set (based on the famous Sakila training database).Ĥ. Download PostgreSQL and pgAdmin 4 to your own PC or environment.ģ. The following tutorial will walk you through the following tasks:ġ. Postgres is an open-source project under a liberal Open Source license. You can find this tutorial at Simulating A Real-world SQL Environment This read-me is lacking the photos that the article containsĪ tutorial using PostgreSQL, pgAdmin 4 and the Pagila Dataset. All files associated with creating an ERD in PostgreSQL detailing the Pagila Database.All files associated with Pagila Database.In this repository you can find info to help you create an Entity Relationship Diagram (ERD) and question sets to help you train on the Pagila Dataset.

Tutorials, Data and Questions sets allowing you to download PostgreSQL and The Pagila Database for the purpose of real-world SQL simulation.

SQL Training with Pagila Database and PostgreSQL DBMS