Skip to content

Learn

All CoursesBrowse the full catalog of expert-led courses
WorkshopsDeep-dive workshops from industry experts

AI-Powered

Learning PathsNewA personal path to your goal, built by AI
AI AgentLearn with an AI agent on every lesson
MCP ServerBring Dometrain into your AI coding tools
Mock InterviewsNewPractice real interviews with an AI interviewer

Trending now

Dometrain ProAll courses. One subscription.Every course and workshop replay, plus the AI-powered tools.Explore Pro

Community

LeaderboardSee how you rank against fellow learners
ReviewsWhat developers say about our courses
Customer StoriesHow real teams level up with Dometrain
ChangelogSee what's new and improved at Dometrain

Content

BlogsArticles and deep dives from our authors
AuthorsMeet the engineers behind the courses

Partners

AffiliatesEarn by sharing Dometrain with your audience
Dometrain for BusinessTraining and team management for companies

SkillScoreNew Dometrain Pro

Shopping Basket

Your basket is empty

Business Portal

Learn SQLite

15h 35m

Hands-On

Progress0%

0 / 188 lessons15h 35m left

Introduction to SQLite(0/6)

Your First SELECT Selecting Specific Columns Column Aliases with AS Expressions in SELECT DISTINCT Values Chapter Capstone - First Queries

Filtering Data with WHERE(0/9)

Basic WHERE Clause AND and OR Operators NOT Operator BETWEEN Operator IN Operator LIKE Pattern Matching GLOB Pattern Matching IS NULL and IS NOT NULL Chapter Capstone - Data Detective

Sorting and Limiting Results(0/6)

ORDER BY Basics Sorting by Multiple Columns LIMIT and OFFSET NULLS FIRST and NULLS LAST ORDER BY with Expressions Chapter Capstone - Top Products Report

Aggregate Functions(0/6)

COUNT Function SUM and AVG Functions MIN, MAX, and total()COUNT DISTINCT Combining Multiple Aggregates Chapter Capstone - Sales Summary

GROUP BY and HAVING(0/6)

Basic GROUP BY GROUP BY with Multiple Columns HAVING Clause GROUP BY with Expressions group_concat Function Chapter Capstone - Department Report

Introduction to JOINs(0/6)

INNER JOIN Table Aliases in JOINs USING Clause Self JOINs Joining Multiple Tables Chapter Capstone - Order Details Report

Advanced JOINs(0/6)

LEFT JOIN RIGHT JOIN FULL OUTER JOIN CROSS JOIN Joining on Multiple Conditions Chapter Capstone - Complete Customer View

Set Operations(0/5)

UNION and UNION ALL INTERSECT EXCEPT Compound SELECT with ORDER BY Chapter Capstone - Multi-Source Report

INSERT Operations(0/8)

Basic INSERT INSERT Multiple Rows INSERT with SELECT INSERT with DEFAULT VALUES INSERT OR REPLACE (UPSERT)INSERT with ON CONFLICT INSERT with RETURNING Chapter Capstone - Data Import

UPDATE Operations(0/6)

Basic UPDATE UPDATE Multiple Columns UPDATE with Expressions UPDATE FROM (Multi-Table Update)UPDATE with RETURNING Chapter Capstone - Bulk Price Adjustment

DELETE Operations(0/5)

Basic DELETE DELETE with JOIN-style Filtering DELETE with RETURNING DELETE with ORDER BY and LIMIT Chapter Capstone - Data Cleanup

SQLite Type Affinity System(0/6)

Understanding Type Affinity Type Affinity Rules The typeof() Function CAST Expressions ROWID and INTEGER PRIMARY KEY Chapter Capstone - Type Inspector

Text Functions(0/8)

UPPER, LOWER, and LENGTH substr() Function TRIM, LTRIM, RTRIM replace() Function instr() Function String Concatenation with ||printf() Function Chapter Capstone - Data Formatter

Numeric and Math Functions(0/6)

round() Function abs() and sign()ceil(), floor(), and Truncation power(), sqrt(), and log()Integer Division and Modulo Chapter Capstone - Financial Calculator

Date and Time Functions(0/8)

date(), time(), and datetime()strftime() Function Date Arithmetic with Modifiers unixepoch() Function julianday() Function Date Comparisons and Filtering Grouping by Date Parts Chapter Capstone - Time Series Report

