Synopses & Reviews
Theres 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.
This easy-to-follow guide 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. The book also covers Data Query Language (DQL), Data Manipulation Language(DML), and Data Control Language (DCL), as well as performance tuning.
About the Author
Andy Oppel (Alameda, CA) has designed and implemented hundreds of databases for a wide range of applications, including medical research, banking, insurance, apparel manufacturing, telecommunications, wireless communications, and human resources. He is the author of Databases Demystified (McGraw-Hill/Osborne, 2004). His database product experience includes IMS, DB2, Sybase, Microsoft SQL Server, Microsoft Access, MySQL, and Oracle (versions 7, 8, 8i, and 9i).
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
ANSWERS TO QUIZZES AND FINAL EXAM