Learn PostgreSQL Tutorial – Full Course for Beginners
August 22, 2024 2024-08-22 23:03
Learn PostgreSQL Tutorial – Full Course for Beginners
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
✏️ 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_center?add_user=freecodecamp
source
Comments (23)
@riascho
CTRL + L
is clearing the screen!
@pradeenkrishnag2368
SQL is not a programming language 5:34. That I can use a book to drive a nail into a plank of wood doesn't make the book a hammer.
@Bekra2
⌨ (2:12:32) Coalesce
⌨ (3:01:36) How to Update Records
@Bekra2
1:15:24
@riascho
doing this in 2024 – you will need the gender to be longer than VARCHAR(7) for the Mockaroo data 😉
@aditidump
Link to the resources mentioned: https://drive.google.com/drive/folders/1v0I19Ed2his8otHRLm5i6W7feD9sIMc6
@aditidump
great tutorial nelson! very intuitive and well structured
@osjerick
8:41 A relational database doesn't necessarily require relationships between tables to be considered relational. A 'relation' in this context is simply a table, which is a set of tuples (rows) with attributes (columns) drawn from different domains. This concept is fundamental to relational algebra.
@timothyajani7100
Finally I've faced my Fears. This is the best database course ever. I'll be done with the course today. I never knew database could be this easy. I'm so happy
@ShermukhammadKarimov
i can access this amazing tutorial for free. That's why I love 21st century. My huge thanks to Nelson. I feel very blessed.
@harisahmed4734
it should be better if you write queries on IDE not terminal
@user-ib7ir9hl7k
Thank you so much! I watched this, learned and i am happy ))
@shrdn2960
Let's take a second to appreciate how BASED the instructor is. Sees 3rd gender in the 'gender' column? =>Says immediately "This doesn't make any sense." He said what he said. Then proceeds to make sure there can be only 2 genders in the column(based) and then just deletes the person with the nonsense gender. Unfathomably based.
@mohamedjamaludeen7179
Good For Beginners…
@richard1991ish
also just going to take a moment to appreciate how excellent this tutorial is. Clear, concise, straight to the point with real-world examples. Worked through the whole thing, and learned a TON. TYSM! ⭐⭐⭐⭐⭐
@raidoung4100
is this tutorial still valid in 2024?
@sricharanprasad9682
@28:38 im not able to find servers in pgadmin4 can someone help on this please
@user-kn4oi9oh4i
Finished this in 3 days! Thank you good sir
@SatishKumar-cy8ld
man, could to tell how to develop english communication skills
@su-mu
8:09
@vedeshp3274
I really appreciate everything in this course
It was perfect course for me
very nicely explained
Thank You !
If you can provide the link for the advanced postgresql course , that would be great!
@Zfcx11
2 very useful videos for those facing problems in connecting to database step at 35:50
https://youtu.be/0EBkVzIBnoc?si=vXTuWtjoie5JgJbq
https://youtu.be/Ak9tN4NSMFQ?si=FaCCQydF2iDlmXpK
@joesuh7492
not easy to follow on pg16, but prolly cuz its updated version :/