💻 Data & SQL Tutorial: Top Secret Advanced Queries
Data & SQL Tutorial: Top Secret Advanced Queries
Dive deep into the world of SQL with this comprehensive tutorial covering essential concepts like functions, aggregates, joins, and subqueries. This video provides clear explanations and practical examples to help you level up your SQL skills.
After watching this video, you will be able to:
0:00 Describe join concepts and syntax.
2:05 Differentiate types of joins
5:00 Write queries that use Inner Joins
7:20 Left and Right Outer Joins.
8:33 Describe queries that use Full Joins
8:46 Write queries that use cross joins.
10:15 Understand queries that use self joins.
10:35 Categorize built-in functions
11:40 Use Scalar functions
16:40 Use Logical functions
19:00 Use ranking and rowset functions
20:55 Use aggregate functions
23:58 Summarize data with GROUP BY
26:30 Filter groups with HAVING
28:00 Lab Activity
30:08 Understand what subqueries are
31:36 Use scalar subqueries
34:42 Use multi-valued subqueries
37:18 Use self-contained & correlated subqueries
39:20 Lab Activity
40:18 Recap
Whether you're a beginner or looking to refresh your knowledge, this video is packed with valuable information to help you write more efficient and powerful SQL queries.
#sql #database #tutorial #functions #aggregates #joins #subqueries #programming #learnsql
