SQL Tutorial (JOIN, GROUP BY, SUBQUERY, HAVING, IN)

In this SQL tutorial (Part 2) we will learn why databases are called relational, what is Primary and Foreign Keys, how to create Subqueries, IN keywords, types of JOIN (INNER, LEFT, RIGHT, FULL), UNION and UNION ALL, GROUP BY and HAVING statements, and how to export data from SQL. Dataset used in this video - https://www.kaggle.com/datasets/olistbr/brazilian-ecommerce/data 💌 Join my newsletter and get access to various freebies (Books and checklists, CV template, Portfolio Projects) - https://stan.store/KarinaDataScientist 🧠 AI to help you analyse your data - https://powerdrill.ai/?via=karina-samsonova ---------------------- Timestamps: ---------------------- 00:00 Intro 00:28 Relational databases 01:21 Tables in DB 02:37 Primary Key & Foreign Key 03:24 Subquery 07:39 IN 10:12 Joins 10:45 INNER JOIN 14:28 LEFT JOIN 15:45 RIGHT JOIN 17:05 UNION 18:16 UNION ALL 20:00 GROUP BY 23:29 HAVING 24:59 How to export data 🎥 Other videos you might be interested in ---------------------- https://youtu.be/K_qXkrdcTu8 ---------------------- About me ---------------------- Hi, my name is Karina and I'm a finance person turned data person. My mission is to transform intimidating tech into accessible tools. I aim to empower 1 million people to harness the power of AI, Python, SQL, and Excel to work smarter, not harder. Contact ---------------------- Youtube: youtube comments are by far the best way to get a response from me! email for business inquiries only: [email protected] ---------------------- Social Media: ---------------------- TikTok: https://www.tiktok.com/@karinadatascientist Instagram: https://www.instagram.com/karinadatascientist/ Linkedin: https://www.linkedin.com/in/karina-samsonova/ #sql #dataanalysis #sqlforbeginners