- 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.3 x 0.6 x 9.1 inches
- Shipping Weight: 1.2 pounds (View shipping rates and policies)
- Average Customer Review: 6 customer reviews
- Amazon Best Sellers Rank: #1,090,179 in Books (See Top 100 in Books)
Enter your mobile number or email address 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.
To get the free app, enter your mobile phone number.
SQL Demystified 1st Edition
Use the Amazon App to scan ISBNs and compare prices.
"Enlightenment Now: The Case for Reason, Science, Humanism, and Progress"
Is the world really falling apart? Is the ideal of progress obsolete? Cognitive scientist and public intellectual Steven Pinker urges us to step back from the gory headlines and prophecies of doom, and instead, follow the data: In seventy-five jaw-dropping graphs, Pinker shows that life, health, prosperity, safety, peace, knowledge, and happiness are on the rise. Learn more
Frequently bought together
Customers who bought this item also bought
Customers who viewed this item also viewed
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).
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
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.
The database model is extensive, and it would take considerable time to replicate the database. This is time that I am not learning about SQL, which is why I started the book in the first place. He gives a link to the publishers website to download the SQL code to do his exercises, but the database is not there.
Readers expect that learning SQL requires a a sample database, and that database should be included with the book. That the database is not provided, and is not downloadable, is unacceptable.
There are MANY other choices where the databases are included with the book. I have abandoned "SQL Demystified" and will start over with another book that doesn't expect the database to be re-created.