Book Description
Covers the latest version of the ISO SQL standard (SQL-99) and gives readers information they need to know about the differences in vendor-specific SQL implementations including Oracle, Microsoft SQL Server, and IBM DB2 Knowledge of this ubiquitous database programming language is becoming more critical as IT departments move toward more integrated heterogeneous platforms Covers growing use of SQL with Web services and XML CD-ROM includes a complete sample database and trial versions of major relational database management software





From the Back Cover
If SQL can do it, you can do it too...

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. Tutorials and code examples in each chapter make it an indispensable reference for every level of expertise.

Inside, you’ll find complete coverage of SQL Understand the definition and characteristics of relational databases and SQL’s role within RDBMS Recognize vendor-specific implementation variations among Oracle, IBM DB2 UDB, and MS SQL Server Create and modify RDBMS objects like tables, views, indexes, synonyms, sequences, and schemas using Data Definition Language (DDL) Comprehend Data Manipulation Language (DML) from different vendors’ perspectives Master single-table select statements and multitable queries from the ground up</ LI> Explore in-depth SQL functions, operators, and data types for major RDBMS implementations Discover new SQL developments including XML, OLAP, Web services, and object-oriented features

Bonus CD-ROM includes: IBM® DB2® Universal Database Personal Edition v 8.1 for Windows® Operating Environments Evaluation copy Complete original database example files from the authors Complete book in PDF format


About the Author
Alex Kriegel, MCP/MCSD, has worked for Pope & Talbot, Inc., in Portland, Oregon, since 2001 as Senior Programmer/Analyst; prior to that, he worked for Psion Teklogix International, Inc., in the same capacity. He received his B.S. in Physics of Metals from Polytechnic Institute of Belarus in 1988, discovered PC programming in 1992, and has never looked back since. He is also the author of Microsoft SQL Server 2000 Weekend Crash Course (Wiley, 2001).

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.

FROM THE PUBLISHER