• Author:
  • Kriegel, Alex
  • Trukhnov, Boris M.
• Subject:
  Computer Programming / Software Development
• Published by:
  John Wiley & Sons Inc (US)
• Published:
  04/04/2003
• Price:
  $74.99
• <  Buy this book  >

• 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
  
  
  

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.

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.