- Paperback: 338 pages
- Publisher: O'Reilly Media; 2nd edition (April 30, 2009)
- Language: English
- ISBN-10: 9780596520830
- ISBN-13: 978-0596520830
- ASIN: 0596520832
- Product Dimensions: 7 x 0.9 x 9.2 inches
- Shipping Weight: 1 pounds (View shipping rates and policies)
- Average Customer Review: 68 customer reviews
- Amazon Best Sellers Rank: #82,977 in Books (See Top 100 in Books)
Learning SQL: Master SQL Fundamentals 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
Fulfillment by Amazon (FBA) is a service we offer sellers that lets them store their products in Amazon's fulfillment centers, and we directly pack, ship, and provide customer service for these products. Something we hope you'll especially enjoy: FBA items qualify for FREE Shipping and Amazon Prime.
If you're a seller, Fulfillment by Amazon can help you grow your business. Learn more about the program.
There is a newer edition of this item:
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.
Frequently bought together
Customers who viewed this item also viewed
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.
Review this product
68 customer reviews
There was a problem filtering reviews right now. Please try again later.
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.
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.