High Performance SQLite

Name: High Performance SQLite
Price: 9 USD
Availability: InStock

15h 27m 55s

English

Paid

September 5, 2024

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