High Performance SQLite

2.78 GB | 00:10:52 | mp4 | 1920X1080 | 16:9
Genre:eLearning |Language:English

Files Included :
01 Introduction to this course (30.29 MB)
02 Introduction to SQLite (34.34 MB)
03 SQLite is safe (20.6 MB)
04 It's just a file (19.66 MB)
05 Running SQLite locally (18.61 MB)
06 Good uses for SQLite (38.1 MB)
07 SQLite's limitations (21.82 MB)
08 The documentation (13.45 MB)
09 SQLite's structure (27.39 MB)
10 SQLite's file format (24.45 MB)
11 Dot commands (40.44 MB)
12 Pragmas (30.04 MB)
13 Virtual tables (17.21 MB)
14 Flexible types (28.3 MB)
15 Types (53.53 MB)
16 Strict types (25.35 MB)
17 Dates (39.09 MB)
18 Booleans (3.77 MB)
19 Floating point (35.46 MB)
20 Rowid tables (48.36 MB)
21 Auto increments (32.17 MB)
22 Without rowid (17.46 MB)
23 Generated columns (33.29 MB)
24 Locking (29.45 MB)
25 Rollback mode (24.67 MB)
26 WAL mode (26.27 MB)
27 WAL vs Journal benchmarks (33.89 MB)
28 Busy timeout (19.3 MB)
29 Transaction modes (19.89 MB)
30 Vacuum (34.14 MB)
31 Analyze & Optimize (22.51 MB)
32 Suggested pragmas (32.63 MB)
33 Faster inserts (9.1 MB)
34 Introduction to indexes (36.86 MB)
35 B+ trees (27.13 MB)
36 Primary, secondary, and clustered indexes (52.11 MB)
37 Without rowid tables (12.52 MB)
38 Benchmarking without rowid tables (41.83 MB)
39 Imposter tables (14.01 MB)
40 Primary key data types (27.1 MB)
41 Where to add indexes (54.89 MB)
42 Index selectivity (43.07 MB)
43 Composite indexes (62.24 MB)
44 Composite ordering (14.55 MB)
45 Covering indexes (44.66 MB)
46 Partial indexes (39.04 MB)
47 Indexes on expressions (22.93 MB)
48 Automatic indexes (18.72 MB)
49 Duplicate indexes (29.35 MB)
50 Indexing joins (44.67 MB)
51 Explain (28.81 MB)
52 Index obfuscation (19.78 MB)
53 Joins (59.39 MB)
54 Subqueries (61.61 MB)
55 Unions (33.29 MB)
56 CTEs (20.02 MB)
57 Recursive CTEs (45.53 MB)
58 Window functions (77.09 MB)
59 Dealing with NULLs (15.72 MB)
60 Row value syntax (56.9 MB)
61 Indexed sorting (27.59 MB)
62 Upserts (43.32 MB)
63 Returning (18.89 MB)
64 Aggregates (48.8 MB)
65 Triggers (27.72 MB)]
Screenshot