SQL Bible
by Alex Kriegel and Boris M. Trukhnov
Table of Contents
SQL Bible
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
Part VII - Appendix
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
0 comments:
Post a Comment