Topfolio
Back to Micro Free Courses

SQL Basics

Beginner

Learn SQL from scratch: querying, filtering, grouping, and joining data for analytics use cases.

SQL Basics
Duration

3 weeks

Content

4 modules, 57 lessons

Students

118

Total Time

~4 hours

100% Free Structured Micro Course

All video lessons, coding exercises, and quizzes are completely free with zero gatekeeping. Start learning right away!

Micro Free Course• 100% Free Learning & Quizzes

Start Learning Immediately

Every video, lesson, and practice quiz is completely free. Upgrade to an Official Verified Certificate & AI Review anytime for just ₹99.

Course Curriculum

1

INTRODUCTION TO SQL & DATABASESFREE PREVIEW

What is SQL, relational concepts, and your first SELECT query.

45 min4 lessons
Video lessonSQL OVERVIEW & FIRST QUERY
4 min
Video lessonBASIC SELECT
2 min
Interactive tutorialQUIZ: RDBMS, SQL Overview
5 min
AssignmentHands-on: Your First SELECT
10 min
Start Module
2

DATA RETRIEVAL & FILTERINGFREE PREVIEW

SELECT in detail, WHERE with AND/OR/IN/BETWEEN/LIKE, DATE and STRING functions

60 min19 lessons
Video lessonWHERE CLAUSE
13 min
ReadingTHE IN OPERATOR
5 min
Interactive tutorialQUIZ: WHERE CLAUSE
15 min
AssignmentCODING: WHERE CLAUSE - 1
10 min
AssignmentCODING: WHERE CLAUSE - 2
10 min
AssignmentCODING: WHERE CLAUSE - 3
10 min
Video lessonCASE WHEN
9 min
Interactive tutorialQUIZ: CASE WHEN
15 min
AssignmentCODING: CASE WHEN
10 min
Video lessonSTRING FUNCTIONS
12 min
Interactive tutorialQUIZ: STRING FUNCTIONS
15 min
AssignmentCODING: STRING FUNCTIONS
10 min
Video lessonDATE FUNCTIONS
5 min
Interactive tutorialQUIZ: DATE FUNCTIONS
15 min
AssignmentCODING: DATE FUNCTIONS
15 min
Video lessonSELECT DISTINCT
2 min
Interactive tutorialQUIZ: MODULE 2
20 min
AssignmentCODING: MODULE 2 - 1
15 min
AssignmentCODING: MODULE 2 - 2
15 min
Start Module
3

AGGREGATIONS & GROUP BY, ORDER BYFREE PREVIEW

Aggregate functions, ORDER BY, GROUP BY, HAVING, LIMIT and Aliasing

55 min17 lessons
Video lessonAGGREGATE FUNCTIONS
12 min
Interactive tutorialQUIZ: AGGREGATE FUNCTIONS
15 min
AssignmentCODING: AGGREGATE FUNCTIONS
15 min
Video lessonORDER BY
2 min
Video lessonGROUP BY ORDER BY
11 min
Interactive tutorialQUIZ: GROUP BY and ORDER BY
15 min
AssignmentCODING: GROUP BY ORDER BY
15 min
Video lessonHAVING CLAUSE AND WHERE
4 min
Interactive tutorialQUIZ: HAVING CLAUSE
15 min
AssignmentCODING: HAVING CLAUSE AND WHERE
15 min
Video lessonLIMIT AND ALIASING
4 min
AssignmentCODING: LIMIT and ALIASING
15 min
Interactive tutorialQUIZ: LIMIT and ALIASING
15 min
Interactive tutorialQUIZ: MODULE 3
20 min
AssignmentCODING: MODULE 3 - 1
15 min
AssignmentCODING: MODULE 3 - 2
15 min
AssignmentCODING: MODULE 3 - 3
15 min
Start Module
4

JOINS, UNION, NULL HANDLINGFREE PREVIEW

INNER JOIN, LEFT/RIGHT JOIN, FULL JOIN, UNION, UNION ALL, NULL handling, Data Type Conversions

75 min17 lessons
Video lessonJOINS - INNER, LEFT AND RIGHT
18 min
Video lessonJOINS - FULL, CROSS JOIN
10 min
Interactive tutorialQUIZ: JOINS
35 min
AssignmentCODING: JOINS - 1
15 min
AssignmentCODING: JOINS - 2
15 min
Video lessonUNION AND UNION ALL
8 min
Interactive tutorialQUIZ: UNION AND UNION ALL
15 min
AssignmentCODING: UNION AND UNION ALL
15 min
Video lessonNULL VALUES
3 min
Video lessonNULL HANDLING
15 min
Video lessonCONVERTING DATA TYPES
2 min
Interactive tutorialQUIZ: NULL AND CONVERSIONS
15 min
Interactive tutorialQUIZ: MODULE 4
25 min
AssignmentCODING: MODULE 4 - 1
15 min
AssignmentCODING: MODULE 4 - 2
15 min
AssignmentCODING: MODULE 4 - 3
15 min
AssignmentCODING: MODULE 4 - 4
15 min
Start Module
Micro Free Course

Ready to Master SQL Basics?

All videos, lessons, and practice exercises are 100% free with zero gatekeeping. Start learning immediately, or enroll with the ₹99 Verified Certificate Pass.

Reviews & Ratings

No reviews yet

Sign in to leave a review.