Critical.
Authoritative.
Strategic.
Subscribe to CIO Magazine »

SQL Bible

  • 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


Biography

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.

Table of Contents

Preface.

Acknowledgments.

PART I: SQL Basic Concepts and Principles.

Chapter 1: SQL and Relational Database Management Systems (RDBMS).

Chapter 2: Fundamental SQL Concepts and Principles.

Chapter 3: SQL Data Types.

PART II: Creating and Modifying Database Objects.

Chapter 4: Creating RDBMS Objects.

Chapter 5: Altering and Destroying RDBMS Objects.

PART III: Data Manipulation and Transaction Control.

Chapter 6: Data Manipulation Language (DML).

Chapter 7: Sessions, Transactions, and Locks.

PART IV: Retrieving and Transforming Data.

Chapter 8: Understanding SELECT Statement.

Chapter 9: Multitable Queries.

Chapter 10: SQL Functions.

Chapter 11: SQL Operators.

PART V: Implementing Security Using System Catalogs.

Chapter 12: SQL and RDBMS Security.

Chapter 13: The System Catalog and INFORMATION_SCHEMA.

PART VI: Beyond SQL: Procedural Programming and Database Access Mechanisms.

Chapter 14: Stored Procedures, Triggers, and User-Defined Functions.

Chapter 15: Dynamic and Embedded SQL Overview.

Chapter 16: SQL API.

Chapter 17: New Developments: XML, OLAP, and Objects.

Appendix A: What’s on the CD-ROM.

Appendix B: The ACME Sample Database.

Appendix C: Basics of Relational Database Design.

Appendix D: Installing RDBMS Software.

Appendix E: Accessing RDBMS.

Appendix F: Installing the ACME Database.

Appendix G: SQL Functions.

Appendix H: SQL Syntax Reference.

Appendix I: SQL-Reserved Keywords.

Appendix J: SQL99 Major Features Compliance Across Different RDBMS.

Appendix K: The Other RDBMS.

Appendix L: A Brief Introduction to the Number Systems, Boolean Algebra, and Set Theory.

Index.

End-User License Agreement.

rhs_login_lockGet exclusive access to Invitation only events CIO, reports & analysis.
Recent comments