Part I: An SQL Concepts Overview
Hour 1. Welcome to the World of SQL
Part II: Building Your Database
Hour 2. Defining Data Structures
Hour 3. Managing Database Objects
Hour 4. The Normalization Process
Hour 6. Managing Database Transactions
Part III: Getting Effective Results from Queries
Hour 7. Introduction to the Database Query
Hour 8. Using Operators to Categorize Data
Hour 9. Summarizing Data Results from a Query
Hour 10. Sorting and Grouping Data
Hour 11. Restructuring the Appearance of Data
Hour 12. Understanding Dates and Times
Part IV: Building Sophisticated Database Queries
Hour 13. Joining Tables in Queries
Hour 14. Using Subqueries to Define Unknown Data
Hour 15. Combining Multiple Queries into One
Part V: SQL Performance Tuning
Hour 16. Using Indexes to Improve Performance
Hour 17. Improving Database Performance
Part VI: Using SQL to Manage Users and Security
Hour 18. Managing Database Users
Hour 19. Managing Database Security
Part VII: Summarized Data Structures
Hour 20. Creating and Using Views and Synonyms
Hour 21. Working with the System Catalog
Part VIII: Applying SQL Fundamentals in Today’s World
Hour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
Hour 24. Extensions to Standard SQL
Appendix A: Common SQL Commands
Appendix B: Using the Databases for Exercises
Appendix C: Answers to Quizzes and Exercises
Appendix D: CREATE TABLE Statements for Book Examples
18.190.156.212