SQL经典英文原版教材
Sams Teach Yourself SQL in 24 Hours 5th Edition
Contents at a Glance
Part I: An SQL Concepts Overview
HOUR 1Welcome to the World of SQL....................................................... 1
Part II: Building Your Database
HOUR 2Defining Data Structures............................................................ 21
3 Managing Database Objects....................................................... 37
4 The Normalization Process......................................................... 61
5 Manipulating Data................................................................... 73
6 Managing Database Transactions................................................ 87
Part III: Getting Effective Results from Queries
HOUR 7Introduction to the Database Query............................................. 99
8 Using Operators to Categorize Data............................................ 115
9 Summarizing Data Results from a Query.................................... 141
10 Sorting and Grouping Data....................................................... 153
11 Restructuring the Appearance of Data........................................ 169
12 Understanding Dates and Times................................................ 191
Part IV: Building Sophisticated Database Queries
HOUR 13Joining Tables in Queries.......................................................... 207
14 Using Subqueries to Define Unknown Data.................................. 225
15 Combining Multiple Queries into One........................................ 239
Part V: SQL Performance Tuning
HOUR 16Using Indexes to Improve Performance....................................... 255
17 Improving Database Performance.............................................. 267
Part VI: Using SQL to Manage Users and Security
HOUR 18Managing Database Users........................................................ 285
19 Managing Database Security..................................................... 299
Part VII: Summarized Data Structures
HOUR 20Creating and Using Views and Synonyms.................................... 313
21 Working with the System Catalog.............................................. 329
Part VIII: Applying SQL Fundamentals in Today’s World
HOUR 22Advanced SQL Topics............................................................... 339
23 Extending SQL to the Enterprise, the Internet, and the Intranet....... 355
24 Extensions to Standard SQL....................................................... 367
Part IX: Appendixes
A Common SQL Commands........................................................ 377
B Using the Databases for Exercises............................................... 383
C Answers to Quizzes and Exercises............................................... 391
DCREATE TABLE Statements for Book Examples.............................. 439
E INSERT Statements for Data in Book Examples............................. 443
F Glossary................................................................................. 451
GBonus Exercises....................................................................... 455
Index.................................................................................... 461