Enter your mobile number below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

SQL Demystified 1st Edition

4.2 out of 5 stars 6 customer reviews
ISBN-13: 978-0072262247
ISBN-10: 0072262249
Why is ISBN important?
ISBN
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Have one to sell? Sell on Amazon
Buy used On clicking this link, a new layer will be open
$10.99 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$19.51 On clicking this link, a new layer will be open
More Buying Choices
43 New from $8.51 49 Used from $2.67
Free Two-Day Shipping for College Students with Prime Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student


Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$19.51 FREE Shipping on orders with at least $25 of books. Only 1 left in stock (more on the way). Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • SQL Demystified
  • +
  • Databases DeMYSTiFieD, 2nd Edition
Total price: $37.75
Buy the selected items together

Editorial Reviews

From the Back Cover

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

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

New York Times best sellers
Browse the New York Times best sellers in popular categories like Fiction, Nonfiction, Picture Books and more. See more

Product Details

  • Series: Demystified
  • Paperback: 312 pages
  • Publisher: McGraw-Hill Education; 1 edition (November 15, 2005)
  • Language: English
  • ISBN-10: 0072262249
  • ISBN-13: 978-0072262247
  • Product Dimensions: 7.2 x 0.7 x 9.1 inches
  • Shipping Weight: 1.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.2 out of 5 stars  See all reviews (6 customer reviews)
  • Amazon Best Sellers Rank: #415,184 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Thomas Duff HALL OF FAMEVINE VOICE on January 14, 2006
Format: Paperback
There is obviously no lack of titles on the subject of SQL. The main choice you have to make is whether you want a conversational or traditional style approach to your learning. Personally, I'm more into conversational, and I had the chance to review a book along those lines... SQL DeMystified by Andy Oppel.

Contents: 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 DCL; Preserving Database Integrity Using Transactions; Integrating SQL into Applications; SQL Performance and Tuning Considerations; Final Exam; Answers to Quizzes and Final Exam; Index

The DeMystified series takes the approach of cutting through jargon and theoretical prose, and goes straight to the core concepts without all the trappings. As a result, I find it much easier to learn what I need to know, as well as how I can apply it immediately. Oppel uses the example of a film library database to take the reader through database concepts, normalization processes, and how the data can be manipulated within a relational database environment using SQL. Once you finish with the book, you will know everything in the way of base concepts. Your learning is also reinforced with a series of quizzes at the end. A nice way to measure your progress. Another positive is that the material is vendor-neutral, so you don't need to worry about whether you have the right software or not. Any relational database system will use these same concepts and processes. The author does point out areas in which certain vendor packages have differed in their implementation, so any large landmines you might encounter can be avoided.

It would be hard *not* to learn what you need to know from this book. As a result, you wouldn't go wrong with this choice for your SQL education.
Comment 20 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By A Mates on December 21, 2012
Format: Paperback Verified Purchase
My goal in checking this book out from the library was to gain enough familiarity with SQL to set up a database for my qualitative data. I am a conversation analyst and had previously been handling my data on index cards. This clearly does not scale to larger data sets.

With this book and a programmer husband to bounce ideas off of, I was able to create a database and set up queries that helped me better see patterns in my data.

This book has helped me get a toe hold in a skill set that will really help me professionally. That's impressive to me.

My background with programming includes only one high school class in BASIC. The book truly demystified relational databases for me. I got this book and Databases Demystified because I wanted to have them on hand as reference materials.
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
By martinez on December 20, 2012
Format: Paperback Verified Purchase
had only some time to check it out, appears to be good, Amazon, the only thing is packaging. books were practically out of packet, someone must have opened it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

SQL Demystified
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: SQL Demystified

What Other Items Do Customers Buy After Viewing This Item?