SQL
Unleashed, Second Edition, covers ANSII
SQL and how to
implement them with several major
relational database
platforms used on a day-to-day basis.
SQL Unleashed focuses
on more intermediate to advanced topics and the latest
trends forthcoming in
SQL. Designed to be used as both a
reference and implementation tool, this book serves as a
practical, pragmatic guide to day-to-day SQL programming
and provide the most efficient solutions for getting the
job done. Topics include database design and
data
definition, data manipulation, data selection, more
advanced, QL implementations, the future of SQL, and vendor
SQL extensions.
- Shows how to implement ANSII SQL with several major
relational database platforms such as SQL Server, Oracle,
DB2, SQL/DS, Sybase, and others
- SQL Unleashed discusses the latest trends: SQL 3, Call
Level Interface and Persistent Stored Modules
- CD-ROM contains all SQL code from the book and third
party programs that help create and analyze SQL
statements
Table of contents
Structured Query Language (SQL) Standards
Relational Databases
Table Creation and Manipulation
Data Types
Handling Arrays in SQL
Other Schema Objects
Inserts, Updates, and Deletes
Transactions in SQL
Patterns and Ranges in SQL
10Table Joins
Sorting and Grouping
Sets and Subsets Operations
Subqueries
Creating and Using Views
Trees and Hierarchies
Dynamic SQL
Embedded SQL
Implementing Cursors
Optimizing Query Performance
Security Issues
Call Level Interface (CLI)
Persistent Stored Modules (PSM)
The Next Standard: SQL-99
Oracle SQL
Oracle PL/SQL
Microsoft Transact-SQL
An Introduction to SQL
Index