Auto boutiques-francophones Simple and secure cloud storage giftguide Kitchen Kindle Black Friday Deals Week in Music SGG Countdown to Black Friday in Lawn & Garden
Discovering SQL: A Hands-On Guide for Beginners and over one million other books are available for Amazon Kindle. Learn more
CDN$ 41.99
Only 1 left in stock (more on the way).
Ships from and sold by Gift-wrap available.
Discovering SQL: A Hands-... has been added to your Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Discovering SQL: A Hands-On Guide for Beginners Paperback – Apr 19 2011

See all 4 formats and editions Hide other formats and editions
Amazon Price
New from Used from
Kindle Edition
"Please retry"
Paperback, Apr 19 2011
CDN$ 41.99
CDN$ 21.42 CDN$ 21.29

Black Friday Deals Week in Books

No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your e-mail address or mobile phone number.

Product Details

  • Paperback: 432 pages
  • Publisher: Wrox (April 19 2011)
  • Language: English
  • ISBN-10: 1118002679
  • ISBN-13: 978-1118002674
  • Product Dimensions: 18.8 x 2.2 x 23.6 cm
  • Shipping Weight: 699 g
  • Amazon Bestsellers Rank: #773,590 in Books (See Top 100 in Books)
  •  Would you like to update product info, give feedback on images, or tell us about a lower price?

  • See Complete Table of Contents

Product Description

From the Back Cover

Discover best practices for turning data into information you can use

Structured Query Language, more popularly known as SQL, is a standard database language used to create, access and manipulate data, and store and maintain information in relational databases such as Access®, SQL Server®, Oracle®, and MySQL®. If that's all you know about SQL, then you're already ahead of the curve! Assuming no prior knowledge of SQL or relational databases, author Alex Kriegel takes you on a voyage of discovery as you learn SQL basics and learn to work with data stored in a relational database. Written in a beginner-friendly tone, this guide walks you through the creation of a sample database that incorporates all the SQL concepts taught throughout the book and also introduces data modeling, query tuning, and optimization.

Discovering SQL:

  • Covers the most important SQL dialects along with the current release of SQL Standard

  • Highlights the differences between particular implementations as well as the power and limitations of SQL

  • Demonstrates how SQL deals with all types of data: structured, unstructured and everything in between

  • Looks at dynamic SQL, procedural extensions and latest developments in the field

  • Shares best practices for optimizing query performance

  • Walks you through the basics of database design and introduces the tools for working with normalized data Programmer Forums

Join our Programmer to Programmer forums to ask and answer programming questions about this book, join discussions on the hottest topics in the industry, and connect with fellow programmers from around the world.

Code Downloads

Take advantage of free code samples from this book, as well as code samples from hundreds of other books, all ready to use.

Read More

Find articles, ebooks, sample chapters and tables of contents for hundreds of books, and more reference resources on programming topics that matter to you.

About the Author

Alex Kriegel is an enterprise systems architect for the Oregon Health Authority, State of Oregon. He has more than 20 years of professional database and software development experience and holds numerous certifications, including MCTS, PMP from Project Management Institute, TOGAF 8 Certified Practitioner from The Open Architecture Group, and Certified Scrum Master from Scrum Alliance.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Inside This Book

(Learn More)
Browse Sample Pages
Front Cover | Copyright | Table of Contents | Excerpt | Index | Back Cover
Search inside this book:

Customer Reviews

There are no customer reviews yet on
5 star
4 star
3 star
2 star
1 star

Most Helpful Customer Reviews on (beta) 6 reviews
7 of 8 people found the following review helpful
Coversational and Concise April 14 2011
By Jacob Moran - Published on
Format: Paperback
I've been reviewing this book for use in an educational setting, and I like Alex's conversational but accurate style. He is interested in helping take a student from Point A to Point B without taking too many side trips. The hands-on portion is based on a download of SQL Express and Express Mangement Studio, followed by creating a local database and building it from the ground up. The book makes many references to differences that you might see in Oracle, MySQL, and other non-Microsoft database systems.

