What You will Learn?

• 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