Small. Fast. Reliable.

Ready for production.

High Performance SQLite is a comprehensive video course by database educator @aarondfrancis . Learn everything you need to confidently use SQLite in production.

This course is sponsored by:
Turso

What to expect

This course is designed to take you from beginner to expert in SQLite. You'll learn how to use SQLite in production, how to optimize it, and how to use advanced features like full text search and JSON support.
Module 1
Introduction
Video 1
Introduction to this course
Video 2
Introduction to SQLite
Video 3
SQLite is safe
Video 4
It's just a file
Video 5
Running SQLite locally
Video 6
Good uses for SQLite
Video 7
SQLite's limitations
Video 8
The documentation
Module 2
SQLite Internals
Video 1
SQLite's structure
Video 2
SQLite's file format
Video 3
The ecosystem
Video 4
Configuring SQLite
Video 5
Dot commands
Video 6
Virtual tables
Module 3
Schema
Video 1
Flexible types
Video 2
Types
Video 3
Strict types
Video 4
Dates
Video 5
Floating point
Video 6
Primary keys
Video 7
Auto increment
Video 8
Generated columns
Module 4
Optimizing SQLite
Video 1
Locking
Video 2
The rollback journal
Video 3
WAL mode
Video 4
Changing Journal modes
Video 5
Vacuuming
Video 6
Optimize & Analyze
Video 7
Busy timeout
Video 8
Transactions
Video 9
Suggested pragmas
Video 10
Faster inserts
Module 5
Indexes
Video 1
Introduction to indexes
Video 2
B+ trees
Video 3
Primary, secondary, and rowid
Video 4
Without rowid
Video 5
Imposter tables
Video 6
Primary key data types
Video 7
Where to add indexes
Video 8
Index selectivity
Video 9
Composite indexes
Video 10
Covering indexes
Video 11
Partial indexes
Video 12
Indexes on expressions
Video 13
Indexing JSON columns
Video 14
Automatic indexes
Video 15
Duplicate indexes
Video 16
Foreign keys
Module 6
Advanced SQL
Video 1
Explain
Video 2
Profiling
Video 3
Index obfuscation
Video 4
Joins
Video 5
Subqueries
Video 6
Unions
Video 7
CTEs
Video 8
Window functions
Video 9
Dealing with NULLs
Video 10
Row value syntax
Video 11
Indexed sorting
Video 12
Upserts
Video 13
On conflict
Video 14
Aggregates
Video 15
Triggers
Module 7
Full Text Search
Video 1
Creating a FTS table
Video 2
Performing full text searches
Video 3
Highlighting matches
Video 4
Modifying FTS tables
Module 8
Advanced JSON
Video 1
Storing JSON
Video 2
Scalar JSON functions
Video 3
JSON table functions
Video 4
Creating JSON
Video 5
Reading JSON from a file
Module 9
Operating SQLite
Video 1
Altering schema
Video 2
Multiple databases
Video 3
Multi tenancy
Video 4
Backups
Video 5
Exporting
Video 6
How to corrupt SQLite
Module 10
Ecosystem
Video 1
Extensions
Video 2
Libraries

Learn everything you need to know about SQLite.

© 2024 Try Hard Studios, LLC