Faster SQL Queries: The WHERE Clause Secret
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... Improve Your SQL Performance!
This video will teach you how to improve the performance of your SQL queries by avoiding the use of functions in the WHERE clause. We will discuss the reasons why functions can slow down your queries, and we will provide you with some tips on how to rewrite your queries to avoid using functions. We will also discuss how to preprocess your data to avoid the need for functions in the future.
By the end of this video, you will have a better understanding of how to write more efficient SQL queries. This will help you to save time and resources, and it will also make your queries more responsive.
Join the Gambill DataSphere community to connect with other aspiring data professionals:
https://bit.ly/3Y4Nbc9
WHERE Clause Chapters:
00:00 Introduction
00:26 Filtering with WHERE
00:48 Why functions are inefficient
01:16 Using LIKE
01:44 SQL WHERE Examples in Azure Data Studio
03:34 Transform Your Data Upfront!
05:37 SQL STRING_SPLIT Example!
06:28 Putting all your SQL Skills together!
07:07 What does CROSS APPLY do?
07:59 Explaining STRING_SPLIT (How to Split Strings in SQL)
08:59 And Throw in a PIVOT! (How to PIVOT data in SQL)
10:25 Transforming with the end in mind!
10:51 WHERE Best Practices and Summary *** 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