Section 1: Introduction to the Course
Section 2: Basic Concepts
Section 3: Preparing Data for Analysis
Section 4: Introduction to SQL
Section 5: Basic SQL Queries
-
Section Introduction
-
COUNT () and GROUP BY (11:12)
-
Your turn: Practical Activity on COUNT () and GROUP BY
-
Answers: Practical Activity on COUNT and GROUP BY (4:47)
-
AS, ORDER BY and SUM () (10:04)
-
Your Turn: Practical Activity on AS, ORDER BY and SUM ()
-
Answers: Practical Activity on AS, ORDER BY and SUM () (2:25)
-
MIN (), MAX () and LEFT (6:31)
-
Your turn: Practical Activity on MIN (), MAX () and LEFT
-
Answers: Practical Activity on MIN (), MAX () and LEFT (1:21)
-
DISTINCT (1:28)
-
IN () (3:12)
-
Comparison Operators and HAVING (4:17)
-
Your Turn: Practical activity on Comparison Operators and HAVING
-
Answers: Pracitcal activity on Comparison Operators and HAVING (2:07)
Section 6: Conclusion
