SQL Demystified

Name: SQL Demystified
Price: 4.91 USD
Availability: InStock
ISBN: 9780072262247

ISBN-10: 0072262249

ISBN-13: 9780072262247

Edition: 2006

Authors: Andrew Oppel

List price: $30.00

30 day, 100% satisfaction guarantee!

Buy new: $19.63

Marketplace

5 new & used from $4.91

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

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.

Book details

List price: $30.00
Copyright year: 2006
Publisher: McGraw-Hill Education
Publication date: 11/15/2005
Binding: Paperback
Pages: 312
Size: 7.20" wide x 9.10" long x 0.69" tall
Weight: 1.012
Language: English

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").




Relational Database Concepts



SQL Concepts



Defining Database Objects Using SQL



Retrieving Data Using Data Query Language (DQL)



Combining Data From Multiple Tables



Advanced Query Writing



Maintaining Data Using DML



Applying Security Controls Using Data DCL



Preserving Database Integrity Using Transactions



Integrating SQL into Applications



SQL Performance Tuning Considerations


Final Exam Answers to Quizzes and Final Exam


Index