This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Introduction to SQL
Section 1: Introduction to the Course
Section Introduction
The Course Content (1:51)
Section 2: Basic Concepts
Section Introduction
Relational and Non-Relational Databases and SQL (2:19)
Data Warehouse and SlicingDice (1:29)
Section 3: Preparing Data for Analysis
Section Introduction
Introduction to Preparing Data for Analysis (1:17)
SlicingDice's Key Concepts (6:08)
Preparing Data for querying Using SlicingDice (24:32)
Your Turn: Insert Data to SlicingDice
Section 4: Introduction to SQL
Section Introduction
The Skeleton of a Query (8:20)
Practical Activity
Practical Activity Resolution (4:31)
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
The End (0:47)
Practical Activity
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock