High Performance SQLite
15h 27m 55s
English
Paid
Course description
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.
Watch Online
0:00
/ #1: 01. Introduction to this course
All Course Lessons (93)
| # | Lesson Title | Duration | Access |
|---|---|---|---|
| 1 | 01. Introduction to this course Demo | 04:33 | |
| 2 | 02. Introduction to SQLite | 05:12 | |
| 3 | 03. SQLite is safe | 03:04 | |
| 4 | 04. It's just a file | 03:17 | |
| 5 | 05. Running SQLite locally | 02:56 | |
| 6 | 06. Good uses for SQLite | 06:23 | |
| 7 | 07. SQLite's limitations | 03:52 | |
| 8 | 08. The documentation | 02:28 | |
| 9 | 09. SQLite's structure | 04:39 | |
| 10 | 10. SQLite's file format | 03:52 | |
| 11 | 11. Dot commands | 09:22 | |
| 12 | 12. Pragmas | 06:10 | |
| 13 | 13. Virtual tables | 03:48 | |
| 14 | 14. Flexible types | 05:43 | |
| 15 | 15. Types | 10:26 | |
| 16 | 16. Strict types | 05:41 | |
| 17 | 17. Dates | 07:59 | |
| 18 | 18. Booleans | 01:02 | |
| 19 | 19. Floating point | 07:27 | |
| 20 | 20. Rowid tables | 11:02 | |
| 21 | 21. Auto increme | 06:47 | |
| 22 | 22. Without rowid | 03:26 | |
| 23 | 23. Generated columns | 06:49 | |
| 24 | 24. Locking | 04:30 | |
| 25 | 25. Rollback mode | 04:16 | |
| 26 | 26. WAL mode | 04:13 | |
| 27 | 27. WAL vs Journal benchmarks | 05:37 | |
| 28 | 28. Busy timeout | 04:29 | |
| 29 | 29. Transaction modes | 04:21 | |
| 30 | 30. Vacuum | 06:48 | |
| 31 | 31. Analyze & Optimize | 05:16 | |
| 32 | 32. Suggested pragmas | 05:23 | |
| 33 | 33. Faster inse | 01:32 | |
| 34 | 34. Introduction to indexes | 05:33 | |
| 35 | 35. B+ trees | 05:01 | |
| 36 | 36. Primary, secondary, and clustered indexes | 08:07 | |
| 37 | 37. Without rowid tables | 01:56 | |
| 38 | 38. Benchmarking without rowid tables | 07:04 | |
| 39 | 39. Imposter tables | 03:24 | |
| 40 | 40. Primary key data types | 04:02 | |
| 41 | 41. Where to add indexes | 11:43 | |
| 42 | 42. Index selectivity | 09:14 | |
| 43 | 43. Composite indexes | 11:38 | |
| 44 | 44. Composite ordering | 03:01 | |
| 45 | 45. Covering indexes | 09:33 | |
| 46 | 46. Partial indexes | 08:07 | |
| 47 | 47. Indexes on expressions | 05:02 | |
| 48 | 48. Automatic indexes | 04:23 | |
| 49 | 49. Duplicate indexes | 06:17 | |
| 50 | 50. Indexing joins | 08:32 | |
| 51 | 51. Explain | 06:14 | |
| 52 | 52. Index obfuscation | 03:47 | |
| 53 | 53. Joins | 09:01 | |
| 54 | 54. Subqueries | 11:38 | |
| 55 | 55. Unions | 06:37 | |
| 56 | 56. CTEs | 03:48 | |
| 57 | 57. Recursive CTEs | 09:26 | |
| 58 | 58. Window functions | 10:53 | |
| 59 | 59. Dealing with NULLs | 03:36 | |
| 60 | 60. Row value syntax | 10:12 | |
| 61 | 61. Indexed sorting | 06:12 | |
| 62 | 62. Upse | 07:56 | |
| 63 | 63. Returning | 03:34 | |
| 64 | 64. Aggregates | 09:59 | |
| 65 | 65. Triggers | 05:29 | |
| 66 | 66. Altering schema | 10:57 | |
| 67 | 67. Altering schema with tools | 04:24 | |
| 68 | 68. Multi-database | 02:20 | |
| 69 | 69. Multi-tenancy | 11:34 | |
| 70 | 70. Backups | 04:26 | |
| 71 | 71. Expo | 05:37 | |
| 72 | 72. How to corrupt SQLite | 03:04 | |
| 73 | 73. Intro to JSON | 03:40 | |
| 74 | 74. JSON vs. JSONB | 05:07 | |
| 75 | 75. Argument types- path, value, JSON | 09:19 | |
| 76 | 76. JSON5 | 03:20 | |
| 77 | 77. Valid JSON | 07:13 | |
| 78 | 78. Creating JSON obje + arrays | 02:43 | |
| 79 | 79. JSON Extraction | 06:47 | |
| 80 | 80. Updating JSON | 07:11 | |
| 81 | 81. JSON aggregates | 05:14 | |
| 82 | 82. JSON table functions | 07:43 | |
| 83 | 83. Indexing JSON | 07:49 | |
| 84 | 84. Creating tables | 13:56 | |
| 85 | 85. Performing searches | 10:45 | |
| 86 | 86. Ranking resu | 05:58 | |
| 87 | 87. Highlighting matches | 05:52 | |
| 88 | 88. DHH discusses SQLite in Ruby on Rails | 54:00 | |
| 89 | 89. Distributed SQLite with Litestream and LiteFS | 54:37 | |
| 90 | 90. Offline-first, multiplayer SQLite | 01:21:25 | |
| 91 | 91. Production SQLite with Turso and libSQL | 01:02:53 | |
| 92 | 92. DHH discusses SQLite in Ruby on Rails | 54:00 | |
| 93 | 93. Ruby on Rails with SQLite | 01:22:39 |
Unlock unlimited learning
Get instant access to all 92 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.
Learn more about subscriptionComments
0 commentsWant to join the conversation?
Sign in to commentSimilar courses
Just Use Postgres!
Sources: Denis Magda
Find out how Postgres handles generative AI tasks, geospatial data, and many more. Get the most out of one of the most popular DBMS.
Database Design & Implementation
Sources: Amigoscode (Nelson Djalo)
Backend starts from Your Database. When you have a solid database design coding is easy. In this course you will learn how to design databases for your backend applications. You...
2 hours 7 minutes 49 seconds
Apache Kafka Series - Kafka Streams for Data Processing
Sources: udemy
Learn the Kafka Streams API with Hands-On Examples, Learn Exactly Once, Build and Deploy Apps with Java 8. Learn the Kafka Streams data processing library, for
4 hours 50 minutes 7 seconds
Complete ASP.NET MVC 5
Sources: udemy
With over 40,000 happy students and 12,000+ positive reviews, this course is Udemy's most popular course for learning ASP.NET MVC! ASP.NET MVC is a server-side
7 hours 33 minutes 52 seconds
Apache Kafka Series - Learn Apache Kafka for Beginners v3
Sources: udemy
Welcome to the Apache Kafka Series! Join a community of 20,000+ students learning Kafka. Apache Kafka has become the leading distributed data streaming enterprise big data techn...
8 hours 20 minutes 45 seconds