| |
| |
| 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 | |