Part II
Advanced Topics

28 Exercise 27: Safe Data Practices With Transactions
 28.1 What You Should See
 28.2 Extra Credit
 28.3 Portability Notes
29 Exercise 28: Advanced Transactions And Savepoints
 29.1 What You Should See
 29.2 Extra Credit
 29.3 Portability Notes
30 Exercise 29: Sums And Totals
 30.1 What You Should See
 30.2 Extra Credit
 30.3 Portability Notes
31 Exercise 30: Logic And Math Expressions
 31.1 What You Should See
 31.2 Extra Credit
 31.3 Portability Notes
32 Exercise 31: More Statistics And Math
 32.1 What You Should See
 32.2 Extra Credit
 32.3 Portability Notes
33 Exercise 32: String Manipulation
 33.1 What You Should See
 33.2 Extra Credit
 33.3 Portability Notes
34 Exercise 33: Fixing Databases With Bad Input
 34.1 What You Should See
 34.2 Extra Credit
 34.3 Portability Notes
35 Exercise 34: Math Functions
 35.1 What You Should See
 35.2 Extra Credit
 35.3 Portability Notes
36 Exercise 35: More Data Analysis
 36.1 What You Should See
 36.2 Extra Credit
 36.3 Portability Notes
37 Exercise 36: Complex Decision Expressions
 37.1 What You Should See
 37.2 Extra Credit
 37.3 Portability Notes
38 Exercise 37: Attaching And Detaching Databases
 38.1 What You Should See
 38.2 Extra Credit
 38.3 Portability Notes
39 Exercise 38: Analyzing Tables
 39.1 What You Should See
 39.2 Extra Credit
 39.3 Portability Notes
40 Exercise 39: Explaining Queries
 40.1 What You Should See
 40.2 Extra Credit
 40.3 Portability Notes
41 Exercise 40: Optimizing More With EXPLAIN
 41.1 What You Should See
 41.2 Extra Credit
 41.3 Portability Notes
42 Exercise 41: Forcing Reindexing
 42.1 What You Should See
 42.2 Extra Credit
 42.3 Portability Notes
43 Exercise 42: Vacuuming Junk
 43.1 What You Should See
 43.2 Extra Credit
 43.3 Portability Notes
44 Exercise 43: Setting Options With PRAGMA
 44.1 What You Should See
 44.2 Extra Credit
 44.3 Portability Notes
45 Exercise 44: Handy Pragmas
 45.1 What You Should See
 45.2 Extra Credit
 45.3 Portability Notes
46 Exercise 45: Using Reserved Words In Queries
 46.1 What You Should See
 46.2 Extra Credit
 46.3 Portability Notes
47 Exercise 46: Designing A Real Database
 47.1 What You Should See
 47.2 Extra Credit
 47.3 Portability Notes
48 Exercise 47: Mapping OOP Concepts To SQL
 48.1 What You Should See
 48.2 Extra Credit
 48.3 Portability Notes
49 Exercise 48: Using The Database From Python
 49.1 What You Should See
 49.2 Extra Credit
 49.3 Portability Notes
50 Exercise 49: Using The Database From C
 50.1 What You Should See
 50.2 Extra Credit
 50.3 Portability Notes
51 Exercise 50: Using The Database From R
 51.1 What You Should See
 51.2 Extra Credit
 51.3 Portability Notes
52 Exercise 51: Using The Database From Objective-C
 52.1 What You Should See
 52.2 Extra Credit
 52.3 Portability Notes
53 Exercise 52: Final Exam Extend And Optimize The Database
 53.1 What You Should See
 53.2 Extra Credit
 53.3 Portability Notes
54 Next Steps


Take An Online Video Course

I will be offering this book as a video course soon. Stay tuned.