PostgreSQL Tutorial Full Course 2022

Опис:

I provide here a comprehensive PostgreSQL tutorial designed to help you master PostgreSQL. The course covers the basics of relational database systems, database design, data types, CRUD operations, and advanced SQL concepts such as joins, aggregates, views, and functions. It also delves into PL/pgSQL programming including variables, loops, conditions and stored procedures. Throughout the video, timestamps guide you through each topic: the Intro at 00:00, Why Use Postgres? at 00:30, Create a Database at 03:53, Design a Database at 04:46, adding data at 16:36, joins at 1:05:00, aggregation at 1:32:18, PL/pgSQL examples at 2:07:08 and triggers at 3:09:35, among others. This self‑contained training offers hands‑on examples to reinforce learning.