SQL Bible
1st Edition
Published on 18. April 2003
Book
Paperback/Softback
864 pages
978-0-7645-2584-1 (ISBN)
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
More details
Series
Edition
1., Auflage
Language
English
Place of publication
Foster City
United States
Publishing group
John Wiley & Sons Inc
Target group
Professional and scholarly
Illustrations
Illustrations
Dimensions
Height: 23.4 cm
Width: 18.8 cm
Weight
1279 gr
ISBN-13
978-0-7645-2584-1 (9780764525841)
Schweitzer Classification
Other editions
New editions
Alex Kriegel | Boris M. Trukhnov
SQL Bible
Book
04/2008
2nd Edition
Wiley
€56.00
Shipment within 10-20 days
Persons
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.
Content
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.