Details for:

Type:
Files:
Size:

Uploaded:
By:

Seeders:
Leechers:
Info Hash:
  1. 1. Introduction/1. Manage relational data with PostgreSQL.mp44.65 MiB
  2. 2. Getting Started with PostgreSQL/1. What is PostgreSQL.mp410.34 MiB
  3. 2. Getting Started with PostgreSQL/2. Download and install PostgreSQL.mp419.68 MiB
  4. 2. Getting Started with PostgreSQL/3. Install PostgreSQL with Docker.mp413.28 MiB
  5. 2. Getting Started with PostgreSQL/4. Connect to the server with psql.mp417.01 MiB
  6. 2. Getting Started with PostgreSQL/5. Browse the server with a graphical interface.mp413.35 MiB
  7. 2. Getting Started with PostgreSQL/6. Connect pgAdmin to Docker.mp410.90 MiB
  8. 2. Getting Started with PostgreSQL/7. Tour the pgAdmin interface.mp412.70 MiB
  9. 2. Getting Started with PostgreSQL/8. Use pgAdmins toolset.mp416.19 MiB
  10. 2. Getting Started with PostgreSQL/9. Create objects with pgAdmins dialog workflows.mp414.54 MiB
  11. 3. An Introduction to Relational Databases/1. The structure of a database table.mp410.23 MiB
  12. 3. An Introduction to Relational Databases/2. PostgreSQL native data types.mp414.92 MiB
  13. 3. An Introduction to Relational Databases/3. Join tables together with relationships.mp45.58 MiB
  14. 3. An Introduction to Relational Databases/4. Create a table and insert rows of data.mp414.06 MiB
  15. 3. An Introduction to Relational Databases/5. Challenge- Create a table.mp41.30 MiB
  16. 3. An Introduction to Relational Databases/6. Solution- Create a table.mp412.84 MiB
  17. 4. Building a Database/1. Organize tables with schemas.mp415.54 MiB
  18. 4. Building a Database/2. Create a table with pgAdmin.mp416.59 MiB
  19. 4. Building a Database/3. Link primary and foreign keys.mp415.69 MiB
  20. 4. Building a Database/4. Enforce referential integrity on related records.mp419.16 MiB
  21. 4. Building a Database/5. Challenge- Execute a command on the Postgres server.mp41.65 MiB
  22. 4. Building a Database/6. Solution- Execute a command on the Postgres server.mp413.43 MiB
  23. 5. Retrieving Information with Queries/1. Import data from a CSV.mp410.99 MiB
  24. 5. Retrieving Information with Queries/2. Retrieve information with a SELECT query.mp415.39 MiB
  25. 5. Retrieving Information with Queries/3. Helpful pgAdmin Query Tool interface elements.mp411.47 MiB
  26. 5. Retrieving Information with Queries/4. Join tables for additional information.mp415.26 MiB
  27. 5. Retrieving Information with Queries/5. Save a query as a database view.mp411.06 MiB
  28. 5. Retrieving Information with Queries/6. Challenge- Import data and write queries.mp41.90 MiB
  29. 5. Retrieving Information with Queries/7. Solution- Import data and write queries.mp418.90 MiB
  30. 6. Managing Data/1. Add indexes to a table.mp414.48 MiB
  31. 6. Managing Data/2. Automatically fill in default values.mp410.54 MiB
  32. 6. Managing Data/3. Constrain acceptable input values.mp415.65 MiB
  33. 6. Managing Data/4. Challenge- Add data constraints.mp41.62 MiB
  34. 6. Managing Data/5. Solution- Add data constraints.mp418.46 MiB
  35. 7. Database Administration in PostgreSQL/1. User accounts and roles.mp411.71 MiB
  36. 7. Database Administration in PostgreSQL/2. Grant privileges to a role.mp413.94 MiB
  37. 7. Database Administration in PostgreSQL/3. Backup and restore a database.mp412.23 MiB
  38. 7. Database Administration in PostgreSQL/4. Start and stop the server.mp412.38 MiB
  39. 8. Conclusion/1. Next steps.mp42.56 MiB
  40. Ex_Files_PostgreSQL_EssT.zip6.88 KiB