Filename Size 04- Download and install PostgreSQL.en.srt 11.2 KB 04- Download and install PostgreSQL.mp4 13.5 MB 06- Browse the server with a graphical interface.en.srt 9.1 KB 06- Browse the server with a graphical interface.mp4 10.2 MB 08- Challenge - Create a table.en.srt 1.1 KB 08- Challenge - Create a table.mp4 1.2 MB 09- Solution - Create a table.en.srt 10.6 KB 09- Solution - Create a table.mp4 12.5 MB 10- The structure of a database table.en.srt 7.1 KB 10- The structure of a database table.mp4 5.9 MB 11- PostgreSQL native data types.en.srt 9.2 KB 11- PostgreSQL native data types.mp4 9.3 MB 12- Join tables together with relationships.en.srt 5.4 KB 12- Join tables together with relationships.mp4 4.9 MB 13- Organize tables with schemas.en.srt 12.4 KB 13- Organize tables with schemas.mp4 13.5 MB 14- Create a table with pgAdmin.en.srt 16.3 KB 14- Create a table with pgAdmin.mp4 20.7 MB 15- Link primary and foreign keys.en.srt 13.2 KB 15- Link primary and foreign keys.mp4 15.1 MB 16- Enforce referential integrity on related records.en.srt 11.4 KB 16- Enforce referential integrity on related records.mp4 14.2 MB 17- Challenge - Execute a command on the Postgres server.en.srt 1.6 KB 17- Challenge - Execute a command on the Postgres server.mp4 1.8 MB 18- Solution - Execute a command on the Postgres server.en.srt 11.6 KB 18- Solution - Execute a command on the Postgres server.mp4 15.5 MB 19- Import data from a CSV.en.srt 7.8 KB 19- Import data from a CSV.mp4 9.9 MB 20- Retrieve information with a SELECT query.en.srt 7.9 KB 20- Retrieve information with a SELECT query.mp4 9.3 MB 21- Helpful pgAdmin Query Tool interface elements.en.srt 4.8 KB 21- Helpful pgAdmin Query Tool interface elements.mp4 5.5 MB 22- Join tables for additional information.en.srt 8.5 KB 22- Join tables for additional information.mp4 11.8 MB 23- Save a query as a database view.en.srt 6.3 KB 23- Save a query as a database view.mp4 8 MB 24- Challenge - Import data and write queries.en.srt 1.7 KB 24- Challenge - Import data and write queries.mp4 1.7 MB 25- Solution - Import data and write queries.en.srt 11 KB 25- Solution - Import data and write queries.mp4 15.4 MB 26- Add indexes to a table.en.srt 11.7 KB 26- Add indexes to a table.mp4 13.6 MB 27- Automatically fill in default values.en.srt 6.5 KB 27- Automatically fill in default values.mp4 8.9 MB 28- Constrain acceptable input values.en.srt 10.2 KB 28- Constrain acceptable input values.mp4 12.3 MB 29- Challenge - Add data constraints.mp4 1.9 MB 30- Solution - Add data constraints.en.srt 17.8 KB 30- Solution - Add data constraints.mp4 22.6 MB 31- User accounts and roles.en.srt 7.5 KB 31- User accounts and roles.mp4 9.2 MB 32- Grant privileges to a role.en.srt 11 KB 32- Grant privileges to a role.mp4 14.5 MB 33- Back up and restore a database.en.srt 8.9 KB 33- Back up and restore a database.mp4 11 MB 34- Start and stop the server.en.srt 1.9 KB 34- Start and stop the server.mp4 1.7 MB 35- Additional resources.en.srt 3 KB 35- Additional resources.mp4 2.8 MB Ex_Files_PostgreSQL_EssT.zip 5.8 KB
