SQL Bible

by Kriegel, Alex; Trukhnov, Boris M.

• ISBN13: 9780470229064
• ISBN10: 0470229063
• Edition: 2nd
• Format: Paperback
• Copyright: 2008-04-07
• Publisher: Wiley

Summary

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.

Author Biography

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

Table of Contents

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.