There is no supporting CD, but the publisher's web site has the scripts to download that speed up data entry portion of setting up the local database that is used in of the examples. The SQL examples are that of a book publishing scenario that is familiar to many of us from the Sybase and early SQL server days. I'm glad that Alex decided not to use the current Microsoft SQL database of AdventureWorks. AdventureWorks is fully normalized and large enough to evaluate performance differences in queries, but it is just too hard for a novice to understand unless they join together 5 tables for every query!

There is a great deal of practical content in the book, building the process needed for reporting and basic data management, and moves into performance techniques, indexing, and transaction management. The sql examples do not attempt to reference every possible iteration of a sql command. Neither does the book attempt to show how to bring about complicated programmatic action within the database. Some examples maybe difficult to translate to your own environment, as there is usually only one example for a particular type of statement.

The end of the book focuses on high level views of database-related concepts, including XML and future technologies.

All in all, I think Alex Kriegel has done a great job putting together a valuable resource for those who are looking to begin their SQL journey or those who want to see the differences in syntax between different database engines.
5 of 7 people found the following review helpful
Good presentation, but riddled with errors Aug. 14 2011
By eric - Published on
Format: Paperback Verified Purchase
I bought this book for my girlfriend who wanted to learn SQL. The format of the book is an excellent introductory guide to learning sql in a hands on fashion, and it covers the different bits of many databases.

That is about all I can say that is good. The book is so riddled with errors in column and table name references, you basically have to assume that all the SQL is wrong and will give you errors when you try to execute it.


pg.26 you run an alter table statement to add a "book_id" column to the table.

ADD book_id INTEGER;

The book then immediately references the column later on the page as "bk_id" in multiple sql statements!

UPDATE myLibrary SET bk_id=1 WHERE isbn='978-0470229064';

This continues through out the remainder of the book to a point where the author is referring to the myLibrary table as "books" and has prefixed all columns with bk_ while in previous examples there were no column name prefixes.

For a book that is meant to introduce people to SQL it is unacceptable to have so many errors in the book, and since it is a hands on guide, in your sql queries. It ends up being really discouraging and frustrating trying to track down whether or not you are wrong or the book is wrong... but you can assume its the book.
1 of 1 people found the following review helpful
Great book for learning SQL July 17 2012
By A. Carter - Published on
Format: Paperback Verified Purchase
This was a required book for a course I was taking on T-SQL and Database Management. Let me say it was very helpful. For someone who was used to creating databases directly through the GUI this helped me to understand the coding that goes into creating a database. If you want a book that will put everything in layman's terms where you can understand, this is the book you want! Its easy to follow along and read. They give an over abundance of examples of everything they discuss in the book. You can follow along and make a database from scratch without using a GUI but coding it directly. If you need a book to get you comfortable with T-SQL and databases try this out along with this Beginning T-SQL with Microsoft SQL Server 2005 and 2008 (Wrox Programmer to Programmer)
A ridiculous book that was NOT reviewed before going to print Oct. 19 2015
By Kelly Belly - Published on
Format: Paperback Verified Purchase
Are you kidding? How much did these guys make off of this book? I am going through all of the book's exercises, and NONE of them are consistent. Instructions are missing, names of fields are mismatched. The code is inconsistent.
Where was the copy editor? I cannot believe that Alex Kriegel is willing to attach his name to this book.
How embarrassing for the author.
0 of 1 people found the following review helpful
errors June 10 2013
By beonewt - Published on
Format: Paperback
let me start off by saying that the book is easy to read and like the title implies it is for complete beginers. that being said, the number of syntax errors and out of order instructions is too damn high to make this book a good learning tool. i constantly have create tables not mentioned until several pages after being asked to edit them. example edit table books page 41, then on page 48 create table books. this book needs some editing.
ps. the book also does not follow its own instructions. it had me change a table name only to go on reffering to the table by its old name