Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
4
JOINS, UNION, NULL HANDLING
INNER JOIN, LEFT/RIGHT JOIN, FULL JOIN, UNION, UNION ALL, NULL handling, Data Type Conversions
Module Progress0% Complete
158 min total
17 Lessons
0 Completed
Module Content
JOINS - INNER, LEFT AND RIGHT
Understand combining data from multiple tables using INNER/LEFT/RIGHT JOINS
17 minVideo
Start
JOINS - FULL, CROSS JOIN
Understand how FULL JOIN and CROSS JOIN work
10 minVideo
Start
QUIZ: JOINS
JOINS
14 minTutorial
Start
CODING: JOINS - 1
7 minAssignment
Start
CODING: JOINS - 2
7 minAssignment
Start
UNION AND UNION ALL
Understand how to combine data from 2 queries using UNION and UNION ALL
7 minVideo
Start
QUIZ: UNION AND UNION ALL
UNION AND UNION ALL
12 minTutorial
Start
CODING: UNION AND UNION ALL
7 minAssignment
Start
NULL VALUES
Understand meaning of NULL values
2 minVideo
Start
NULL HANDLING
Understand how to handle NULL values
15 minVideo
Start
CONVERTING DATA TYPES
Understand converting different data types
2 minVideo
Start
QUIZ: NULL AND CONVERSIONS
NULL AND CONVERSIONS
12 minTutorial
Start
QUIZ: MODULE 4
Combines relational logic (JOINs), set operations (UNION), and data integrity (NULLs & casting)
14 minTutorial
Start
CODING: MODULE 4 - 1
Solve a short case to select the right join type and compute metrics.
8 minAssignment
Start
CODING: MODULE 4 - 2
10 minAssignment
Start
CODING: MODULE 4 - 3
8 minAssignment
Start
CODING: MODULE 4 - 4
6 minAssignment
Start