High Performance SQLite
15h 27m 55s
English
Paid
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 High Performance SQLite
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 to High Performance SQLite

Scaling Web App Configuration with Environment Variables fullstack.io
Category: Other (Backend), Other (Frontend)
Duration 1 hour 53 minutes 25 seconds
Course

Streaming Databasesoreillymedia
Category: Other (Backend)
Duration
Book

Apache Kafka Series - Learn Apache Kafka for Beginners v3udemy
Category: Other (Backend)
Duration 8 hours 20 minutes 45 seconds
Course

Fundamentals of Database Engineeringudemy
Category: Other (Backend)
Duration 26 hours 2 minutes 59 seconds
Course

The Complete 2023 Web Development Bootcampudemy
Category: MongoDB, Other (Backend), Other (Frontend)
Duration 62 hours 32 minutes 23 seconds
Course

DuckDB - The Ultimate Guideudemy
Category: Other (Backend)
Duration 5 hours 56 minutes 13 seconds
Course

Mastering Postgres | The most comprehensive course on PostgreSQLAaron Francis
Category: Other (Backend)
Duration 16 hours 13 minutes 30 seconds
Course

Web API From Start to Finishiamtimcorey.com (Tim Corey)
Category: Other (Backend)
Duration 17 hours 59 minutes 54 seconds
Course

Getting Started With ClickHouse (2023 Edition)udemy
Category: Other (Backend)
Duration 4 hours 38 minutes 56 seconds
Course

Effective Database DesignBen Brumm
Category: Sql, Other (Backend)
Duration 1 hour 3 minutes 56 seconds
Course