SQL Bible

Combining theory with everyday practicality, this definitive volume is packed with the up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

Alex Kriegel, PMP, MCSD/MCTS, works as a Systems Architect for the State of Oregon; prior to this he worked for Pope and Talbot, Inc., Psion Teklogix International, Inc., and for Belorussian Academy of Sciences. He received his MSc. in Physics of Metals from Belarus State Polytechnic Institute in 1988, discovered PC programming and relational databases in 1992, and has never looked back since. Alex is certified as a Project Management Professional (PMP) by the Project Management Institute, and also holds various Microsoft certifications. He is also the author of Microsoft SQL Server 2000 Weekend Crash Course (Wiley, 2001), SQL Functions (Wrox, 2005), and co-author of Introduction to Database Management (Wiley, 2007), and the first edition of this book.

Boris M. Trukhnov, OCP, has been working as Senior Technical Analyst/Oracle DBA for Pope & Talbot, Inc., in Portland, Oregon, since 1998. His previous job titles include Senior Programmer Analyst, Senior Software Developer, and Senior Operations Analyst. He has been working with SQL and relational databases since 1994. Boris holds a B.S. in Computer Science from the University of Minnesota. He is a co-author of Introduction to Database Management (Wiley, 2007).

Acknowledgements
Introduction
SQL Basic Concepts and Principles
SQL and Relational Database Management Systems
Fundamental SQL Concepts and Principles
SQL Data Types
Creating and Modifying Database Objects
Creating RDBMS Objects
Altering and Destroying RDBMS Objects
Data Manipulation and Transaction Control
Data Manipulation Language (DML)
Sessions, Transactions, and Locks
Retrieving and Transferring Data
Understanding the SELECT Statement
Multitable Queries
SQL Functions
SQL Operators
Implementing Security Using the System Catalog
SQL and RDBMS Security
The System Catalog and Information Schema
Beyond SQL: Procedural Programming and Database Access Mechanisms
Stored Procedures, Triggers, and User-Defined Functions
SQL and XML
SQL and Procedural Programming
The Future of SQL
Accompanying Website
The ACME Sample Database
Basics of Relational Database Design
Installing RDBMS Software
Accessing RDBMS
Installing the ACME Database
SQL Functions
SQL Syntax Reference
SQL-Reserved Keywords
The Other RDBMSs
A Brief Introduction to Number Systems, Boolean Algebra, and Set Theory
Index
Table of Contents provided by Publisher. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Summary

Author Biography

Table of Contents

Supplemental Materials