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
75 min total
17 Lessons
0 Completed
Module Content
JOINS - INNER, LEFT AND RIGHT
Understand combining data from multiple tables using INNER/LEFT/RIGHT JOINS
18 minVideo
Start
JOINS - FULL, CROSS JOIN
Understand how FULL JOIN and CROSS JOIN work
10 minVideo
Start
QUIZ: JOINS
JOINS
35 minTutorial
Start
CODING: JOINS - 1
15 minAssignment
Start
CODING: JOINS - 2
15 minAssignment
Start
UNION AND UNION ALL
Understand how to combine data from 2 queries using UNION and UNION ALL
8 minVideo
Start
QUIZ: UNION AND UNION ALL
UNION AND UNION ALL
15 minTutorial
Start
CODING: UNION AND UNION ALL
15 minAssignment
Start
NULL VALUES
Understand meaning of NULL values
3 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
15 minTutorial
Start
QUIZ: MODULE 4
Combines relational logic (JOINs), set operations (UNION), and data integrity (NULLs & casting)
25 minTutorial
Start
CODING: MODULE 4 - 1
Solve a short case to select the right join type and compute metrics.
15 minAssignment
Start
CODING: MODULE 4 - 2
15 minAssignment
Start
CODING: MODULE 4 - 3
15 minAssignment
Start
CODING: MODULE 4 - 4
15 minAssignment
Start