Watch PostgreSQL Essential Training Free Online - Full Video Classroom | MJ Accedemy

LinkedIn – PostgreSQL Essential Training 2023-7

Download Course (Free)

Lecture 19/39

00:00/00:00

Lecture 19 of 39

Enforce referential integrity on related records

Download Course (Free)

Course Content

0 / 39 completed

Section 1: Getting Started with PostgreSQL9 videos

Download and install PostgreSQL

What is PostgreSQL

Install PostgreSQL with Docker

Connect to the server with psql

Browse the server with a graphical interface

Connect pgAdmin to Docker

Tour the pgAdmin interface

Use pgAdmin’s toolset

Create objects with pgAdmin's dialog workflows

Section 2: Introduction1 videos

Manage relational data with PostgreSQL

Section 3: An Introduction to Relational Databases6 videos

The structure of a database table

PostgreSQL native data types

Join tables together with relationships

Create a table and insert rows of data

Solution Create a table

Challenge Create a table

Section 4: Building a Database6 videos

Organize tables with schemas

Create a table with pgAdmin

Enforce referential integrity on related records

7mNow Playing

Link primary and foreign keys

Challenge Execute a command on the Postgres server

Solution Execute a command on the Postgres server

Section 5: Retrieving Information with Queries7 videos

Retrieve information with a SELECT query

Import data from a CSV

Helpful pgAdmin Query Tool interface elements

Join tables for additional information

Save a query as a database view

Challenge Import data and write queries

Solution Import data and write queries

Section 6: Managing Data5 videos

Add indexes to a table

Automatically fill in default values

Constrain acceptable input values

Challenge Add data constraints

Solution Add data constraints

Section 7: Database Administration in PostgreSQL4 videos

User accounts and roles

Grant privileges to a role

Start and stop the server

Backup and restore a database

Section 8: Conclusion1 videos

Next steps

About this Lecture

Section: Building a Database • Size: 14.35 MB • Duration: 7m

Course Summary

PostgreSQL Essential Training is a PostgreSQL management system training course published by LinkedIn’s online academy. PostgreSQL is trusted with critical information by some of the world’s largest companies. It’s also highly flexible, making it a great choice for data science researchers, educators, nonprofits, and businesses of all sizes. PostgreSQL is a powerful, open source relational database management system (RDBMS) known for its extensibility, standards compliance, and advanced features. In this training course, you will get to know PostgreSQL and understand its basic concepts and principles. In this course you will learn how to build your own server and create a customized relational database.Protecting your data against unauthorized access, ensuring accuracy and simplifying the search process are features of the PostgreSQL management system. PostgreSQL is a versatile and reliable database system that can be customized to meet the needs of a wide variety of applications. These features and capabilities have led to a demand for people who are skilled in working with this system. They have and are experts, more. After completing this training course, you will be able to use all the potential of the PostgreSQL management system.

Course Content

0 / 39 completed

Section 1: Getting Started with PostgreSQL9 videos

Download and install PostgreSQL

What is PostgreSQL

Install PostgreSQL with Docker

Connect to the server with psql

Browse the server with a graphical interface

Connect pgAdmin to Docker

Tour the pgAdmin interface

Use pgAdmin’s toolset

Create objects with pgAdmin's dialog workflows

Section 2: Introduction1 videos

Manage relational data with PostgreSQL

Section 3: An Introduction to Relational Databases6 videos

The structure of a database table

PostgreSQL native data types

Join tables together with relationships

Create a table and insert rows of data

Solution Create a table

Challenge Create a table

Section 4: Building a Database6 videos

Organize tables with schemas

Create a table with pgAdmin

Enforce referential integrity on related records

7mNow Playing

Link primary and foreign keys

Challenge Execute a command on the Postgres server

Solution Execute a command on the Postgres server

Section 5: Retrieving Information with Queries7 videos

Retrieve information with a SELECT query

Import data from a CSV

Helpful pgAdmin Query Tool interface elements

Join tables for additional information

Save a query as a database view

Challenge Import data and write queries

Solution Import data and write queries

Section 6: Managing Data5 videos

Add indexes to a table

Automatically fill in default values

Constrain acceptable input values

Challenge Add data constraints

Solution Add data constraints

Section 7: Database Administration in PostgreSQL4 videos

User accounts and roles

Grant privileges to a role

Start and stop the server

Backup and restore a database

Section 8: Conclusion1 videos

Next steps