Conditional Functions(0/6)

CASE Expression IIF() Function COALESCE and IFNULL NULLIF Function CASE in Aggregations Chapter Capstone - Data Classifier

Subqueries(0/8)

Subquery in WHERE IN with Subquery EXISTS Operator NOT EXISTS Scalar Subquery in SELECT Subquery in FROM (Derived Tables)Correlated Subqueries Chapter Capstone - Employee Ranking

Common Table Expressions (CTEs)(0/6)

Basic CTE with WITH Multiple CTEs CTE Referencing CTE Recursive CTEs Recursive CTE for Generating Series Chapter Capstone - Hierarchical Report

CREATE TABLE and Constraints(0/8)

CREATE TABLE Basics PRIMARY KEY and AUTOINCREMENT NOT NULL and DEFAULT UNIQUE Constraint CHECK Constraint FOREIGN KEY Constraint WITHOUT ROWID Tables Chapter Capstone - E-Commerce Schema

Schema Management(0/6)

ALTER TABLE ADD COLUMN ALTER TABLE RENAME ALTER TABLE DROP COLUMN DROP TABLE Recreating Tables (Schema Migration)Chapter Capstone - Schema Evolution

STRICT Tables and Generated Columns(0/5)

STRICT Tables STRICT Table Type Enforcement Stored Generated Columns Virtual Generated Columns Chapter Capstone - Modern Table Design

Indexes(0/7)

Creating Indexes Unique Indexes Composite Indexes Partial Indexes Expression Indexes DROP INDEX Chapter Capstone - Index Strategy

EXPLAIN QUERY PLAN(0/4)

Basic EXPLAIN QUERY PLAN Identifying Full Table Scans Analyzing JOIN Plans Chapter Capstone - Query Optimization

Window Functions(0/9)

ROW_NUMBER RANK and DENSE_RANK PARTITION BY LAG and LEAD SUM, AVG, COUNT as Window Functions FIRST_VALUE and LAST_VALUE NTH_VALUE and NTILE Window Frame Clauses Chapter Capstone - Analytics Dashboard

Views and Triggers(0/7)

Creating Views Querying and Dropping Views CREATE TRIGGER Basics UPDATE and DELETE Triggers INSTEAD OF Triggers DROP TRIGGER Chapter Capstone - Audit System

JSON Functions(0/7)

Storing and Querying JSON The -> and ->> Operators json_each() and json_tree()json_object() and json_array()json_set(), json_insert(), json_replace()json_group_array() and json_group_object()Chapter Capstone - JSON API Response Builder

Transactions and Conflict Resolution(0/6)

BEGIN, COMMIT, ROLLBACK SAVEPOINT and RELEASE Conflict Resolution Clauses ON CONFLICT Clause on Constraints Transaction Best Practices Chapter Capstone - Safe Bulk Import

PRAGMAs and Database Configuration(0/5)

PRAGMA table_info and table_list PRAGMA foreign_keys PRAGMA journal_mode Database Maintenance PRAGMAs Chapter Capstone - Database Inspector

Advanced Techniques(0/6)

ATTACH DATABASE The FILTER Clause VALUES as a Table UPSERT with Excluded Table Recursive CTE for Graph Traversal Chapter Capstone - Advanced Analytics

New Chapter 30(0/1)

Rate this course

0 matches found

Loading transcript

No transcript available for this lesson.

Sign in to take notes

Timestamped notes are saved to your account and grouped by lesson here, so you can jump back to any moment of the course.

Get Your Certificate

Basic GROUP BY

GROUP BY and HAVING

Complete the exercise to earn XP

Sign in to watch this course

Already a Dometrain Member?

or

New to Dometrain?

Enroll to continue

This course is free. Enroll to unlock this lesson.

Enroll for free

Lesson Notes

Read this lesson

Loading content...

Unable to load content. Please try again.

Upgrade to Dometrain Pro

Get unlimited access to this video and all other courses on Dometrain with a Pro subscription.

Unlimited access to all courses
New courses added regularly
Certificates of completion

Get Dometrain Pro

Where today's experts teach tomorrow's

Learn

Courses Learning Paths Workshops

Community

Blog Authors Reviews Customer Stories Changelog

Business

Dometrain Pro Business Portal Affiliates

Support

Contact Terms of Use Privacy Policy

© 2026 Dometrain. All rights reserved.

What's New