Learn PostgreSQL Tutorial - Full Course for Beginners

Overview

This course teaches learners how to use PostgreSQL, a general-purpose and object-relational database management system. By the end of the course, students will be able to install PostgreSQL, create databases and tables, manipulate data, work with constraints, use various SQL commands like SELECT, JOIN, and GROUP BY, understand primary keys and relationships, and perform advanced operations like exporting query results and working with extensions. The course employs a tutorial-based teaching method with hands-on examples and practical exercises. It is designed for beginners who want to learn how to work with databases using PostgreSQL.

Syllabus

) What is a Database.
) What is SQL And Relational Database.
) What is PostreSQL AKA Postrgres.
) PostgreSQL Installation (Mac OS).
) PostgreSQL Installation (Windows).
) GUI Clients vs Terminal/CMD Clients.
) Setup PSQL (MAC OS).
) Setup PSQL (Windows).
) How to Create Database.
) How to Connect to Databases.
) A Very Dangerous Command.
) How To Create Tables.
) Creating Tables Without Constraints.
) Creating Tables with Constraints.
) Insert Into.
) Insert Into Example.
) Generate 1000 Rows with Mockaroo.
) Select From.
) Order By.
) Distinct.
) Where Clause and AND.
) Comparison Operators.
) Limit, Offset & Fetch.
) IN.
) Between.
) Like And iLike.
) Group By.
) Group By Having.
) Adding New Table And Data Using Mockaroo.
) Calculating Min, Max & Average.
) Sum.
) Basics of Arithmetic Operators.
) Arithmetic Operators (ROUND).
) Alias.
) Coalesce.
) NULLIF.
) Timestamps And Dates Course.
) Adding And Subtracting With Dates.
) Extracting Fields From Timestamp.
) Age Function.
) What Are Primary Keys.
) Understanding Primary Keys.
) Adding Primary Key.
) Unique Constraints.
) Check Constraints.
) How to Delete Records.
) How to Update Records.
) On Conflict Do Nothing.
) Upsert.
) What Is A Relationship/Foreign Keys.
) Adding Relationship Between Tables.
) Updating Foreign Keys Columns.
) Inner Joins.
) Left Joins.
) Deleting Records With Foreign Keys.
) Exporting Query Results to CSV.
) Serial & Sequences.
) Extensions.
) Understanding UUID Data Type.
) UUID As Primary Keys.
) Conclusion.