SQL - 12 Order of Operations and WHY
This video walks you through the SQL 12 order of operations. Most commonly used SQL Clauses are covered in this video, but of course, not every SQL Clause is present in this video.
I hope you enjoyed this video. Feel free to get access to my FREE Technical Resources https://www.techengineerschool.com/co... where I give away stuff worth 10X more than this video for FREE.
And you will get emails whenever I publish new content.
Or maybe you don’t want access to my juicy free technical resources but you still wanna be in the know, feel free to join my [free technical newsletter](https://www.techengineerschool.com/f/....
Follow me on [Youtube]( / evidencen )
Follow me on [Linkedin]( / evidencen )
Follow me on [Github](https://github.com/evidenceN/)
Follow me on [Twitter]( / evidencenmedia )
If you want to contact me, speak to me [here](https://www.techengineerschool.com/su...)
Want me to create a similar technical video for your brand? [Contact me here](https://www.techengineerschool.com/da....
If you want to run these queries on your own computer,
1. First download [SQLite](https://sqlitebrowser.org/dl/) or use [SQLite Online](https://sqliteonline.com/)
2. Second download the Northwind DB from my website for FREE when you sign up for my [FREE Tech Resources](https://www.techengineerschool.com/co...)
3. Third, Open the Northwind DB with SQLite
4. Copy and paste the queries above
5. And Lastly, Enjoy your Query Exploration
TIMESTAMPS:
0:00 - SQL Order of Operations Introduction
1:17 - #1 - SQL “FROM” Clause
4:16 - #2 - SQL “JOIN” CLause
7:11 - #3 - SQL “WHERE” Clause
10:15 - Use more than 1 column in a “WHERE” SQL Statement
11:32 - Use “WHERE” Clause to filter “STRING” Data
14:26 - No “Aggregate Value in SQL WHERE” Clause. Using Aggregate value in SQL “WHERE” Clause
16:35 - #4 - SQL “GROUP BY” Clause
23:59 - Use SQL “GROUP BY with an Aggregate” Function
26:53 - Summary of SQL “GROUP BY” Clause
27:54 - #5 - SQL “AGGREGATE” Functions
32:49 - Summary of “WHERE vs HAVING” clause
33:28 - #6 - SQL “HAVING” Clause
35:51 - #7 - SQL “WINDOW Functions”
36:50 - How SQL “Window Functions” work Explained in Detail.
41:35 - How to use SQL Window Functions with Row Number and Aggregate Functions.
46:37 - #8 - SQL “SELECT” Clause
48:42 - #9 - SQL “DISTINCT” Clause
48:59 - SQL “Distinct” vs “Group By” Clause
49:32 - SQL “DISTINCT” Practical Example
51:31 - #10 - SQL “UNION” and “UNION ALL” Clause
52:23 - SQL “JOIN” vs “UNION”
56:59 - #11 - SQL “ORDER BY” Clause
58:43 - #12 - SQL “LIMIT” & “OFFSET”. “OFFSET vs LIMIT”
60:00 - Practical Example of SQL OFFSET & LIMIT
60:04 - Additional resources for you. SUPPORT this channel
60:06:04 - How to RUN these queries on your local computer
Join to Simply say "Thank you" to me:
/ @techengineerschool
Watch video SQL - 12 Order of Operations and WHY online without registration, duration hours minute second in high quality. This video was added by user TechEngineerSchool 08 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 11 once and liked it lik people.