Description:

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.

 

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 Data Manipulation Language (DML)
Chapter 8: Applying Security Controls Using Data Control Language (DCL)
Chapter 9: Preserving Database Integrity Using Transactions
Chapter 10: Integrating SQL into Applications
Chapter 11: SQL Performance Tuning Considerations
Appendix A: CREATE TABLE Statements for Book Examples
Appendix B: INSERT Statements for Data in Book Examples
Appendix C: Final Exam
Appendix D: Answers to Quizzes and Final Exam