Learn SQL The Hard Way A Learn Code The Hard Way Book

[next] [prev] [prev-tail] [tail] [up]

Part I
Basic Skills

1 Exercise 0: The Setup
 1.1 Additional Tools You'll Need
 1.2 Extra Credit
2 Exercise 1: Creating Tables
 2.1 What You Should See
 2.2 Extra Credit
 2.3 Portability Notes
3 Exercise 2: Creating A Multi-Table Database
 3.1 What You Should See
 3.2 Extra Credit
 3.3 Portability Notes
4 Exercise 3: Inserting Data
 4.1 What You Should See
 4.2 Extra Credit
 4.3 Portability Notes
5 Exercise 4: Insert Referential Data
 5.1 What You Should See
 5.2 Extra Credit
6 Exercise 5: Selecting Data
 6.1 What You Should See
 6.2 Extra Credit
 6.3 Portability Notes
7 Exercise 6: Select Across Many Tables
 7.1 What You Should See
 7.2 Extra Credit
 7.3 Portability Notes
8 Exercise 7: Deleting Data
 8.1 What You Should See
 8.2 Extra Credit
9 Exercise 8: Deleting Using Other Tables
 9.1 What You Should See
 9.2 Extra Credit
 9.3 Portability Notes
10 Exercise 9: Updating Data
 10.1 What You Should See
 10.2 Extra Credit
11 Exercise 10: Updating Complex Data
 11.1 What You Should See
 11.2 Extra Credit
12 Exercise 11: Replacing Data
 12.1 What You Should See
 12.2 Extra Credit
 12.3 Portability Notes
13 Exercise 12: Destroying And Altering Tables
 13.1 What You Should See
 13.2 Extra Credit
 13.3 Portability Notes
14 Exercise 13: Migrating And Evolving Data
 14.1 The Assignment
15 Exercise 14: Basic Transactions
 15.1 Extra Credit
 15.2 Portability Notes
16 Exercise 15: Data Modeling
 16.1 Aesthetic Guidelines
 16.2 Designing The Data Model
 16.3 Implementing The SQL
 16.4 Implementing With Object-Relational Mappers
 16.5 Final Steps
 16.6 Extra Credit
17 Exercise 16: Making Indices
 17.1 What You Should See
 17.2 Extra Credit
 17.3 Portability Notes
18 Exercise 17: Optimizing A Database
 18.1 What You Should See
 18.2 Extra Credit
 18.3 Portability Notes
19 Exercise 18: Using Triggers
 19.1 What You Should See
 19.2 Extra Credit
 19.3 Portability Notes
20 Exercise 19: Updating One Table From Another
 20.1 What You Should See
 20.2 Extra Credit
 20.3 Portability Notes
21 Exercise 20: Working With Views
 21.1 What You Should See
 21.2 Extra Credit
 21.3 Portability Notes
22 Exercise 21: Simple Data Analysis With Views
 22.1 What You Should See
 22.2 Extra Credit
 22.3 Portability Notes
23 Exercise 22: GROUP BY And Counts
 23.1 What You Should See
 23.2 Extra Credit
 23.3 Portability Notes
24 Exercise 23: Date And Time Functions
 24.1 What You Should See
 24.2 Extra Credit
 24.3 Portability Notes
25 Exercise 24: Range Queries By Dates
 25.1 What You Should See
 25.2 Extra Credit
 25.3 Portability Notes
26 Exercise 25: Getting Averages
 26.1 What You Should See
 26.2 Extra Credit
 26.3 Portability Notes
27 Exercise 26: Maximums And Minimums
 27.1 What You Should See
 27.2 Extra Credit
 27.3 Portability Notes

[next] [prev] [prev-tail] [front] [up]

Take An Online Video Course

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