Free SQL Course for Beginners (SQLite) — Analyst Path

By Ravindra Bagale · Last updated: 31 October 2026

Learn analyst SQL with SQLite and free DB Browser for SQLite. Very easy English, Why → What → How, practice datasets, quizzes and cards.

मराठी SQL कोर्स

Practice datasets · Ravi Sir's Cards

Paths

• Excel users — term map
• Power BI users — connect databases
• Python users — SQL into pandas
• Data engineering — joins & windows lite

Chapters published so far

The course now has 16 published chapters (listed below). More chapters from the full course plan will be added later.

• Chapter 1. What Is SQL and Why Analysts Need It (6 lessons)
• Chapter 2. Install SQLite and DB Browser (Windows and Mac) (6 lessons)
• Chapter 3. SELECT Basics: Read Rows Without Changing Data (6 lessons)
• Chapter 4. WHERE: Keep Only the Rows You Need (6 lessons)
• Chapter 5. ORDER BY, DISTINCT and Top-N Results (6 lessons)
• Chapter 6. SQL Data Types Analysts Actually Meet (5 lessons)
• Chapter 7. NULL Values: Missing Data Done Right (6 lessons)
• Chapter 8. CASE WHEN: If-Then Logic in SQL (5 lessons)
• Chapter 9. Date and Time Queries for Analysts (5 lessons)
• Chapter 10. Text Functions Analysts Use Daily (5 lessons)
• Chapter 11. Aggregate Functions: SUM COUNT AVG MIN MAX (5 lessons)
• Chapter 12. GROUP BY: One Row Per Group (6 lessons)
• Chapter 13. HAVING: Filter Groups After Aggregates (4 lessons)
• Chapter 14. Why Tables Join: Keys and Relationships (4 lessons)
• Chapter 15. INNER JOIN and LEFT JOIN (The Two You Need First) (5 lessons)
• Chapter 29. SQL for Excel Users (Term Map + Side-by-Side) (6 lessons)