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:
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
Module 2
SQLite Internals
Module 3
Schema
Module 4
Optimizing SQLite
Module 5
Indexes
Video 33
Introduction to indexes
5:30
Video 34
B+ trees
4:58
Video 35
Primary, secondary, and clustered indexes
8:04
Video 36
Without rowid tables
1:53
Video 37
Benchmarking without rowid tables
7:01
Video 38
Imposter tables
3:20
Video 39
Primary key data types
3:59
Video 40
Where to add indexes
11:40
Video 41
Index selectivity
9:11
Video 42
Composite indexes
11:35
Video 43
Composite ordering
2:58
Video 44
Covering indexes
9:30
Video 45
Partial indexes
8:04
Video 46
Indexes on expressions
4:59
Video 47
Automatic indexes
4:20
Video 48
Duplicate indexes
6:14
Video 1
Indexing joins
8:29
Module 6
Advanced SQL
Video 49
Explain
6:11
Video 50
Index obfuscation
3:44
Video 51
Joins
8:58
Video 52
Subqueries
11:35
Video 53
Unions
6:34
Video 54
CTEs
3:45
Video 55
Recursive CTEs
9:23
Video 56
Window functions
Free
10:49
Video 57
Dealing with NULLs
3:33
Video 58
Row value syntax
10:09
Video 59
Indexed sorting
6:09
Video 60
Upserts
7:53
Video 61
Returning
3:31
Video 62
Aggregates
9:56
Video 63
Triggers
5:26
Module 7
Full Text Search
(Coming Soon)
Module 8
Advanced JSON
(Coming Soon)
Module 9
Operating SQLite
(Coming Soon)
Module 10
The Ecosystem
(Coming Soon)
Join 822 students
Here's what some of the students who have taken the course have to say:
I had given up on SQLite 5 years ago, because of some false myths across the internet. Thank you Aaron for bringing me back to this powerful database! Shipped almost two apps, love the simplicity and the high performance of SQLite! This course is best possible investment 🚀Iliyan Slavov
Whether you want to learn SQLite from scratch or just want to level up your game, High Performance SQLite is by far the best course out there. I've been using SQlite for over a decade now and still managed to learn a lot from this course. It's a fantastic investment and a no brainer.Kulshekhar Kabra
Aaron's course offered invaluable insights into using SQLite on the server side, boosting my confidence to implement it in our company's projects.Alexis Trechau
Thank you for the excellent High Performance SQLite course! It’s been incredibly useful in deepening my understanding of SQLite. The sections on SQLite internals, schema, and optimization techniques are particularly insightful and have significantly improved my ability to work with SQLite in production environments.Ali Kasmani
Aaron is an incredible! Every video is packed full of useful information explaining concisely, I learned so much from this course!Derek Dorr
Some people stray away from a course like this because they find it too niche, but really there are great takeaways that you can apply to other databases. There are sections that cover optimization like how to treat indexing and how to write better queries SQLite is also relatively smaller, so it makes it easier to digest and really understand the engine that drives your application layer. I think this course really hit the nail on all points and I highly recommend it to anyone even curious about databases in general. Also of course the Aaron Francis/Try Hard touch always makes it a great time and interactive.Dylan Hackworth
The production quality of this course is so good and Aaron‘s enthusiasm and energy is infectious. I’m excited to master this extremely useful and powerful database technology that I had once written off as a toy for small projects. Now I know where SQLite shines and how I can use it effectively.JD Lien
I highly recommend the HighPerformanceSQLite course! Aaron's design makes it easy to grasp the basics before diving into advanced performance topics. It's a fantastic learning experience that will definitely boost your SQLite skills for real-world applications.Antonio Pagano
High Performance SQLite is an excellent and immersive course, featuring real-time typed commands and valuable edge case explanations. I highly recommend it for enhancing your SQLite skills.Han-Hsun Liu
One of the best courses I've ever had! This is something that I wish I watched in my early engineering days. But it also brings a lot of interesting and useful knowledge even now when I'm a senior. Totally worth the money!Piotr Tobiasz
I highly recommend High-Performance SQLite to fellow engineers. My motivation for learning SQLite stemmed from my interest in local-first applications, and I needed to understand SQLite to effectively use it in the browser. This resource provided that knowledge in a clear and practical manner, making it a must-watch for modern developers.Yuya Fujimoto
Aaron is anything but boring, he makes learning engaging and has given me more than one trick up my sleeve. I have been working with relational databases both professionally and for all my side projects and I've learned things about databases I didn't even know existed. Any course this man produces is an instant auto-buy because he makes it easy to do. You can tell he's put his heart and soul into this course and it'll stick with me longer than the current season of 'The House of the Dragon.' Wow is there any topic this guy can't make fun!Alex Maven
It’s not just for SQLite, Aaron is a veritable fount of SQL knowledge. The tips and pointers given in this course will surely help you decide what to handle on the db vs the app side.Hans Verschooten
High Performance SQLite helped level up our local-first React Native apps, taking full advantage of the database features and squeezing out the best performance.Dwight Watson
Aaron and Steve are a killer combo for high quality courses like High Performance SQLite. The course shows at great detail the ins and outs of SQLite and how to scale it to compete with any other database. I love it!Nik Spyratos
High Performance SQLite is more than just an SQLite course, it is a general SQL masterclass. The course has unlocked new breakthroughs for query performance in my day-to-day, it's a great level-up!Eckhardt Dreyer
Aaron Francis has done it again with High Performance SQLite! You'll learn how to make SQLite fast and some important database fundamentals. There's a ton of lifetime value you won't want to miss out on!Austin Karren
This is by far the best course on SQLite out there, Aaron put a lot of effort into it to explain the ins and outs of this fantastic database. Highly recommend it!Alexandru Vladutu
High Performance SQLite has been the single best pragmatic guide for SQLite on the Internet. This course is a must have for all developers at any stage in their DB journey.Tony Mannino
Aaron is communicating so clearly that my 10 year old daughter understands what he is talking about. Production is at the highest level I have ever seen. I first watched his MySQL course and I can see the progress Steve and Aaron are making. HP SQLite course is a pure masterpiece.Ivan Bunčić
This course is great. Not only is it an insightful deep dive on performant SQLite, but it also helps one understand a lot about modern databases in general.Steven Fox
The course is very clear, accessible and ready for the beginner, advanced or the future sqlite user. Get ready for a serious mix of in depth technical knowledge and an approachable way of learning from an experienced teacher.Martijn De Boer
I went from near 0 to 100 in less than two weeks with this course. If you want to be a SQLite wizard, and just want to up-level your SQL skills in general, this is definitely the course for you.Anthony Bullard
Aaron has this fantastic way of breaking down complex topics to bits that are understandable. I finally understand how to tune my PRAGMA values instead of just copy/pasting from StackOverflow.Mathias Hansen
It's a really well-structured course that helped me understand the intricacies of SQLite through short and easy-to-grasp videos. The content is on point, non-opinionated, thoughtfully presented, and has good real-life applicability. Thanks to Aaron and the team!Viacheslav Azarov
Meet your instructor
My name is Aaron Francis.
I'm a software developer, database educator, and content creator. (More importantly though, I'm a dad to two (!) sets of twins!)
I created this course because I love databases and want more software developers to feel empowered to work with them.
If you want to get in touch you can always find me on Twitter or shoot us an email [email protected].
Start learning today
Learn how to make SQLite production ready from a developer's point-of-view.
Team Pricing
$
399
USD, one-time
We offer team discounts on the full course based on the number of team members you'd like to purchase for.
Need more seats? Email us.
Some people stray away from a course like this because they find it too niche, but really there are great takeaways that you can apply to other databases. There are sections that cover optimization like how to treat indexing and how to write better queries SQLite is also relatively smaller, so it makes it easier to digest and really understand the engine that drives your application layer. I think this course really hit the nail on all points and I highly recommend it to anyone even curious about databases in general. Also of course the Aaron Francis/Try Hard touch always makes it a great time and interactive.Dylan Hackworth
Frequently Asked Questions
I'm having issues with the course. Who can I contact?
Oh no! Send us an email at [email protected].
Is there a free trial available?
There are several free videos, but no free trial. If you aren’t fully satisfied with the course, just ask for your money back—no problem.
Is there a money back guarantee?
If, for any reason, you find yourself less than fully satisfied with the course, you may request a refund at any time.
Can I get an invoice?
Absolutely! After making a purchase we will automatically email you a receipt. If you need a more detailed invoice, just email us.
Do you offer discounts?
Sure, if you live in a country where the USD price is too high or if you are a student, don't hesitate to email us!