Youtor
Learn PostgreSQL Tutorial Full Course for Beginners
YOUR LINK HERE:
http://youtube.com/watch?v=qw--VYLpxG4
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. • ❤️ Try interactive Databases courses we love, right in your browser: https://scrimba.com/freeCodeCamp-Data... (Made possible by a grant from our friends at Scrimba) • ⭐️ 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...
#############################
