Learning SQL: Master SQL Fundamentals 2nd Edition

by Alan Beaulieu (Author)

61 customer reviews

Reference

ISBN-13: 978-0596520830

ISBN-10: 0596520832

Why is ISBN important?

Have one to sell? Sell on Amazon

Share <Embed>

Buy new

$24.21

In Stock.

Ships from and sold by Amazon.com. Gift-wrap available.

List Price: $39.99 Save: $15.78 (39%)

19 New from $23.74

FREE Shipping on orders over $25—or get FREE Two-Day Shipping with Amazon Prime

Turn on 1-Click ordering

More Buying Choices

19 New from $23.74 36 Used from $7.59

55 used & new from $7.59

See All Buying Options

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Updated for the latest database management systems -- including MySQL 6.0, Oracle 11g, and Microsoft's SQL Server 2008 -- this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations and annotated examples. Exercises at the end of each chapter let you practice the skills you learn. With this book, you will:

Move quickly through SQL basics and learn several advanced features
Use SQL data statements to generate, manipulate, and retrieve data
Create database objects, such as tables, indexes, and constraints, using SQL schema statements
Learn how data sets interact with queries, and understand the importance of subqueries
Convert and manipulate data with SQL's built-in functions, and use conditional logic in data statements

Knowledge of SQL is a must for interacting with data. With Learning SQL, you'll quickly learn how to put the power and flexibility of this language to work.

Related materials

Page 1 of 1Start OverPage 1 of 1

Related Text

SQL Pocket Guide: A Guide to SQL Usage

ISBN-13: 978-1449394097

$11.55

Frequently bought together

Total price: $69.14

Buy the selected items together

