| |
| |
Acknowledgments | |
| |
| |
Introduction | |
| |
| |
SQL Basics--Easy as ABC | |
| |
| |
What Is SQL? | |
| |
| |
What Is SQL? | |
| |
| |
SQL-92: What Does It Have That the Others Didn't? | |
| |
| |
SQL Is Divided into Three Parts | |
| |
| |
The Database--A Place for Everything and Everything in Its Place | |
| |
| |
Types of Databases | |
| |
| |
What Is in a Database? | |
| |
| |
The Relational Model | |
| |
| |
Client/Server Architecture | |
| |
| |
Open Database Connectivity (ODBC) | |
| |
| |
Understanding the SQL Language | |
| |
| |
The SELECT Statement and Its Clauses | |
| |
| |
Expressions, Conditions, and Operators, Oh My! | |
| |
| |
Functions | |
| |
| |
What's Next? | |
| |
| |
Building Tables and Views | |
| |
| |
Overview of Oracle8 | |
| |
| |
Building Tables with Oracle8 | |
| |
| |
Transaction Management | |
| |
| |
The Set Transaction Statement | |
| |
| |
The Four Transaction Problems | |
| |
| |
Locking | |
| |
| |
Transactions in Action | |
| |
| |
What's Next | |
| |
| |
Database Security | |
| |
| |
What Does a DBA Do? | |
| |
| |
How SQL Handles Security | |
| |
| |
How Much Security Is Too Much? | |
| |
| |
What's Next? | |
| |
| |
Queries-The Heart and Soul of SQL | |
| |
| |
The Simple One-Table Query | |
| |
| |
The SELECT Statement | |
| |
| |
The Single-Table View | |
| |
| |
What's Next? | |
| |
| |
Complex Multitable Queries | |
| |
| |
The Ins and Outs of Joins | |
| |
| |
Summary Queries | |
| |
| |
Putting It All Together--The Whole Enchilada! | |
| |
| |
What's Next? | |
| |
| |
The Subquery | |
| |
| |
The Subquery Revealed | |
| |
| |
Queries--A Review | |
| |
| |
What's Next? | |
| |
| |
Optimizing SQL | |
| |
| |
How the Database Engine Processes SQL | |
| |
| |
Tuning a Database | |
| |
| |
What's Next? | |
| |
| |
Putting It All Together--SQL in Action | |
| |
| |
Creating a Database | |
| |
| |
Business Needs Analysis | |
| |
| |
What's Next? | |
| |
| |
Designing the Database Front End | |
| |
| |
Planning the User Interface | |
| |
| |
Other Development Tools | |
| |
| |
What's Next? | |
| |
| |
Designing Forms in Access | |
| |
| |
Access Design Environment | |
| |
| |
What's Next? | |
| |
| |
Querying the Database | |
| |
| |
Access Queries | |
| |
| |
Creating Hush Select Queries | |
| |
| |
What's Next? | |
| |
| |
Reporting | |
| |
| |
Types of Reporting Tools | |
| |
| |
How to Choose Your Reporting Tool | |
| |
| |
Report Development | |
| |
| |
What's Next? | |
| |
| |
SQL Today and Tomorrow | |
| |
| |
T-SQL and Stored Procedures | |
| |
| |
Understanding Stored Procedures and Cursors | |
| |
| |
What's Next? | |
| |
| |
Advanced T-SQL Topics | |
| |
| |
Using Cursors | |
| |
| |
System Stored Procedures | |
| |
| |
T-SQL for Administrators | |
| |
| |
Triggers | |
| |
| |
Jobs | |
| |
| |
What's Next? | |
| |
| |
SQL*Plus | |
| |
| |
Getting Around in SQL*Plus | |
| |
| |
Formatting Queries | |
| |
| |
What's Next? | |
| |
| |
PL/SQL Basics | |
| |
| |
Character Set | |
| |
| |
Identifiers | |
| |
| |
Reserved Words | |
| |
| |
Literals | |
| |
| |
The Semicolon Delimiter | |
| |
| |
The Pragma Keyword | |
| |
| |
Block Structure | |
| |
| |
Data Types | |
| |
| |
Procedures, Functions, IF Statements, and Loops | |
| |
| |
What's Next? | |
| |
| |
Programming with SQL | |
| |
| |
How Applications Employing SQL Are Built | |
| |
| |
How ODBC Drivers and Databases Process SQL Commands | |
| |
| |
How to Set Up an ODBC Data Source | |
| |
| |
Programming SQL with C | |
| |
| |
Programming Dynamic SQL with Visual Basic | |
| |
| |
Programming with SQL in Java | |
| |
| |
What's Next? | |
| |
| |
Everyone Makes Mistakes | |
| |
| |
Top Ten Common Mistakes | |
| |
| |
Something Doesn't Look Right! | |
| |
| |
Error Prevention | |
| |
| |
What's Next? | |
| |
| |
The Future--SQL3 | |
| |
| |
SQL3 | |
| |
| |
What's Next? | |
| |
| |
Terms | |
| |
| |
Read More About It | |
| |
| |
Books | |
| |
| |
Magazines, Journals, and Organizations | |
| |
| |
Business Intelligence Vendors | |
| |
| |
Database Vendors | |
| |
| |
Sybase, Inc. | |
| |
| |
Index | |