Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Contents at a Glance
- Part I: An SQL Concepts Overview
- HOUR 1 Welcome to the World of SQL . 1
- Part II: Building Your Database
- HOUR 2 Defining 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 7 Introduction 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 13 Joining 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 16 Using Indexes to Improve Performance . 255
- 17 Improving Database Performance . 267
- Part VI: Using SQL to Manage Users and Security
- HOUR 18 Managing Database Users . 285
- 19 Managing Database Security . 299
- Part VII: Summarized Data Structures
- HOUR 20 Creating and Using Views and Synonyms . 313
- 21 Working with the System Catalog . 329
- Part VIII: Applying SQL Fundamentals in Today’s World
- HOUR 22 Advanced 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
- D CREATE TABLE Statements for Book Examples . 439
- E INSERT Statements for Data in Book Examples . 443
- F Glossary . 451
- G Bonus Exercises . 455
Advertisement
Add Comment
Please, Sign In to add comment
