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
Join premium to watch
Go to premium
| # | Title | Duration |
|---|---|---|
| 1 | 01. Introduction to this course | 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 |
Similar courses
Database Design Book
Sources: Alexey Makhotkin
The goal of this book is to help you progress from a vague idea of a task (for example: "I need to create a website for managing schedules and records...
Database Mastery: SQL to Prisma
Sources: jsmastery.pro, Adrian Hajdin
Master key technologies with a practical approach! You will gain applied knowledge, clear explanations, and all the necessary tools to confidently master...
16 minutes 3 seconds
Streaming Databases
Sources: oreillymedia
Real-time applications are becoming the norm. However, for the model to function properly, it is necessary to obtain data in real time...
DBMS
Sources: takeUforward
This course is dedicated to the study of Database Management Systems (DBMS) - technologies that allow for efficient storage, processing, and protection of data.
21 hours 30 minutes 50 seconds