30% OFF - Use code HANDSON30 for 30% off any course or Dometrain Pro! Browse courses →
  • Courses
  • Learning Paths
  • Blogs
  • Authors
  • Leaderboard
  • Dometrain Pro

  • Shopping Basket

    Your basket is empty

  • Business Portal

    • Hands-On: Learn SQLite

    Learn SQLite through hands-on coding exercises. Practice what you learn with interactive exercises.

    About This Course

    SQLite is one of the most widely deployed database engines in the world, embedded in virtually every smartphone, web browser, and countless applications. It is free, open source, and incredibly lightweight — requiring zero configuration and no separate server process. Its simplicity and reliability make it the primary choice for mobile apps, desktop software, IoT devices, and prototyping. This practical lab course will teach you SQLite from scratch, all the way to some of its more advanced features, by having you complete exercises on our SQLite web editor with explanations and AI-assisted learning.

    Course Curriculum

    15h 35m 29 sections
    Your First SELECT
    05:00
    Selecting Specific Columns
    05:00
    Column Aliases with AS
    05:00
    Expressions in SELECT
    05:00
    DISTINCT Values
    05:00
    Chapter Capstone - First Queries
    05:00
    Basic WHERE Clause
    05:00
    AND and OR Operators
    05:00
    NOT Operator
    05:00
    BETWEEN Operator
    05:00
    IN Operator
    05:00
    LIKE Pattern Matching
    05:00
    GLOB Pattern Matching
    05:00
    IS NULL and IS NOT NULL
    05:00
    Chapter Capstone - Data Detective
    05:00
    ORDER BY Basics
    05:00
    Sorting by Multiple Columns
    05:00
    LIMIT and OFFSET
    05:00
    NULLS FIRST and NULLS LAST
    05:00
    ORDER BY with Expressions
    05:00
    Chapter Capstone - Top Products Report
    05:00
    COUNT Function
    05:00
    SUM and AVG Functions
    05:00
    MIN, MAX, and total()
    05:00
    COUNT DISTINCT
    05:00
    Combining Multiple Aggregates
    05:00
    Chapter Capstone - Sales Summary
    05:00
    Basic GROUP BY
    05:00
    GROUP BY with Multiple Columns
    05:00
    HAVING Clause
    05:00
    GROUP BY with Expressions
    05:00
    group_concat Function
    05:00
    Chapter Capstone - Department Report
    05:00
    INNER JOIN
    05:00
    Table Aliases in JOINs
    05:00
    USING Clause
    05:00
    Self JOINs
    05:00
    Joining Multiple Tables
    05:00
    Chapter Capstone - Order Details Report
    05:00
    LEFT JOIN
    05:00
    RIGHT JOIN
    05:00
    FULL OUTER JOIN
    05:00
    CROSS JOIN
    05:00
    Joining on Multiple Conditions
    05:00
    Chapter Capstone - Complete Customer View
    05:00
    UNION and UNION ALL
    05:00
    INTERSECT
    05:00
    EXCEPT
    05:00
    Compound SELECT with ORDER BY
    05:00
    Chapter Capstone - Multi-Source Report
    05:00
    Basic INSERT
    05:00
    INSERT Multiple Rows
    05:00
    INSERT with SELECT
    05:00
    INSERT with DEFAULT VALUES
    05:00
    INSERT OR REPLACE (UPSERT)
    05:00
    INSERT with ON CONFLICT
    05:00
    INSERT with RETURNING
    05:00
    Chapter Capstone - Data Import
    05:00
    Basic UPDATE
    05:00
    UPDATE Multiple Columns
    05:00
    UPDATE with Expressions
    05:00
    UPDATE FROM (Multi-Table Update)
    05:00
    UPDATE with RETURNING
    05:00
    Chapter Capstone - Bulk Price Adjustment
    05:00
    Basic DELETE
    05:00
    DELETE with JOIN-style Filtering
    05:00
    DELETE with RETURNING
    05:00
    DELETE with ORDER BY and LIMIT
    05:00
    Chapter Capstone - Data Cleanup
    05:00
    Understanding Type Affinity
    05:00
    Type Affinity Rules
    05:00
    The typeof() Function
    05:00
    CAST Expressions
    05:00
    ROWID and INTEGER PRIMARY KEY
    05:00
    Chapter Capstone - Type Inspector
    05:00
    UPPER, LOWER, and LENGTH
    05:00
    substr() Function
    05:00
    TRIM, LTRIM, RTRIM
    05:00
    replace() Function
    05:00
    instr() Function
    05:00
    String Concatenation with ||
    05:00
    printf() Function
    05:00
    Chapter Capstone - Data Formatter
    05:00
    round() Function
    05:00
    abs() and sign()
    05:00
    ceil(), floor(), and Truncation
    05:00
    power(), sqrt(), and log()
    05:00
    Integer Division and Modulo
    05:00
    Chapter Capstone - Financial Calculator
    05:00
    date(), time(), and datetime()
    05:00
    strftime() Function
    05:00
    Date Arithmetic with Modifiers
    05:00
    unixepoch() Function
    05:00
    julianday() Function
    05:00
    Date Comparisons and Filtering
    05:00
    Grouping by Date Parts
    05:00
    Chapter Capstone - Time Series Report
    05:00
    CASE Expression
    05:00
    IIF() Function
    05:00
    COALESCE and IFNULL
    05:00
    NULLIF Function
    05:00
    CASE in Aggregations
    05:00
    Chapter Capstone - Data Classifier
    05:00
    Subquery in WHERE
    05:00
    IN with Subquery
    05:00
    EXISTS Operator
    05:00
    NOT EXISTS
    05:00
    Scalar Subquery in SELECT
    05:00
    Subquery in FROM (Derived Tables)
    05:00
    Correlated Subqueries
    05:00
    Chapter Capstone - Employee Ranking
    05:00
    Basic CTE with WITH
    05:00
    Multiple CTEs
    05:00
    CTE Referencing CTE
    05:00
    Recursive CTEs
    05:00
    Recursive CTE for Generating Series
    05:00
    Chapter Capstone - Hierarchical Report
    05:00
    CREATE TABLE Basics
    05:00
    PRIMARY KEY and AUTOINCREMENT
    05:00
    NOT NULL and DEFAULT
    05:00
    UNIQUE Constraint
    05:00
    CHECK Constraint
    05:00
    FOREIGN KEY Constraint
    05:00
    WITHOUT ROWID Tables
    05:00
    Chapter Capstone - E-Commerce Schema
    05:00
    ALTER TABLE ADD COLUMN
    05:00
    ALTER TABLE RENAME
    05:00
    ALTER TABLE DROP COLUMN
    05:00
    DROP TABLE
    05:00
    Recreating Tables (Schema Migration)
    05:00
    Chapter Capstone - Schema Evolution
    05:00
    STRICT Tables
    05:00
    STRICT Table Type Enforcement
    05:00
    Stored Generated Columns
    05:00
    Virtual Generated Columns
    05:00
    Chapter Capstone - Modern Table Design
    05:00
    Creating Indexes
    05:00
    Unique Indexes
    05:00
    Composite Indexes
    05:00
    Partial Indexes
    05:00
    Expression Indexes
    05:00
    DROP INDEX
    05:00
    Chapter Capstone - Index Strategy
    05:00
    Basic EXPLAIN QUERY PLAN
    05:00
    Identifying Full Table Scans
    05:00
    Analyzing JOIN Plans
    05:00
    Chapter Capstone - Query Optimization
    05:00
    ROW_NUMBER
    05:00
    RANK and DENSE_RANK
    05:00
    PARTITION BY
    05:00
    LAG and LEAD
    05:00
    SUM, AVG, COUNT as Window Functions
    05:00
    FIRST_VALUE and LAST_VALUE
    05:00
    NTH_VALUE and NTILE
    05:00
    Window Frame Clauses
    05:00
    Chapter Capstone - Analytics Dashboard
    05:00
    Creating Views
    05:00
    Querying and Dropping Views
    05:00
    CREATE TRIGGER Basics
    05:00
    UPDATE and DELETE Triggers
    05:00
    INSTEAD OF Triggers
    05:00
    DROP TRIGGER
    05:00
    Chapter Capstone - Audit System
    05:00
    Storing and Querying JSON
    05:00
    The -> and ->> Operators
    05:00
    json_each() and json_tree()
    05:00
    json_object() and json_array()
    05:00
    json_set(), json_insert(), json_replace()
    05:00
    json_group_array() and json_group_object()
    05:00
    Chapter Capstone - JSON API Response Builder
    05:00
    BEGIN, COMMIT, ROLLBACK
    05:00
    SAVEPOINT and RELEASE
    05:00
    Conflict Resolution Clauses
    05:00
    ON CONFLICT Clause on Constraints
    05:00
    Transaction Best Practices
    05:00
    Chapter Capstone - Safe Bulk Import
    05:00
    PRAGMA table_info and table_list
    05:00
    PRAGMA foreign_keys
    05:00
    PRAGMA journal_mode
    05:00
    Database Maintenance PRAGMAs
    05:00
    Chapter Capstone - Database Inspector
    05:00
    ATTACH DATABASE
    05:00
    The FILTER Clause
    05:00
    VALUES as a Table
    05:00
    UPSERT with Excluded Table
    05:00
    Recursive CTE for Graph Traversal
    05:00
    Chapter Capstone - Advanced Analytics
    05:00

    Course Details

    Level Hands-On
    Duration 15h 35m
    FREE

    Free Lifetime Access

    Get permanent access to this course for free.

    By enrolling, you agree to receive marketing emails from Dometrain. You can unsubscribe at any time.

    Meet Your Instructor

    Nick Chapsas

    Nick Chapsas

    Nick Chapsas is a .NET & C# content creator, educator and a Microsoft MVP for Developer Technologies with years of experience in Software Engineering and Engineering Management.

    He has worked for some of the biggest companies in the world, building systems that served millions of users and tens of thousands of requests per second.

    Nick creates free content on YouTube and is the host of the Keep Coding Podcast.

    View all courses by Nick Chapsas

    What's New

    Getting Started: Model Context Protocol (MCP)
    course

    Getting Started: Model Context Protocol (MCP)

    Learn how to get started with the Model Context Protocol (MCP) and integrate it into your applications.

    Learn more about Getting Started: Model Context Protocol (MCP)
    Hands-On: Learn TypeScript
    course

    Hands-On: Learn TypeScript

    Learn TypeScript through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.

    Learn more about Hands-On: Learn TypeScript
    Hands-On: Learn JavaScript
    course

    Hands-On: Learn JavaScript

    Learn JavaScript through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.

    Learn more about Hands-On: Learn JavaScript
    Hands-On: Data Structures & Algorithms in C#
    course

    Hands-On: Data Structures & Algorithms in C#

    Master data structures and algorithms through hands-on coding exercises in C#. Free to enroll for 7 days!

    Learn more about Hands-On: Data Structures & Algorithms in C#
    Blogsmith.ai
    feature

    Blogsmith.ai

    Turn your videos into blogs and newsletters with AI. Check out our new product at blogsmith.ai.

    Learn more about Blogsmith.ai
    Leaderboard
    feature

    Leaderboard

    See how you stack up against other learners. Track your progress, climb the ranks, and compete with the Dometrain community.

    Learn more about Leaderboard
    Hands-On: Learn PostgreSQL
    course

    Hands-On: Learn PostgreSQL

    Learn PostgreSQL through hands-on coding exercises. Practice what you learn with interactive challenges designed for every level.

    Learn more about Hands-On: Learn PostgreSQL
    Free Hands-On: C# for Beginners
    course

    Free Hands-On: C# for Beginners

    Learn C# through hands-on coding exercises. Practice what you learn with interactive challenges designed for everyone, from beginners to experts.

    Learn more about Free Hands-On: C# for Beginners
    Getting Started: AI for .NET Developers
    course

    Getting Started: AI for .NET Developers

    Get started with integrating AI into your .NET applications effectively using the latest LLM best practices.

    Learn more about Getting Started: AI for .NET Developers
    Getting Started: Building .NET Applications on AWS
    course

    Getting Started: Building .NET Applications on AWS

    Learn how to build and deploy .NET applications on AWS using CDK, Lambda, DynamoDB, S3, and more.

    Learn more about Getting Started: Building .NET Applications on AWS
    What's new in C# 14
    blog

    What's new in C# 14

    This guide covers every new C# 14 feature, explains its benefits, and provides practical code examples to help you navigate how you can use them.

    Learn more about What's new in C# 14
    Let's Build It: AI Chatbot with RAG in .NET Using Your Data
    course

    Let's Build It: AI Chatbot with RAG in .NET Using Your Data

    Build a Retrieval-Augmented Generation (RAG) chatbot that can answer questions using your data.

    Learn more about Let's Build It: AI Chatbot with RAG in .NET Using Your Data
    From Zero to Hero: SignalR in .NET
    course

    From Zero to Hero: SignalR in .NET

    Enable enterprise-grade real-time communication for your web apps with SignalR.

    Learn more about From Zero to Hero: SignalR in .NET
    Deep Dive: Solution Architecture
    course

    Deep Dive: Solution Architecture

    Master solution architecture and turn business needs into scalable, maintainable systems.

    Learn more about Deep Dive: Solution Architecture
    Migrating: ASP.NET Web APIs to ASP.NET Core
    course

    Migrating: ASP.NET Web APIs to ASP.NET Core

    A step-by-step process to migrate ASP.NET Web APIs from .NET Framework to ASP.NET Core.

    Learn more about Migrating: ASP.NET Web APIs to ASP.NET Core
    Getting Started: Caching in .NET
    course

    Getting Started: Caching in .NET

    Let's make the hardest thing in programming easy for .NET software engineers.

    Learn more about Getting Started: Caching in .NET
    From Zero to Hero: Testing with xUnit in C#
    course

    From Zero to Hero: Testing with xUnit in C#

    Learn how to test any codebase in .NET with the latest version of xUnit, the industry-standard testing library.

    Learn more about From Zero to Hero: Testing with xUnit in C#
    Create a ChatGPT Console AI Chatbot in C#
    blog

    Create a ChatGPT Console AI Chatbot in C#

    This walkthrough is your hands-on entry point to create a basic C# console application that talks to ChatGPT using the OpenAI API.

    Learn more about Create a ChatGPT Console AI Chatbot in C#