Career Tracks
Free Courses
Practice
Work Experience
Projects
More
For Employers
INR
Sign in
Start Free
Course Contents (0/57)
SQL Basics
Micro Free Courses
SQL Basics
57 lessons
1. INTRODUCTION TO SQL & DATABASES
Video lesson
1. SQL OVERVIEW & FIRST QUERY
3m
Video lesson
2. BASIC SELECT
1m
Interactive tutorial
3. QUIZ: RDBMS, SQL Overview
5m
Assignment
4. Hands-on: Your First SELECT
5m
2. DATA RETRIEVAL & FILTERING
Video lesson
1. WHERE CLAUSE
12m
Reading
2. THE IN OPERATOR
7m
Interactive tutorial
3. QUIZ: WHERE CLAUSE
13m
Assignment
4. CODING: WHERE CLAUSE - 1
5m
Assignment
5. CODING: WHERE CLAUSE - 2
5m
Assignment
6. CODING: WHERE CLAUSE - 3
5m
Video lesson
7. CASE WHEN
9m
Interactive tutorial
8. QUIZ: CASE WHEN
11m
Assignment
9. CODING: CASE WHEN
6m
Video lesson
10. STRING FUNCTIONS
12m
Interactive tutorial
11. QUIZ: STRING FUNCTIONS
12m
Assignment
12. CODING: STRING FUNCTIONS
5m
Video lesson
13. DATE FUNCTIONS
4m
Interactive tutorial
14. QUIZ: DATE FUNCTIONS
10m
Assignment
15. CODING: DATE FUNCTIONS
6m
Video lesson
16. SELECT DISTINCT
2m
Interactive tutorial
17. QUIZ: MODULE 2
12m
Assignment
18. CODING: MODULE 2 - 1
6m
Assignment
19. CODING: MODULE 2 - 2
7m
3. AGGREGATIONS & GROUP BY, ORDER BY
Video lesson
1. AGGREGATE FUNCTIONS
12m
Interactive tutorial
2. QUIZ: AGGREGATE FUNCTIONS
11m
Assignment
3. CODING: AGGREGATE FUNCTIONS
5m
Video lesson
4. ORDER BY
2m
Video lesson
5. GROUP BY ORDER BY
11m
Interactive tutorial
6. QUIZ: GROUP BY and ORDER BY
12m
Assignment
7. CODING: GROUP BY ORDER BY
5m
Video lesson
8. HAVING CLAUSE AND WHERE
4m
Interactive tutorial
9. QUIZ: HAVING CLAUSE
11m
Assignment
10. CODING: HAVING CLAUSE AND WHERE
6m
Video lesson
11. LIMIT AND ALIASING
4m
Assignment
12. CODING: LIMIT and ALIASING
6m
Interactive tutorial
13. QUIZ: LIMIT and ALIASING
12m
Interactive tutorial
14. QUIZ: MODULE 3
12m
Assignment
15. CODING: MODULE 3 - 1
6m
Assignment
16. CODING: MODULE 3 - 2
7m
Assignment
17. CODING: MODULE 3 - 3
5m
4. JOINS, UNION, NULL HANDLING
Video lesson
1. JOINS - INNER, LEFT AND RIGHT
17m
Video lesson
2. JOINS - FULL, CROSS JOIN
10m
Interactive tutorial
3. QUIZ: JOINS
14m
Assignment
4. CODING: JOINS - 1
7m
Assignment
5. CODING: JOINS - 2
7m
Video lesson
6. UNION AND UNION ALL
7m
Interactive tutorial
7. QUIZ: UNION AND UNION ALL
12m
Assignment
8. CODING: UNION AND UNION ALL
7m
Video lesson
9. NULL VALUES
2m
Video lesson
10. NULL HANDLING
15m
Video lesson
11. CONVERTING DATA TYPES
2m
Interactive tutorial
12. QUIZ: NULL AND CONVERSIONS
12m
Interactive tutorial
13. QUIZ: MODULE 4
14m
Assignment
14. CODING: MODULE 4 - 1
8m
Assignment
15. CODING: MODULE 4 - 2
10m
Assignment
16. CODING: MODULE 4 - 3
8m
Assignment
17. CODING: MODULE 4 - 4
6m
Browse Topfolio
All courses
Practice
Projects
Career tracks
Home
/
Courses
/
SQL Basics
/
JOINS, UNION, NULL HANDLING
/
QUIZ: JOINS
Back to JOINS, UNION, NULL HANDLING
QUIZ: JOINS
JOINS
14 minutes
Interactive tutorial
🎯 Free Guest Mode: You are learning for free. Sign in to save your completion progress and quiz answers.
Sign in free
Question 1 of 20
Answer saved
0 answered
What is the main purpose of a SQL JOIN?
To combine rows from two or more tables based on a related column between them.
To merge two databases into one.
To permanently delete duplicates across tables.
To copy rows from one table to another.
Previous
Next
← Back to JOINS - FULL, CROSS JOIN
Feedback