Learn PostgreSQL Tutorial - Full Course for Beginners

[anshul-16]

Link to the video - https://www.youtube.com/watch?v=qw--VYLpxG4

Video Contents-
⌨️ 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