03:42

Essential SQL - SQL using ChapGPT | Data Analysis Essentials

05:54

Do More with this FREE Excel Addin - Productivity Booster | Data Analysis Essentials

04:09

Essential SQL Practice - Completion, GIVEAWAY and MORE!! | Data Analysis Essentials

02:18

21. Essential SQL Practice - Q20 (Output Quarter data in Pivot format) | Data Analysis Essentials

02:32

20. Essential SQL Practice - Q19 (Customer with purchases in all years) | Data Analysis Essentials

01:39

19. Essential SQL Practice - Q18 (Top sales country for each employee) | Data Analysis Essentials

01:30

18. Essential SQL Practice - Q17 (Self join with multiple conditions) | Data Analysis Essentials

01:32

17. Essential SQL Practice - Q16 (Country total higher than overall avg) | Data Analysis Essentials

01:39

16. Essential SQL Practice - Q15 (Top customer by each category) | Data Analysis Essentials

01:45

15. Essential SQL Practice - Q14 (Sales only in last 6 months of a year) | Data Analysis Essentials

02:09

14. Essential SQL Practice - Q13 (Sales in one Country and not in other) | Data Analysis Essentials

01:56

13. Essential SQL Practice - Q12 (Sales by week) | Data Analysis Essentials

01:21

12. Essential SQL Practice - Q11 (Self join real-time example) | Data Analysis Essentials

01:50

11. Essential SQL Practice - Q10 (Output multiple values in single cell) | Data Analysis Essentials

01:01

10. Essential SQL Practice - Q9 (First order date for each customer) | Data Analysis Essentials

02:32

9. Essential SQL Practice - Q8 (Sales in exactly 1 country) | Data Analysis Essentials

01:08

8. Essential SQL Practice - Q7 (Totals by Day of Week) | Data Analysis Essentials

01:17

7. Essential SQL Practice - Q6 (Multiple Joins to find lowest value) | Data Analysis Essentials

01:12

6. Essential SQL Practice - Q5 (Current day sales less than previous day) | Data Analysis Essentials

00:52

5. Essential SQL Practice - Q4 (Data in one Table but not in the other) | Data Analysis Essentials

01:22

4. Essential SQL Practice - Q3 (Compare with previous and following days) | Data Analysis Essentials

02:02

3. Essential SQL Practice - Q2 (Top 3 and Bottom 3 by Total) | Data Analysis Essentials

01:37

2. Essential SQL Practice - Q1 (Total by Customers and Country) | Data Analysis Essentials

02:53

1. Essential SQL Practice - Introduction | Data Analysis Essentials

01:56

Essential SQL - Completion, GIVEAWAY and BONUS!! | Data Analysis Essentials

02:50

38. Essential SQL - Order Of Execution | Data Analysis Essentials

03:53

37. Essential SQL - Types Of Joins Recap | Data Analysis Essentials

01:09

36. Essential SQL - Cross Join | Data Analysis Essentials

02:07

35. Essential SQL - Self Join | Data Analysis Essentials

02:52

34. Essential SQL - Full Join | Data Analysis Essentials

04:06

33. Essential SQL - Left And Right Joins | Data Analysis Essentials

02:38

32. Essential SQL - Inner Join | Data Analysis Essentials

01:04

31. Essential SQL - Intersect Operator | Data Analysis Essentials

01:13

30. Essential SQL - Except Operator | Data Analysis Essentials

03:00

29. Essential SQL - Union Operator | Data Analysis Essentials

04:33

28. Essential SQL - Subquery vs CTE vs Temp Table vs View | Data Analysis Essentials

03:05

27. Essential SQL - Views | Data Analysis Essentials

02:17

26. Essential SQL - Temp Tables | Data Analysis Essentials

02:40

25. Essential SQL - CTE | Data Analysis Essentials

03:44

24. Essential SQL - Subqueries | Data Analysis Essentials

02:05

23. Essential SQL - Comments | Data Analysis Essentials

03:35

22. Essential SQL - Alias | Data Analysis Essentials

03:39

21. Essential SQL - Case Expression | Data Analysis Essentials

10:00

20. Essential SQL - Window Functions | Data Analysis Essentials

04:38

19. Essential SQL - Date and Time Functions | Data Analysis Essentials

06:27

18. Essential SQL - String Functions | Data Analysis Essentials

05:45

17. Essential SQL - Numeric Functions | Data Analysis Essentials

08:05

16. Essential SQL - Logical Operators | Data Analysis Essentials

04:47

15. Essential SQL - Comparison Operators | Data Analysis Essentials

03:04

14. Essential SQL - Arithmetic Operators | Data Analysis Essentials

05:36

13. Essential SQL - DQL examples (SELECT statement) | Data Analysis Essentials

03:33

12. Essential SQL - DQL (SELECT Statement) | Data Analysis Essentials

01:53

11. Essential SQL - TCL | Data Analysis Essentials

01:26

10. Essential SQL - DCL | Data Analysis Essentials

05:42

9. Essential SQL - DML | Data Analysis Essentials

02:36

8. Essential SQL - DDL Review Of Music Database | Data Analysis Essentials

05:08

7. Essential SQL - DDL | Data Analysis Essentials

03:00

6. Essential SQL - SQL Commands | Data Analysis Essentials

03:12

5. Essential SQL - Constraints | Data Analysis Essentials

02:52

4. Essential SQL - Datatypes | Data Analysis Essentials