PostgreSQL Tutorial

Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and object-relational database management system. It is the most advanced open source database system widely used to build back-end systems. 


⭐️ Contents ⭐️

 ⌨️ (0:03:16) What is a Database 

⌨️ (0:05:17) What is SQL And Relational Database 

⌨️ (0:09:10) What is PostreSQL AKA Postrgres 

⌨️ (0:10:53) PostgreSQL Installation (Mac OS) 

⌨️ (0:14:21) PostgreSQL Installation (Windows) 

⌨️ (0:17:38) GUI Clients vs Terminal/CMD Clients 

⌨️ (0:21:39) Setup PSQL (MAC OS) 

⌨️ (0:25:22) Setup PSQL (Windows) 

⌨️ (0:30:15) How to Create Database 

⌨️ (0:33:35) How to Connect to Databases 

⌨️ (0:38:12) A Very Dangerous Command 

⌨️ (0:41:37) How To Create Tables 

⌨️ (0:45:46) Creating Tables Without Constraints 

⌨️ (0:49:12) Creating Tables with Constraints 

⌨️ (0:55:55) Insert Into 

⌨️ (0:59:14) Insert Into Example 

⌨️ (1:02:36) Generate 1000 Rows with Mockaroo 

⌨️ (1:12:28) Select From 

⌨️ (1:15:18) Order By 

⌨️ (1:19:53) Distinct 

⌨️ (1:21:59) Where Clause and AND 

⌨️ (1:25:29) Comparison Operators 

⌨️ (1:29:35) Limit, Offset & Fetch 

⌨️ (1:32:43) IN 

⌨️ (1:35:43) Between 

⌨️ (1:37:45) Like And iLike 

⌨️ (1:43:10) Group By 

⌨️ (1:46:41) Group By Having 

⌨️ (1:52:08) Adding New Table And Data Using Mockaroo 

⌨️ (1:55:40) Calculating Min, Max & Average 

⌨️ (1:59:48) Sum 

⌨️ (2:01:55) Basics of Arithmetic Operators 

⌨️ (2:05:59) Arithmetic Operators (ROUND) 

⌨️ (2:09:43) Alias 

⌨️ (2:12:32) Coalesce 

⌨️ (2:16:15) NULLIF 

⌨️ (2:20:21) Timestamps And Dates Course 

⌨️ (2:23:21) Adding And Subtracting With Dates 

⌨️ (2:25:58) Extracting Fields From Timestamp 

⌨️ (2:27:28) Age Function 

⌨️ (2:29:24) What Are Primary Keys 

⌨️ (2:31:23) Understanding Primary Keys 

⌨️ (2:36:26) Adding Primary Key 

⌨️ (2:40:55) Unique Constraints 

⌨️ (2:49:15) Check Constraints 

⌨️ (2:54:45) How to Delete Records 

⌨️ (3:01:36) How to Update Records 

⌨️ (3:05:55) On Conflict Do Nothing 

⌨️ (3:11:09) Upsert 

⌨️ (3:16:41) What Is A Relationship/Foreign Keys 

⌨️ (3:19:48) Adding Relationship Between Tables 

⌨️ (3:25:04) Updating Foreign Keys Columns 

⌨️ (3:29:30) Inner Joins 

⌨️ (3:35:17) Left Joins 

⌨️ (3:40:53) Deleting Records With Foreign Keys 

⌨️ (3:47:27) Exporting Query Results to CSV 

⌨️ (3:50:42) Serial & Sequences 

⌨️ (3:57:18) Extensions 

⌨️ (3:59:39) Understanding UUID Data Type 

⌨️ (4:05:54) UUID As Primary Keys 

⌨️ (4:16:30) Conclusion 




















Viewed 44 Times

Post On 2020-05-26