This item:Learning SQL: Master SQL Fundamentals by Alan Beaulieu Paperback $24.21
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping on orders over $25. Details
SQL Cookbook: Query Solutions and Techniques for Database Developers (Cookbooks (O'Reilly)) by Anthony Molinaro Paperback $33.38
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping. Details
SQL Pocket Guide: A Guide to SQL Usage by Jonathan Gennick Paperback $11.55
In Stock.
Ships from and sold by Amazon.com.
FREE Shipping on orders over $25. Details

Customers who bought this item also bought

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Anthony Molinaro

102

Paperback
$33.38
Jonathan Gennick

51

Paperback
$11.55
David Herman

82

Paperback
$29.27
Andy Oppel

32

Paperback
$15.91
Ben Forta

484

in SQL
Paperback
$19.88
Michael J. Hernandez

175

Paperback
$30.47

Customers who viewed this item also viewed

Page 1 of 1 Start overPage 1 of 1

This shopping feature will continue to load items. In order to navigate out of this carousel please use your heading shortcut key to navigate to the next or previous heading.

Ben Forta

484

in SQL
Paperback
$19.88
Anthony Molinaro

102

Paperback
$33.38
Inc. BarCharts

91

Pamphlet
$2.68
Jonathan Gennick

51

Paperback
$11.55
Thomas Nield

10

Paperback
$28.33
John L. Viescas

153

Paperback
$35.78

Editorial Reviews

About the Author

Alan Beaulieu has been designing, building, and implementing custom database applications for over 13 years. He currently runs his own consulting company that specializes in designing Oracle databases and supporting services in the fields of Financial Services and Telecommunications. In building large databases for both OLTP and OLAP environments, Alan utilizes such Oracle features as Parallel Query, Partitioning, and Parallel Server. Alan has a Bachelor of Science degree in Operations Research from the Cornell University School of Engineering. He lives in Massachusetts with his wife and two daughters.

Paperback: 338 pages
Publisher: O'Reilly Media; 2nd edition (April 30, 2009)
Language: English
ISBN-10: 0596520832
ISBN-13: 978-0596520830
Product Dimensions: 7 x 0.9 x 9.2 inches
Shipping Weight: 1 pounds (View shipping rates and policies)
Average Customer Review: 61 customer reviews
Amazon Best Sellers Rank: #20,643 in Books (See Top 100 in Books)
- #1 in Books > Computers & Technology > Databases & Big Data > Other Databases
- #5 in Books > Computers & Technology > Databases & Big Data > Data Warehousing
- #19 in Books > Computers & Technology > Databases & Big Data > Data Modeling & Design

Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?

NO_CONTENT_IN_FEATURE

Start reading Learning SQL: Master SQL Fundamentals instantly on your Kindle Fire or on the free Kindle apps for iPad, Android tablet, PC or Mac. Don't have a free Kindle app? Get yours here

Customer Reviews

Write a customer review

See all 61 customer reviews

Rated by customers interested in

What's this?

Sports Books

3.8 out of 5 stars

Computer Books

4.0 out of 5 stars

Business & Economics Books

3.8 out of 5 stars

Is this feature helpful?

Thank you for your feedback.

Read reviews that mention

Top customer reviews

There was a problem filtering reviews right now. Please try again later.

Michael Tozer

Excellent; Essential

March 27, 2012

Format: PaperbackVerified Purchase

I've just finished my first enjoyable pass through "Learning SQL"; and I must report how delighted I am with this book. To put this in context, I ought to report that I first learned SQL way back in 1984, as part of a project team that was implementing a major relational database with SQL/DS as a first release program product. Coming then from a procedural background, (Fortran and PL/1), I was puzzled at SQL syntax and really the point of view of relational databases. Subsequently, I was trained up in logical data modeling and relational database design. With this, the ideas of relational database and the firm mathematical foundation on which they are built became ultimately second nature to me. Revisiting now the power and expressive nature of the SQL language was for me a both a wonderful trip down memory lane and an affirmation of all that I've learned in terms of design over the many interceding years.

This book is absolutely wonderful and essential in terms of its straightforward, yet challenging, approach. The material is taught to the interested reader in clear and concise chapters. We might even call them "bite size", for they are tasty, in a manner of speaking. And the "test your knowledge" questions at the end of each chapter are truly remarkable. It is a thrill to affirm the knowledge you've just gained in the chapter absorbed through attaining real answers applying the SQL on the sample database. And yet the excercises, particularly in the chapter on sub-queries, are really quite challenging.

We strongly recommend this book to anyone who would gain a mastery of the SQL language. God bless.

Comment One person found this helpful. Was this review helpful to you?

Yes

Gamera

Decent book - Easy to set up example database with MySQL Workbench

June 6, 2014

Format: PaperbackVerified Purchase

This book was recommended by my brother who works with a database expert. This book explains well all the SQL you are likely to be hit with on an interview.
The problems people have with the example database are easy to avoid. I downloaded the full MySQL56 for my Windows laptop. Forget the book and just load it all using the MSI (I downloaded the latest 5.6.19 CE - this will download the Workbench as well. Just follow the directions. I had no problems.
Then, on the Workbench, click on Create New Schema and call it bank. Then, what you REALLY need to do is go to Edit | Preferences | SQL Queries and uncheck the "Safe Queries" checkbox! Their explanation of 'Safe Query' is there. The example database breaks this. Also I set the collation to latin1. Else it will use your computers default (UTF-8 for me). Not sure this matters.
Then go to the authors page and copy the sql. After setting "bank" as the default schema (right click 'bank'), create a new query and paste the author's sql in. Then hit the lightening bolt and watch. The database will be set up and populated correctly with no errors whatsoever. Easy.
The addition of a workbench (very similar to SQL Server's) really makes this simple. I did this also on my Mac Mini. Also easy but you need to download the Workbench separately.

Comment 9 people found this helpful. Was this review helpful to you?

Yes

Amazon Customer

If you want to learn SQL, get, read, and follow along with this book.

March 23, 2017

Format: PaperbackVerified Purchase

Great book! Excellent read, and is intended for instruction. The gotcha's included with the book are great. I'm using it to help some coworkers learn SQL. So far so good!

Comment One person found this helpful. Was this review helpful to you?

Yes

sdb930

Decent book with a somewhat buggy database

December 5, 2013

Format: Kindle EditionVerified Purchase

This is a pretty good book for someone who has some experience with SQL already but is just looking to get a comprehensive overview. My only complain with this book is that the accompanying database that the author asks to download from his website is quite buggy and difficult to install and get working correctly. I got several error of undefined variables etc. which I had to Google for solutions to before I could get the database working to do the practice exercises. I had support from friends and colleagues through this process, but this may be difficult to do on your own if you are new to SQL.

Comment One person found this helpful. Was this review helpful to you?

Yes

Keith LaBorde

Print Text to Small, Explanations could be better.

September 25, 2017

Format: PaperbackVerified Purchase

I purchased Learning SQL, and then I found Head First SQL to be much better. I bought it, I own it, but will probably use Head First SQL way more. This is the book has clearer explanations on the topic.

CommentWas this review helpful to you?

Yes

jaramill

More towards MySQL than Oracle

May 3, 2014

Format: PaperbackVerified Purchase

Though SQL is SQL, and Alan's reasoning for using MySQL as the database made sense, I was disappointed at that since I was expecting it to be based on Oracle. But the title is Learning "SQL" so it still is a good book. Just pointing it out to potential buyers that the examples are based on MySQL. The majority of SQL should work well in Oracle but make sure before you buy the book.

CommentWas this review helpful to you?

Yes

Rene C. Borbon

An excellent step by step guide to learning SQL

January 28, 2012

Format: PaperbackVerified Purchase

I bought this book a few months back realizing I need practice actually working with SQL, rather than just reading about it. The great thing about this book is it helps you install a MySQL bank database on your computer. That took a bit of work to get done correctly. The step by step description of the SQL queries and the accompanying examples of results makes for a nice series of labs to get one familiar with the syntax of the language. I've made it through about 100 pages of the book so far and I've found the lessons challenging and instructive. The author gives you enough information, but not too much. I recommend this book.

Comment 2 people found this helpful. Was this review helpful to you?

Yes

Anoop Mohan

Excellent place to start learning SQL.

September 2, 2016

Format: PaperbackVerified Purchase

This book is focussed on MySQL and focus on basis of SQL. It helps in establishing the database and system. Though they had recommended to use CMD to run the SQL's I found it much easier to achieve the same through MySQL Workbench. I would recommend the book to anyone who wants to get introduced to SQL.

CommentWas this review helpful to you?

Yes

Most recent customer reviews

Timothy Wong

One Star

For some reason the book starts on page 47????

Published 4 months ago

Varfee Sirleaf

One Star

i done this order. i need to cancel it. please understand.

Published 4 months ago

Amazon Customer

Five Stars

Great detailed book, covers just everything needed to start querying RDBMS. recommended!

Published 5 months ago

Daniel G

Five Stars

Item as described and fast shipping.

Published 6 months ago

Jones

Good book for MySQL

This is for learning MySQL. I was looking for an Oracle SQL book so I should have read the inside cover before buying it. It's not a bad book, just not what I was looking for.

Published 11 months ago

Fantastic intrduction to SQL

Fantastic intrduction to SQL. Focuses on the core concepts and offers alternatives for the different SQL solutions which is a nice bonus.

Published 1 year ago

BigE

Good educational book

Good book for the beginner

Published 1 year ago

Marcus Baucmann

Four Stars

Pretty good, but not inspirational.

Published 1 year ago

Amazon Customer

Two Stars

sucked super hard, not even relevant anymore

Published 1 year ago

Set up an Amazon Giveaway

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: Learning SQL: Master SQL Fundamentals

Set up a giveaway