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
DuckDB - The Ultimate Guide
Sources: udemy
Why should you study DuckDB? DuckDB is one of the fastest-growing technologies, with the number of search queries increasing by 1200% over the past two years!
5 hours 56 minutes 13 seconds
Building Full-Stack Apps with AI
Sources: Mckay Wrigley (takeoff)
The course "Building Full-Stack Apps with AI" teaches how to create comprehensive applications using artificial intelligence, suitable for both beginners and...
8 hours 3 minutes 16 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
Getting Started With ClickHouse (2023 Edition)
Sources: udemy
Learn ClickHouse, the fastest and the most powerful database that can handle Petabytes of data with ease! ClickHouse is an Open-Source columnar data store devel
4 hours 38 minutes 56 seconds
Effective Database Design
Sources: Ben Brumm
The course "Effective Database Design" will provide you with an action plan, examples, and instructions for creating a well-designed database.
1 hour 3 minutes 56 seconds