SQL Demystified
Andrew Oppel · 2005
There’s no easier, faster, or more practical way to learn the really tough subjects SQL Demystified explains how to use SQL (Structured Query Language)--the ubiquitous programming language for databases. Readers will learn to create database objects, add and retrieve data from a database, and modify existing data. This self-teaching guide comes complete with key points, background information, quizzes at the end of each chapter, and even a final exam. Simple enough for beginners but challenging enough for advanced students, this is a lively and entertaining brush-up, introductory text, or classroom supplement. Table of contents Chapter 1: Relational Database Concepts Chapter 2: SQL Concepts Chapter 3: Defining Database Objects Using SQL Chapter 4: Retrieving Data Using Data Query Language (DQL) Chapter 5: Combining Data From Multiple Tables Chapter 6: Advanced Query Writing Chapter 7: Maintaining Data Using DML Chapter 8: Applying Security Controls Using Data DCL Chapter 9: Preserving Database Integrity Using Transactions Chapter 10: Integrating SQL into Applications Chapter 11: SQL Performance Tuning Considerations FINAL EXAM ANSWERS TO QUIZZES AND FINAL EXAM INDEX