SQL Subqueries: What are they and how to use them?
Looking for more business related data content -
Businesses:
Reach out for a free consultation https://gambilldataengineering.com/co...
Learn more about starting your business's data journey: https://www.gambilldataengineering.co...
Individuals looking to learn more:
https://www.gambilldataengineering.co...
The NEW Data Roadmap:
https://www.gambilldataengineering.co... Unlock the power of SQL subqueries!
And avoid common efficiency pitfalls!
By the end of this video, you'll know exactly when to use subqueries and how to optimize your SQL queries for maximum performance!
Join the Gambill DataSphere: https://bit.ly/3Y4Nbc9
SQL Subquery Chapters:
00:00 Subqueries, what are they good for?
00:35 What will you learn?
00:46 What is a subquery
01:16 When / Why to use subqueries
01:35 Single Row / Inline subqueries
02:16 SQL Example of a inline subquery
05:16 Subquery in your from clause (Example in Azure data factory!)
07:48 How do you run just part of your whole query (subquery)
08:37 Troubleshooting ambiguous field errors
09:08 Best Practice to Resolving the ambiguous fields
12:18 Subquery in your where clause!
14:20 When and how to use subqueries
16:16 Nested queries!
16:56 Making your inline subquery efficient!
17:20 What have you learned? *** Affiliate links to great Data Engineering Books ****
Becoming a Data Head: https://amzn.to/4ebBzdb
Data Storytelling Cards: https://amzn.to/3VJVIjD
**Connect with Me**
/ gambilldataengineering
/ thegambill
/ databasemanagement
/ chris.gambill Codecademy: 50% off :
https://www.codecademy.com/checkout?p...
Plurasight:
https://www.pluralsight.com/pricing
What Matters Most:
https://amzn.to/3ASittW
54% off right now
Data Governance:
https://amzn.to/48ZUlCl
Data Warehouse Toolkit:
https://amzn.to/3Z1o2hx
32% off right now
Studio Beats Earbuds:
https://amzn.to/496LdvO
44% off! To support the channel:
https://buymeacoffee.com/gambilldata