Sams Teach Yourself SQL in 24 Hours, Third Edition presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
* ExpandIntroduction
* ExpandPart I: A SQL Concepts Overview
* ExpandHour 1. Welcome to the World of SQL
* ExpandPart II: Building Your Database
* ExpandHour 2. Defining Data Structures
* ExpandHour 3. Managing Database Objects
* ExpandHour 4. The Normalization Process
* ExpandHour 5. Manipulating Data
* ExpandHour 6. Managing Database Transactions
* ExpandPart III: Getting Effective Results from Queries
* ExpandHour 7. Introduction to the Database Query
* ExpandHour 8. Using Operators to Categorize Data
* ExpandHour 9. Summarizing Data Results from a Query
* ExpandHour 10. Sorting and Grouping Data
* ExpandHour 11. Restructuring the Appearance of Data
* ExpandHour 12. Understanding Dates and Times
* ExpandPart IV: Building Sophisticated Database Queries
* ExpandHour 13. Joining Tables in Queries
* ExpandHour 14. Using Subqueries to Define Unknown Data
* ExpandHour 15. Combining Multiple Queries into One
* ExpandPart V: SQL Performance Tuning
* ExpandHour 16. Using Indexes to Improve Performance
* ExpandHour 17. Improving Database Performance
* ExpandPart VI: Using SQL to Manage Users and Security
* ExpandHour 18. Managing Database Users
* ExpandHour 19. Managing Database Security
* ExpandPart VII: Summarized Data Structures
* ExpandHour 20. Creating and Using Views and Synonyms
* ExpandHour 21. Working with the System Catalog
* ExpandPart VIII: Applying SQL Fundamentals in Today's World
* ExpandHour 22. Advanced SQL Topics
* ExpandHour 23. Extending SQL to the Enterprise, the Internet, and the Intranet
* ExpandHour 24. Extensions to Standard SQL
Book Link:
http://www.informit.com/library/library.aspx?b=STY_Sql_24hours
Sams Teach Yourself SQL in 24 Hours
Labels: MS SQL Server