Linkedin - PostgreSQL Essential Training Update 2025
Course details
PostgreSQL is trusted with mission critical information by some of the biggest companies in the world. It’s also highly flexible, which makes it a great choice for data science researchers, educators, nonprofit organizations, and businesses of all sizes.
In this course, Adam Wilbert, who has spent the last decade helping people take their first steps in the world of relational databases, introduces you to PostgreSQL. Adam demonstrates how to set up your own server and create a customized relational database. He shows you the features of PostgreSQL that protect your data from unauthorized access, ensure that it’s accurate, and simplify the process of querying information so that you can make actionable decisions. PostgreSQL is a powerful, robust platform. Get started learning how it works!
1. Introduction/1. Manage relational data with PostgreSQL.mp4 4.65 MiB 2. Getting Started with PostgreSQL/1. What is PostgreSQL.mp4 10.34 MiB 2. Getting Started with PostgreSQL/2. Download and install PostgreSQL.mp4 19.68 MiB 2. Getting Started with PostgreSQL/3. Install PostgreSQL with Docker.mp4 13.28 MiB 2. Getting Started with PostgreSQL/4. Connect to the server with psql.mp4 17.01 MiB 2. Getting Started with PostgreSQL/5. Browse the server with a graphical interface.mp4 13.35 MiB 2. Getting Started with PostgreSQL/6. Connect pgAdmin to Docker.mp4 10.90 MiB 2. Getting Started with PostgreSQL/7. Tour the pgAdmin interface.mp4 12.70 MiB 2. Getting Started with PostgreSQL/8. Use pgAdmins toolset.mp4 16.19 MiB 2. Getting Started with PostgreSQL/9. Create objects with pgAdmins dialog workflows.mp4 14.54 MiB 3. An Introduction to Relational Databases/1. The structure of a database table.mp4 10.23 MiB 3. An Introduction to Relational Databases/2. PostgreSQL native data types.mp4 14.92 MiB 3. An Introduction to Relational Databases/3. Join tables together with relationships.mp4 5.58 MiB 3. An Introduction to Relational Databases/4. Create a table and insert rows of data.mp4 14.06 MiB 3. An Introduction to Relational Databases/5. Challenge- Create a table.mp4 1.30 MiB 3. An Introduction to Relational Databases/6. Solution- Create a table.mp4 12.84 MiB 4. Building a Database/1. Organize tables with schemas.mp4 15.54 MiB 4. Building a Database/2. Create a table with pgAdmin.mp4 16.59 MiB 4. Building a Database/3. Link primary and foreign keys.mp4 15.69 MiB 4. Building a Database/4. Enforce referential integrity on related records.mp4 19.16 MiB 4. Building a Database/5. Challenge- Execute a command on the Postgres server.mp4 1.65 MiB 4. Building a Database/6. Solution- Execute a command on the Postgres server.mp4 13.43 MiB 5. Retrieving Information with Queries/1. Import data from a CSV.mp4 10.99 MiB 5. Retrieving Information with Queries/2. Retrieve information with a SELECT query.mp4 15.39 MiB 5. Retrieving Information with Queries/3. Helpful pgAdmin Query Tool interface elements.mp4 11.47 MiB 5. Retrieving Information with Queries/4. Join tables for additional information.mp4 15.26 MiB 5. Retrieving Information with Queries/5. Save a query as a database view.mp4 11.06 MiB 5. Retrieving Information with Queries/6. Challenge- Import data and write queries.mp4 1.90 MiB 5. Retrieving Information with Queries/7. Solution- Import data and write queries.mp4 18.90 MiB 6. Managing Data/1. Add indexes to a table.mp4 14.48 MiB 6. Managing Data/2. Automatically fill in default values.mp4 10.54 MiB 6. Managing Data/3. Constrain acceptable input values.mp4 15.65 MiB 6. Managing Data/4. Challenge- Add data constraints.mp4 1.62 MiB 6. Managing Data/5. Solution- Add data constraints.mp4 18.46 MiB 7. Database Administration in PostgreSQL/1. User accounts and roles.mp4 11.71 MiB 7. Database Administration in PostgreSQL/2. Grant privileges to a role.mp4 13.94 MiB 7. Database Administration in PostgreSQL/3. Backup and restore a database.mp4 12.23 MiB 7. Database Administration in PostgreSQL/4. Start and stop the server.mp4 12.38 MiB 8. Conclusion/1. Next steps.mp4 2.56 MiB Ex_Files_PostgreSQL_EssT.zip 6.88 KiB