Learn how to use PostgreSQL in this full course. PostgreSQL is a general purpose and objectrelational database management system. It is the most advanced open source database system widely used to build backend 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

✏ Course from Amigoscode.
Subscribe to Amigoscode YouTube channel | http://bit.ly/2HpF5V8
Visit Amigoscode.com for more courses | http://bit.ly/2JgGW0w
Full Playlist Available Here | http://bit.ly/2ClGPdY
Follow Amigoscode on Instagram | http://bit.ly/2TSkA9w
Join Amigoscode Closed Facebook Group | http://bit.ly/2FbuIkx



Learn to code for free and get a developer job: https://www.freecodecamp.org

Read hundreds of articles on programming: https://medium.freecodecamp.org

And subscribe for new videos on technology: https://youtube.com/subscription_cent...