| |
| |
| Introduction | |
| |
| |
| |
| A SQL Concepts Overview | |
| |
| |
| |
| Welcome to the World of SQL | |
| |
| |
| SQL Definition and History | |
| |
| |
| SQL Sessions | |
| |
| |
| Disconnect | |
| |
| |
| Types of SQL Commands | |
| |
| |
| An Introduction to the Database Used in This Book | |
| |
| |
| |
| A SQL Concepts Overview | |
| |
| |
| |
| Defining Data Structures | |
| |
| |
| What Is Data? | |
| |
| |
| Basic Data Types | |
| |
| |
| |
| Managing Database Objects | |
| |
| |
| What Are Database Objects? | |
| |
| |
| What Is a Schema? | |
| |
| |
| A Table: The Primary Storage for Data | |
| |
| |
| Integrity Constraints | |
| |
| |
| |
| The Normalization Process | |
| |
| |
| Normalizing a Database | |
| |
| |
| |
| Manipulating Data | |
| |
| |
| Overview of Data Manipulation | |
| |
| |
| Populating Tables with New Data | |
| |
| |
| Updating Existing Data | |
| |
| |
| Deleting Data from Tables | |
| |
| |
| |
| Managing Database Transactions | |
| |
| |
| What Is a Transaction? | |
| |
| |
| What Is Transactional Control? | |
| |
| |
| Transactional Control and Database Performance | |
| |
| |
| |
| Getting Effective Results from Queries | |
| |
| |
| |
| Introduction to the Database Query | |
| |
| |
| What Is a Query? | |
| |
| |
| Introduction to the SELECT Statement | |
| |
| |
| Examples of Simple Queries | |
| |
| |
| |
| Using Operators to Categorize Data | |
| |
| |
| What Is an Operator in SQL? | |
| |
| |
| Comparison Operators | |
| |
| |
| Logical Operators | |
| |
| |
| Conjunctive Operators | |
| |
| |
| Negating Conditions with the NOT Operator | |
| |
| |
| Arithmetic Operators | |
| |
| |
| |
| Summarizing Data Results from a Query | |
| |
| |
| What Are Aggregate Functions? | |
| |
| |
| |
| Sorting and Grouping Data | |
| |
| |
| Why Group Data? | |
| |
| |
| The GROUP BY Clause | |
| |
| |
| GROUP BY Versus ORDER BY | |
| |
| |
| The HAVING Clause | |
| |
| |
| |
| Restructuring the Appearance of Data | |
| |
| |
| The Concepts of ANSI Character Functions | |
| |
| |
| Various Common Character Functions | |
| |
| |
| Miscellaneous Character Functions | |
| |
| |
| Mathematical Functions | |
| |
| |
| Conversion Functions | |
| |
| |
| The Concept of Combining Character Functions | |
| |
| |
| |
| Understanding Dates and Times | |
| |
| |
| How Is a Date Stored? | |
| |
| |
| Date Functions | |
| |
| |
| Date Conversions | |
| |
| |
| |
| Building Sophisticated Database Queries | |
| |
| |
| |
| Joining Tables in Queries | |
| |
| |
| Selecting Data from Multiple Tables | |
| |
| |
| Types of Joins | |
| |
| |
| Join Considerations | |
| |
| |
| |
| Using Subqueries to Define Unknown Data | |
| |
| |
| What Is a Subquery? | |
| |
| |
| Embedding a Subquery Within a Subquery | |
| |
| |
| |
| Combing Multiple Queries into One | |
| |
| |
| Single Queries Versus Compound Queries | |
| |
| |
| Why Would I Ever Want to Use a Compound Query? | |
| |
| |
| Compound Query Operators | |
| |
| |
| Using an ORDER BY with a Compound Query | |
| |
| |
| Using a GROUP BY with a Compound Query | |
| |
| |
| Retrieving Accurate Data | |
| |
| |
| |
| SQL Performance Tuning | |
| |
| |
| |
| Using Indexes to Improve Performance | |
| |
| |
| What Is an Index? | |
| |
| |
| How Do Indexes Work? | |
| |
| |
| The GREATE INDEX Command | |
| |
| |
| Types of Indexes | |
| |
| |
| When Should Indexes Be Considered? | |
| |
| |
| When Should Indexes Be Avoided? | |
| |
| |
| |
| Improving Database Performance | |
| |
| |
| What Is SQL Statement Tuning? | |
| |
| |
| Database Tuning Versus SQL Tuning | |
| |
| |
| Formatting Your SQL Statement | |
| |
| |
| Full Table Scans | |
| |
| |
| Other Performance Considerations | |
| |
| |
| Performance Tools | |
| |
| |
| |
| Using SQL to Manage Users and Security | |
| |
| |
| |
| Managing Database Users | |
| |
| |
| Users Are the Reason | |
| |
| |
| The Management Process | |
| |
| |
| Tools Utilized by Database Users | |
| |
| |
| |
| Managing Database Security | |
| |
| |
| What Is Database Security? | |
| |
| |
| How Does Security Differ from User Management? | |
| |
| |
| What Are Privileges? | |
| |
| |
| Controlling User Access | |
| |
| |
| Controlling Privileges Through Roles | |
| |
| |
| |
| Summarized Data Structures | |
| |
| |
| |
| Creating and Using Views and Synonyms | |
| |
| |
| What Is a View? | |
| |
| |
| Creating Views | |
| |
| |
| Dropping a View | |
| |
| |
| What Is a Synonym? | |
| |
| |
| |
| Working with the System Catalog | |
| |
| |
| What Is the System Catalog? | |
| |
| |
| How Is the System Catalog Created? | |
| |
| |
| What Is Contained in the System Catalog? | |
| |
| |
| Examples of System Catalog Tables by Implementation | |
| |
| |
| Querying the System Catalog | |
| |
| |
| Updating System Catalog Objects | |
| |
| |
| |
| Applying SQL Fundamentals in Today's World | |
| |
| |
| |
| Advanced SQL Topics | |
| |
| |
| Advanced Topics | |
| |
| |
| Cursors | |
| |
| |
| Stored Procedures and Functions | |
| |
| |
| Triggers | |
| |
| |
| Dynamic SQL | |
| |
| |
| Call-Level Interface | |
| |
| |
| Using SQL to Generate SQL | |
| |
| |
| Direct Versus Embedded SQL | |
| |
| |
| |
| Extending SQL to the Enterprise, the Internet, and the Intranet | |
| |
| |
| SQL and the Enterprise | |
| |
| |
| Accessing a Remote Database | |
| |
| |
| Accessing a Remote Database Through a Web Interface | |
| |
| |
| SQL and the Internet | |
| |
| |
| SQL and the Intranet | |
| |
| |
| |
| Extensions to Standard SQL | |
| |
| |
| Various Implementations | |
| |
| |
| Examples of Extensions from Some Implementations | |
| |
| |
| Interactive SQL Statements | |
| |
| |
| |
| Applying SQL Fundamentals in Today's World | |
| |
| |
| |
| Common SQL Commands | |
| |
| |
| SQL Statements | |
| |
| |
| SQL Clauses | |
| |
| |
| |
| ASCII Table | |
| |
| |
| |
| Answers to Quizzes and Exercises | |
| |
| |
| |
| Create Table Statements for Book Examples | |
| |
| |
| |
| Insert Statements for Data in Book Examples | |
| |
| |
| Insert Statements | |
| |
| |
| |
| Glossary | |
| |
| |
| Index | |