Sams teach yourself SQL in 24 hours

• SQL (Standard Query Language) is the ANSI standard language that allows people to create, access, manipulate, and store information in a relational database management system
• SQL is the core element of databases from companies such as Oracle, Microsoft, Informix, etc.
• The SQL market is widespread; all database programmers, developers, and administrators use this language to manipulate data

Table of contents

Introduction

Hour 1: Welcome to the World of SQL

Hour 2: Defining Data Structures

Hour 3: Managing Database Objects

Hour 4: The Normalization Process

Hour 5: Manipulating Data

Hour 6: Managing Database Transactions

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 Time

Hour 13: Joining Tables in Queries

Hour 14: Using Subqueries to Define Unknown Data

Hour 15: Combining Multiple Queries into One

Hour 16: Using Indexes to Improve Performance

Hour 17: Improving Database Performance

Hour 18: Managing Database Users

Hour 19: Managing Database Security

Hour 20: Creating and Using Views and Synonyms

Hour 21: Working with the System Catalog

Hour 22: Advanced SQL Topics

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: ASCII Table

Appendix C: Answers to Quizzes and Exercises

Appendix D: Create Table Statements for Book Examples

Appendix E: Insert Statements for Data in Book Examples

Glossary

Index