Sams Teach Yourself SQL in 24 hours

• Build and manage relational database objects
  
• Effectively query the database
  
• Master functions and clauses to query data
  
• Manage database transactions
  
• Summarize data with views
  
• Uncover ways to summarize, sort and group, and restructure the appearance of data
  
• Performance tune SQL statements
  
• Use SQL to implement database security

Table of contents

Introduction

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 5: Manipulating Data

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 Tody's World

Hour 22: Advanced SQL Topics

Hour 23: Extending SQL to the Enterprise, the Internet, and the Intranet

Hour 24: Extensions to Standard SQL

Part X: Appendixes

Index