Explore
Career Tracks
Micro Free Courses
Task Courses
Practice
Interview Practice
Work Experience
Projects
Career Track
Blog
Support
INR
Sign in
Micro Free Courses
SQL Basics
57 lessons
1. INTRODUCTION TO SQL & DATABASES
Video lesson
1. SQL OVERVIEW & FIRST QUERY
4m
Video lesson
2. BASIC SELECT
2m
Interactive tutorial
3. QUIZ: RDBMS, SQL Overview
5m
Assignment
4. Hands-on: Your First SELECT
10m
2. DATA RETRIEVAL & FILTERING
Video lesson
1. WHERE CLAUSE
13m
Reading
2. THE IN OPERATOR
5m
Interactive tutorial
3. QUIZ: WHERE CLAUSE
15m
Assignment
4. CODING: WHERE CLAUSE - 1
10m
Assignment
5. CODING: WHERE CLAUSE - 2
10m
Assignment
6. CODING: WHERE CLAUSE - 3
10m
Video lesson
7. CASE WHEN
9m
Interactive tutorial
8. QUIZ: CASE WHEN
15m
Assignment
9. CODING: CASE WHEN
10m
Video lesson
10. STRING FUNCTIONS
12m
Interactive tutorial
11. QUIZ: STRING FUNCTIONS
15m
Assignment
12. CODING: STRING FUNCTIONS
10m
Video lesson
13. DATE FUNCTIONS
5m
Interactive tutorial
14. QUIZ: DATE FUNCTIONS
15m
Assignment
15. CODING: DATE FUNCTIONS
15m
Video lesson
16. SELECT DISTINCT
2m
Interactive tutorial
17. QUIZ: MODULE 2
20m
Assignment
18. CODING: MODULE 2 - 1
15m
Assignment
19. CODING: MODULE 2 - 2
15m
3. AGGREGATIONS & GROUP BY, ORDER BY
Video lesson
1. AGGREGATE FUNCTIONS
12m
Interactive tutorial
2. QUIZ: AGGREGATE FUNCTIONS
15m
Assignment
3. CODING: AGGREGATE FUNCTIONS
15m
Video lesson
4. ORDER BY
2m
Video lesson
5. GROUP BY ORDER BY
11m
Interactive tutorial
6. QUIZ: GROUP BY and ORDER BY
15m
Assignment
7. CODING: GROUP BY ORDER BY
15m
Video lesson
8. HAVING CLAUSE AND WHERE
4m
Interactive tutorial
9. QUIZ: HAVING CLAUSE
15m
Assignment
10. CODING: HAVING CLAUSE AND WHERE
15m
Video lesson
11. LIMIT AND ALIASING
4m
Assignment
12. CODING: LIMIT and ALIASING
15m
Interactive tutorial
13. QUIZ: LIMIT and ALIASING
15m
Interactive tutorial
14. QUIZ: MODULE 3
20m
Assignment
15. CODING: MODULE 3 - 1
15m
Assignment
16. CODING: MODULE 3 - 2
15m
Assignment
17. CODING: MODULE 3 - 3
15m
4. JOINS, UNION, NULL HANDLING
Video lesson
1. JOINS - INNER, LEFT AND RIGHT
18m
Video lesson
2. JOINS - FULL, CROSS JOIN
10m
Interactive tutorial
3. QUIZ: JOINS
35m
Assignment
4. CODING: JOINS - 1
15m
Assignment
5. CODING: JOINS - 2
15m
Video lesson
6. UNION AND UNION ALL
8m
Interactive tutorial
7. QUIZ: UNION AND UNION ALL
15m
Assignment
8. CODING: UNION AND UNION ALL
15m
Video lesson
9. NULL VALUES
3m
Video lesson
10. NULL HANDLING
15m
Video lesson
11. CONVERTING DATA TYPES
2m
Interactive tutorial
12. QUIZ: NULL AND CONVERSIONS
15m
Interactive tutorial
13. QUIZ: MODULE 4
25m
Assignment
14. CODING: MODULE 4 - 1
15m
Assignment
15. CODING: MODULE 4 - 2
15m
Assignment
16. CODING: MODULE 4 - 3
15m
Assignment
17. CODING: MODULE 4 - 4
15m
Browse Topfolio
All courses
Practice
Projects
Career tracks
Home
/
Courses
/
SQL Basics
/
DATA RETRIEVAL & FILTERING
/
CODING: CASE WHEN
Back to DATA RETRIEVAL & FILTERING
CODING: CASE WHEN
10 minutes
Assignment
Loading lesson...
