Overview
Main 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.
Table of contents
Chapter 1: Relational Database ConceptsChapter 2: SQL ConceptsChapter 3: Defining Database Objects Using SQLChapter 4: Retrieving Data Using Data Query Language (DQL)Chapter 5: Combining Data From Multiple TablesChapter 6: Advanced Query WritingChapter 7: Maintaining Data Using DMLChapter 8: Applying Security Controls Using Data DCLChapter 9: Preserving Database Integrity Using TransactionsChapter 10: Integrating SQL into ApplicationsChapter 11: SQL Performance Tuning ConsiderationsFINAL EXAMANSWERS TO QUIZZES AND FINAL EXAMINDEX
Author comments
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).
Back cover copy
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
