Sams Teach Yourself SQL

in 24 Hours 

4^TH Edition

 

 

This edition will mainly consist of updating ANSI SQL references to implement the newer 2003 standard with the 2006 XML add-on. This will also include updating references to MySQL content as the 5.0 version of the database supports more ANSI-compliant commands. Other sections have been added that would include newer functions within the ANSI standard that are supported as well.

 

Table of Contents

 

Part I: A SQL Concepts Overview

   1. Welcome to the World of SQL

 

Part II: Building Your Database

   2. Defining Data Structures

   3. Managing Database Objects

   4. The Normalization Process

   5. Manipulating Data

   6. Managing Database Transactions

 

Part III: Getting Effective Results from Queries

   7. Introduction to the Database Query

   8. Using Operators to Categorize Data

   9. Summarizing Data Results from a Query

  10. Sorting and Grouping Data

  11. Restructuring the Appearance of Data

  12. Understanding Dates and Times

 

Part IV: Building Sophisticated Database Queries

  13. Joining Tables in Queries

  14. Using Subqueries to Define Unknown Data

  15. Combining Multiple Queries into One

 

Part V: SQL Performance Tuning

  16. Using Indexes to Improve Performance

  17. Improving Database Performance

 

Part VI: Using SQL to Manage Users and Security

  18. Managing Database Users

  19. Managing Database Security

 

Part VII: Summarized Data Structures

  20. Creating and Using Views and Synonyms

  21. Working with the System Catalog

 

Part VIII: Applying SQL Fundamentals in Today's World

  22. Advanced SQL Topics

  23. Extending SQL to the Enterprise, the Internet, and the Intranet

  24. Extensions to Standard SQL

 

Part IX: Appendixes

 

Salient Features

 

SQL is the foundation for querying databases; anyone working with databases regularly needs to learn SQL

This book helps anyone get up to speed on SQL fast - with no previous experience required

Fully updated for the most recent SQL standards

Each chapter builds on the previous one with real world examples and hands on exercises

 

Publisher	SAMS
Author	Ryan Stephens Ron Plew Arie D. Jones
Pages	504
Price	INR Rs. 324.00