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.
Synopsis
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 FINAL EXAM ANSWERS TO QUIZZES AND FINAL EXAM INDEX