PostgreSQL Essential Training

Focused View

Adam Wilbert

3:00:05

142 View

01 - Introduction

01 - Manage relational data with PostgreSQL.mp4

00:47

02 - 1. Getting Started with PostgreSQL

01 - What is PostgreSQL.mp4

04:59

02 - Download and install PostgreSQL.mp4

07:00

03 - Install PostgreSQL with Docker.mp4

05:34

04 - Connect to the server with psql.mp4

08:04

05 - Browse the server with a graphical interface.mp4

05:19

06 - Connect pgAdmin to Docker.mp4

04:35

07 - Tour the pgAdmin interface.mp4

04:48

08 - Use pgAdmins toolset.mp4

05:31

09 - Create objects with pgAdmins dialog workflows.mp4

05:56

03 - 2. An Introduction to Relational Databases

01 - The structure of a database table.mp4

04:16

02 - PostgreSQL native data types.mp4

06:25

03 - Join tables together with relationships.mp4

03:03

04 - Create a table and insert rows of data.mp4

05:48

05 - Challenge Create a table.mp4

00:45

06 - Solution Create a table.mp4

04:49

04 - 3. Building a Database

01 - Organize tables with schemas.mp4

06:35

02 - Create a table with pgAdmin.mp4

06:57

03 - Link primary and foreign keys.mp4

06:38

04 - Enforce referential integrity on related records.mp4

06:24

05 - Challenge Execute a command on the Postgres server.mp4

00:55

06 - Solution Execute a command on the Postgres server.mp4

05:19

05 - 4. Retrieving Information with Queries

01 - Import data from a CSV.mp4

03:39

02 - Retrieve information with a SELECT query.mp4

04:43

03 - Helpful pgAdmin Query Tool interface elements.mp4

03:24

04 - Join tables for additional information.mp4

04:45

05 - Save a query as a database view.mp4

03:15

06 - Challenge Import data and write queries.mp4

01:00

07 - Solution Import data and write queries.mp4

06:08

06 - 5. Managing Data

01 - Add indexes to a table.mp4

06:43

02 - Automatically fill in default values.mp4

03:36

03 - Constrain acceptable input values.mp4

05:31

04 - Challenge Add data constraints.mp4

00:54

05 - Solution Add data constraints.mp4

06:02

07 - 6. Database Administration in PostgreSQL

01 - User accounts and roles.mp4

05:08

02 - Grant privileges to a role.mp4

04:09

03 - Backup and restore a database.mp4

05:04

04 - Start and stop the server.mp4

04:08

08 - Conclusion

01 - Next steps.mp4

01:29

Description

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!

More details

User Reviews

Rating

average 0

Total votes0

Focused display

PostgreSQL

Database Programming

Adam Wilbert

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.