Ryan Stephens - SQL in 24 Hours - 5th Edition - Teach Yourself [2011, PDF, ENG]

HOUR 1 Welcome to the World of SQL 1
Part II: Bulldlng 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: Gettlng Effective Results from Queries
HOUR 1 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: Bulldlng Sophlstlcated Database Querles
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: Uslng SQI. to Manage Users and Securlty
HOUR 18 Managing Database Users 285
19 Managing Database Security 299
Part VII: summarlzed Data structures
HOUR 20 Creating and Using Views and Synonyms 313
21 Working with the System Catalog 329
Part VIII: Applylng 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