100 SQL Queries – Beginner to Advanced | SQLite Practice Edition
Build practical database-querying skills with 100 SQL Queries – Beginner to Advanced: SQLite Practice Edition by CodeWithRishabh.
This 58-page digital ebook contains 100 exercises based on a small business dataset featuring customers, orders, products, employees and departments.
Each lesson presents a question, a working query, its output table and a short explanation. Selected examples also show a preview of the starting data to make the results easier to understand.
What you’ll explore:
- SELECT, filtering, sorting and pagination.
- Aggregates, GROUP BY and HAVING.
- Joins, subqueries, EXISTS and set operations.
- Creating tables and changing data.
- NULL handling, text functions and date calculations.
- Ordinary and recursive CTEs.
- Ranking, running totals and other window functions.
- Transactions, savepoints, views, indexes and constraints.
- Audit triggers and safe parameter binding.
The examples use SQLite. Core SQL concepts transfer to other databases, while some syntax requires adaptation.