POSTGRESQL JOINS [Complete guide in 12 mins]
Welcome to my first video on this channel!
In today's tutorial, we dive deep into Postgres joins, demystifying Inner, Left, Right, Full Outer, Self, Cross, and Natural Joins. By the end of this video, you'll have a comprehensive understanding of these joins and how to use them effectively.
00:00 Introduction
00:12 What are Relational databases?
00:55 What are Primary and Foreign Keys?
02:15 What is an INNER JOIN? how does it work? and how to write an inner join SQL query?
04:46 What is a LEFT JOIN and RIGHT JOIN? What are the Differences and Use Cases?
06:56 What is a FULL OUTER JOIN? Combining Left and Right Joins
07:40 What is a SELF JOIN? Joining a Table with Itself
09:42 What is a CROSS JOIN? Exploring All Possible Combinations
10:21 What is a NATURAL JOIN? Simplifying Joins with Matching Column Names
📂 GitHub Gists with SQL Code:
https://gist.github.com/cudidotdev/2a...
🎮 Check out my web games at https://cudi.dev/games. Enjoy the rest of your day!
Email: [email protected]
Github: https://github.com/cudilala
Twitter: / cudilala_
LinkedIn: / augustine-madu-625168223
👍 If you found this tutorial helpful, please give it a like, share your thoughts, and ask questions in the comments below
🔔 Consider subscribing for more insightful tutorials. Thank you for watching, and have a great day!
📚 References:
Relational database: https://cloud.google.com/learn/what-i...
PostgreSQL joins: https://www.postgresqltutorial.com/po...
PostgreSQL inner join: https://www.postgresqltutorial.com/po...
PostgreSQL left join: https://www.postgresqltutorial.com/po...
PostgreSQL right join: https://www.postgresqltutorial.com/po...
PostgreSQL full outer join: https://www.postgresqltutorial.com/po...
PostgreSQL self join: https://www.postgresqltutorial.com/po...
PostgreSQL cross join: https://www.postgresqltutorial.com/po...
PostgreSQL natural join: https://www.postgresqltutorial.com/po...
Смотрите видео POSTGRESQL JOINS [Complete guide in 12 mins] онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь cudidotdev 05 Январь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 1,46 раз и оно понравилось 6 людям.