Wiley SQL Bible 2nd Edition

Get the very most out of SQL with the SQL Bible 2nd Edition. Combining theory with everyday practicality, this definitive volume is packed with up-to-date information, new features, and explanations. The book is unique in that every chapter highlights how the 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. Learn the basics of SQL and relational databases Explore tables, views, sequences, and other database objects Examine transactions and locking in multiuser environments Review functions mandated by the SQL standard and the three major vendors Access metadata information and implement database security Go beyond SQL to XML integration, OLAP business intelligence, and more SQL and Relational Database Management Systems Fundamental SQL Concepts and Principles SQL Data Types Creating RDBMS Objects Altering and Destroying RDBMS Objects Data Manipulation Language (DML) Sessions, Transactions, and Locks Understanding the SELECT Statement Multitable Queries SQL Functions SQL Operators SQL and RDBMS Security The System Catalog and INFORMATION SCHEMA 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