In just 24 lessons of one hour or less, you will learn professional techniques to design and build efficient databases and query them to extract useful information. Using a straightforward, step-by-step approach, each lesson builds on the previous one, allowing you to learn the essentials of ANSI SQL from the ground up.
Example code demonstrates the authors’ professional techniques, while exercises written for MySQL offer the reader hands-on learning with an open-source database. Included are advanced techniques for using views, managing transactions, database administration, and extending SQL.
Step-by-step instructions carefully walk you through the most common SQL tasks.
Q&As, Quizzes, and Exercises at the end of each chapter help you test your knowledge.
Notes and Tips point out shortcuts and solutions.
New terms are clearly defined and explained.
Learn how to…
Use SQL-2003, the latest standard for the Structured Query Language
Design and deploy efficient, secure databases
Build advanced queries for information retrieval
Sort, group, and summarize information for best presentation
Tune databases and queries for maximum performance
Understand database administration and security techniques
For more than ten years the authors have studied, applied, and documented the SQL standard and its application to critical database systems.
Ryan Stephens and Ron Plew are entrepreneurs, speakers, and cofounders of Perpetual Technologies, Inc. (PTI), a fast-growing IT management and consulting firm which specializes in database technologies. They taught database courses for Indiana University–Purdue University in Indianapolis for five years and have authored more than a dozen books on Oracle, SQL, database design, and the high availability of critical systems.
Arie D. Jones is Senior SQL Server database administrator and analyst for PTI. He is a regular speaker at technical events and has authored several books and articles.
Covers: ANSI SQL
User Level: Beginning–Intermediate
Register your book at informit.com/title/9780672330186 for convenient access to updates and corrections
as they become available.
Table of Contents
- About the Authors
- We Want to Hear from You
- Reader Services
I. A SQL Concepts Overview
1. Welcome to the World of SQL
- SQL Definition and History
- SQL Sessions
- Types of SQL Commands
- The Database Used in This Book
- 1. Welcome to the World of SQL
II. Building Your Database
- 2. Defining Data Structures
3. Managing Database Objects
- What Are Database Objects?
- What Is a Schema?
- A Table: The Primary Storage for Data
- Integrity Constraints
4. The Normalization Process
- Normalizing a Database
- Denormalizing a Database
5. Manipulating Data
- Overview of Data Manipulation
- Populating Tables with New Data
- Updating Existing Data
- Deleting Data from Tables
- 6. Managing Database Transactions
III. Getting Effective Results from Queries
7. Introduction to the Database Query
- What Is a Query?
- Introduction to the SELECT Statement
- Examples of Simple Queries
8. Using Operators to Categorize Data
- What Is an Operator in SQL?
- Comparison Operators
- Logical Operators
- Conjunctive Operators
- Negative Operators
- Arithmetic Operators
- 9. Summarizing Data Results from a Query
- 10. Sorting and Grouping Data
11. Restructuring the Appearance of Data
- ANSI Character Functions
- Various Common Character Functions
- Miscellaneous Character Functions
- Mathematical Functions
- Conversion Functions
- Combining Character Functions
12. Understanding Dates and Times
- How Is a Date Stored?
- Date Functions
- Date Conversions
- 7. Introduction to the Database Query
IV. Building Sophisticated Database Queries
13. Joining Tables in Queries
- Selecting Data from Multiple Tables
- Types of Joins
- Join Considerations
- 14. Using Subqueries to Define Unknown Data
- 15. Combining Multiple Queries into One
- 13. Joining Tables in Queries
V. SQL Performance Tuning
- 16. Using Indexes to Improve Performance
17. Improving Database Performance
- What Is SQL Statement Tuning?
- Database Tuning Versus SQL Statement Tuning
- Formatting Your SQL Statement
- Full Table Scans
- Other Performance Considerations
- Performance Tools
VI. Using SQL to Manage Users and Security
18. Managing Database Users
- Users Are the Reason
- The Management Process
- Tools Utilized by Database Users
19. Managing Database Security
- What Is Database Security?
- What Are Privileges?
- Controlling User Access
- Controlling Privileges Through Roles
- 18. Managing Database Users
VII. Summarized Data Structures
20. Creating and Using Views and Synonyms
- What Is a View?
- Creating Views
- WITH CHECK OPTION
- Updating Data Through a View
- Creating a Table from a View
- Views and the ORDER BY Clause
- Dropping a View
- What Is a Synonym?
21. Working with the System Catalog
- What Is the System Catalog?
- How Is the System Catalog Created?
- What Is Contained in the System Catalog?
- System Catalog Tables by Implementation
- Querying the System Catalog
- Updating System Catalog Objects
- 20. Creating and Using Views and Synonyms
VIII. Applying SQL Fundamentals in Today’s World
22. Advanced SQL Topics
- Stored Procedures and Functions
- Dynamic SQL
- Call-Level Interface
- Using SQL to Generate SQL
- Direct Versus Embedded SQL
- Windowed Table Functions
- Working with XML
23. Extending SQL to the Enterprise, the Internet, and the Intranet
- SQL and the Enterprise
- Accessing a Remote Database
- SQL and the Internet
- SQL and the Intranet
- 24. Extensions to Standard SQL
- 22. Advanced SQL Topics
- A. Common SQL Commands
- B. Using MySQL for Exercises
C. Answers to Quizzes and Exercises
- 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”
- D. CREATE TABLE Statements for Book Examples
- E. INSERT Statements for Book Examples
- F. Bonus Exercises
- Title: Sams Teach Yourself SQL
- Release date: May 2008
- Publisher(s): Sams
- ISBN: 9780768682779