Learning SQL Paperback – 30 Apr 2009
|New from||Used from|
- Choose from over 13,000 locations across the UK
- Prime members get unlimited deliveries at no additional cost
- Find your preferred location and add it to your address book
- Dispatch to this address when you check out
Frequently bought together
Customers who bought this item also bought
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.
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?
Master SQL Fundamentals
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 and can be reached at email@example.com.
What other items do customers buy after viewing this item?
Top customer reviews
I have experience of working with databases and have found the book so far to be a good introduction to SQL - I don't think it would necessarily be a good introduction to databases, so if you're new to SQL and database administration, you may want to look elsewhere or purchase an introductory text to databases to complement this book.
To really get the most out of this book you need to use the online resources and complete the tests at the end of each chapter - which is where the book is let down. All the effort of making the text easy to read and follow is ruined by the mismatch between the examples in the book and the data supplied on the O'Reilly site.
There are positives and negatives to this - a huge negative is that for a while I thought I was getting things wrong, and repeatedly doubting myself and my ability to learn SQL. A positive on the other hand is that it makes you look at the database structure and raw data to see why you can't get the answer that the book suggests is possible. After much investigation, I discovered the data populated via the online SQL file doesn't match to the data being used by the author.
After a while this just becomes annoying, especially when you try to complete the tests and can't get the correct answers. You then have to either populate the data (good practice I suppose) or modify your query to get a different answer, using the same approach.
The book would get five stars if it wasn't for the problems mentioned above.
Delivery etc, excellent as always from Amazon.
When I started reading further in, it became obvious that all the examples are for MySQL not SQL. He does suggest that readers download MySQL and run the examples that way. But I cannot really see the point of that because many MySQL functions and commands do not work in MS SQL.
I guess it was my fault for not thumbing through the "Look Inside" facility. That'll teach me!
By the way, the author also insists that SQL does NOT stand for "Structured Query Language" (!) but fails to offer any alternative or explanation. 'Nuff said.
It has a nicely written and easy to understand flow with exercises at the end of each chapter. I find this a great help as when you have read the chapter, you can try and solve the exercises and hopefully it will have sunk in more.
The hardest section is on subqueries as it seem that you can put them everywhere(ugggh).
It also explains the nuances with SQL Server and Oracle, as the syntax changes for little things like altering tables and transaction.
So in all a very good book that will prove a useful reference and tool for improving ones knowledge of SQL.
The book is well written and has some good examples to follow; However, with the downloaded datasets differing from the examples in the book, some additional braincells are required to actually get the example to work. While this adds to the challenge ( and perhaps the learning experience ), it's really annoying and spoils the flow.
From a beginners POV would prefer the "AS" optional keyword to be used as it makes code easier to read. Experienced users may not have an issue with this, but the book is for novices.
If you are skilled in coding and databases you can probably even just read the book and pick up enough knowledge without actually doing the examples, but you'd miss out much of the fun and point of the book. Typing lines in a DOS box quickly becomes a drag too. Though if you are slick of mind, you quickly figure out how to script commands from Notepad.
Overall, still worth the price and Amazon performance 100% as usual.
Would you like to see more reviews about this item?
Most recent customer reviews
Explains with clarity what each statement is doing.
Really well written.
Look for similar items by category
- Books > Computing & Internet > Computer Science > Information Systems
- Books > Computing & Internet > Databases > Beginners & Introduction
- Books > Computing & Internet > Databases > Data Storage & Management > Data Mining
- Books > Computing & Internet > Databases > Data Storage & Management > Data Warehousing
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > SQL
- Books > Computing & Internet > Programming > Introduction to Programming
- Books > Science & Nature > Engineering & Technology