Completed
) Coalesce
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Learn PostgreSQL Tutorial - Full Course for Beginners
Automatically move to the next video in the Classroom when playback concludes
- 1 ) What is a Database
- 2 ) What is SQL And Relational Database
- 3 ) What is PostreSQL AKA Postrgres
- 4 ) PostgreSQL Installation (Mac OS)
- 5 ) PostgreSQL Installation (Windows)
- 6 ) GUI Clients vs Terminal/CMD Clients
- 7 ) Setup PSQL (MAC OS)
- 8 ) Setup PSQL (Windows)
- 9 ) How to Create Database
- 10 ) How to Connect to Databases
- 11 ) A Very Dangerous Command
- 12 ) How To Create Tables
- 13 ) Creating Tables Without Constraints
- 14 ) Creating Tables with Constraints
- 15 ) Insert Into
- 16 ) Insert Into Example
- 17 ) Generate 1000 Rows with Mockaroo
- 18 ) Select From
- 19 ) Order By
- 20 ) Distinct
- 21 ) Where Clause and AND
- 22 ) Comparison Operators
- 23 ) Limit, Offset & Fetch
- 24 ) IN
- 25 ) Between
- 26 ) Like And iLike
- 27 ) Group By
- 28 ) Group By Having
- 29 ) Adding New Table And Data Using Mockaroo
- 30 ) Calculating Min, Max & Average
- 31 ) Sum
- 32 ) Basics of Arithmetic Operators
- 33 ) Arithmetic Operators (ROUND)
- 34 ) Alias
- 35 ) Coalesce
- 36 ) NULLIF
- 37 ) Timestamps And Dates Course
- 38 ) Adding And Subtracting With Dates
- 39 ) Extracting Fields From Timestamp
- 40 ) Age Function
- 41 ) What Are Primary Keys
- 42 ) Understanding Primary Keys
- 43 ) Adding Primary Key
- 44 ) Unique Constraints
- 45 ) Check Constraints
- 46 ) How to Delete Records
- 47 ) How to Update Records
- 48 ) On Conflict Do Nothing
- 49 ) Upsert
- 50 ) What Is A Relationship/Foreign Keys
- 51 ) Adding Relationship Between Tables
- 52 ) Updating Foreign Keys Columns
- 53 ) Inner Joins
- 54 ) Left Joins
- 55 ) Deleting Records With Foreign Keys
- 56 ) Exporting Query Results to CSV
- 57 ) Serial & Sequences
- 58 ) Extensions
- 59 ) Understanding UUID Data Type
- 60 ) UUID As Primary Keys
- 61 ) Conclusion
