High Performance SQLite
Focused View
6:32:17
0 View
01. Introduction to this course.mp4
04:32
02. Introduction to SQLite.mp4
05:11
03. SQLite is safe.mp4
03:03
04. Its just a file.mp4
03:16
05. Running SQLite locally.mp4
02:55
06. Good uses for SQLite.mp4
06:22
07. SQLites limitations.mp4
03:51
08. The documentation.mp4
02:27
09. SQLites structure.mp4
04:38
10. SQLites file format.mp4
03:51
11. Dot commands.mp4
09:21
12. Pragmas.mp4
06:09
13. Virtual tables.mp4
03:47
14. Flexible types.mp4
05:42
15. Types.mp4
10:25
16. Strict types.mp4
05:40
17. Dates.mp4
07:58
18. Booleans.mp4
01:01
19. Floating point.mp4
07:26
20. Rowid tables.mp4
11:01
21. Auto increments.mp4
06:46
22. Without rowid.mp4
03:25
23. Generated columns.mp4
06:48
24. Locking.mp4
04:29
25. Rollback mode.mp4
04:15
26. WAL mode.mp4
04:12
27. WAL vs Journal benchmarks.mp4
05:36
28. Busy timeout.mp4
04:28
29. Transaction modes.mp4
04:20
30. Vacuum.mp4
06:47
31. Analyze & Optimize.mp4
05:15
32. Suggested pragmas.mp4
05:22
33. Faster inserts.mp4
01:31
34. Introduction to indexes.mp4
05:32
35. B+ trees.mp4
05:00
36. Primary, secondary, and clustered indexes.mp4
08:06
37. Without rowid tables.mp4
01:55
38. Benchmarking without rowid tables.mp4
07:03
39. Imposter tables.mp4
03:23
40. Primary key data types.mp4
04:01
41. Where to add indexes.mp4
11:42
42. Index selectivity.mp4
09:13
43. Composite indexes.mp4
11:37
44. Composite ordering.mp4
03:00
45. Covering indexes.mp4
09:32
46. Partial indexes.mp4
08:06
47. Indexes on expressions.mp4
05:01
48. Automatic indexes.mp4
04:22
49. Duplicate indexes.mp4
06:16
50. Indexing joins.mp4
08:31
51. Explain.mp4
06:13
52. Index obfuscation.mp4
03:46
53. Joins.mp4
09:00
54. Subqueries.mp4
11:37
55. Unions.mp4
06:36
56. CTEs.mp4
03:47
57. Recursive CTEs.mp4
09:25
58. Window functions.mp4
10:52
59. Dealing with NULLs.mp4
03:35
60. Row value syntax.mp4
10:11
61. Indexed sorting.mp4
06:11
62. Upserts.mp4
07:55
63. Returning.mp4
03:33
64. Aggregates.mp4
09:58
65. Triggers.mp4
05:28
More details
User Reviews
Rating
average 0
Focused display
Category

Udemy
View courses UdemyStudents take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
- language english
- Training sessions 65
- duration 6:32:17
- Release Date 2024/12/03