CITATION

Oppel, Andrew. SQL Demystified. US: McGraw-Hill Osborne Media, 2005.

SQL Demystified

Authors:

Published:  October 2005

eISBN: 9780071486729 0071486720 | ISBN: 9780072262247

Book 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.

The fast and easy way to learn SQL

Start programming in SQL right away using this easy-to-follow guide. SQL Demystified explains how to write and run database queries with SQL. Step-by-step instructions with lots of examples help you learn quickly.

The book begins by introducing you to relational database concepts. Then, you’ll learn to define database objects, retrieve data using the Data Query Language (DQL), maintain data using the Data Manipulation Language (DML), apply security controls using the Data Control Language (DCL), preserve database integrity, integrate SQL into applications, tune SQL statements, and more. Featuring end-of-chapter quizzes and a final exam, this book will have you programming in SQL in no time.

Simple enough for a beginner, but challenging enough for an advanced student, SQL Demystified is your shortcut to mastering this powerful programming language.

This one-of-a-kind, self-teaching text offers:

  • An easy way to understand SQL

  • A quiz at the end of each chapter

  • A final exam at the end of the book

  • No unnecessary technical jargon

  • A time-saving approach

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, 8

i

, and 9

i

).

Keywords: 0-07-226171-4