Sams teach yourself

Includes index

Understanding the relational database and SQL -- Exploring the components of the SQL language -- Getting to know your data -- Setting up your database -- Understanding the basics of relational (SQL) database design -- Defining entities and relationships -- Normalizing your database -- Defining data structures -- Creating and managing database objects -- Manipulating data -- Managing database transactions -- Introduction to database queries -- Using operators to categorize data -- Joining tables in queries -- Restructuring the appearance of data -- Understanding dates and times -- Summarizing data results from a query -- Using subqueries to define unknown data -- Combining multiple queries into one -- Creating and using views and synonyms -- Managing database users and security -- Using indexes to improve performance -- Improving database performance -- Working with the system catalog -- Bonus workshop for the road -- Appendixes. Common SQL commands ; Popular vendor RDBMS implementations -- Answers to quizzes and exercises

Featuring step-by-step instructions that walk you through the most common SQL tasks, this authoritative resource helps you use SQL to build effective data bases, efficiently review data and manage everything from performance to security