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
/
DATA RETRIEVAL & FILTERING
/
QUIZ: CASE WHEN
Back to DATA RETRIEVAL & FILTERING
QUIZ: CASE WHEN
CASE WHEN
11 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 15
Answer saved
0 answered
What is the primary purpose of the CASE WHEN statement in SQL?
To define table constraints
To create conditional logic in SQL queries
To declare variables in SQL
To perform joins between tables
Previous
Next
← Back to CASE WHEN
Feedback