Loading...

SQL demystified /

Bibliographic Details
Main Author: Oppel, Andy
Published: New York : McGraw-Hill/Osborne c2005.
Subjects:
Table of Contents:
  • Ch. 1. Relational database concepts
  • Ch. 2. SQL concepts
  • Ch. 3. Defining database objects using SQL
  • Ch. 4. Retrieving data using data query language (DQL)
  • Ch. 5. Combining data from multiple tables
  • Ch. 6. Advanced query writing
  • Ch. 7. Maintaining data using DML
  • Ch. 8. Applying security controls using DCL
  • Ch. 9. Preserving database integrity using transactions
  • Ch. 10. Integrating SQL into applications
  • Ch. 11. SQL performance and tuning considerations.
  • Relational database concepts
  • SQL concepts
  • Defining database objects using SQL
  • Retrieving data using query language (DQL)
  • Combining data from multiple tables
  • Advanced query writing
  • Maintaining data using DML
  • Applying security controls using DCL
  • Preserving database integrity using transactions
  • Integrating SQL into applications
  • SQL performance and tuning considerations.