Learn PostgreSQL Tutorial - Full Course for Beginners

Overview

Embark on a comprehensive 4-5 hour tutorial to master PostgreSQL, the advanced open-source relational database management system widely used in back-end development. Begin with fundamental concepts like databases, SQL, and PostgreSQL's unique features. Progress through installation on Mac and Windows, followed by hands-on experience with both GUI and command-line interfaces. Dive into essential database operations, including creating databases and tables, inserting data, and performing complex queries. Explore advanced topics such as constraints, joins, foreign keys, and UUID implementation. By the end, gain practical skills in database design, querying, and management, preparing you to leverage PostgreSQL effectively in real-world applications.

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.