It's the first SQL book I picked up, but be warned, it is for at least intermediate level users. So by the time I reached Chapter 3, I gave up and bought Ben-Gan's Fundamentals of T-SQL first (which I recommend going through before this book if you are a beginner).
If you are using T-SQL, I think Ben-Gan's book is a perfect intro to this one. However, this is the book that takes you to another level. This is the book that enables you to find solutions that others won't be able to. This is the book that makes you a player at work if you aren't a developer and you write SQL. There are no functions, triggers, optimization, table and view creation details. This book is about pulling whatever you want with those things already created (although there is a chapter on metadata and another on inserting/updating). So it isn't for everyone (Developers and Beginners especially).
Also, the book's date may scare people. I mean, the book could use an update as it is working with SQL Server 2005 (if you write T-SQL like I do). Based on the date, I'm sure the editions of the other platforms are outdated as well. With SQL Server 2005 capabilities though, you still get Window Functions, Pivots, string extraction, cast, convert, etc., and some of the Oracle functions not in SQL Server 2005 are a part of T-SQL in later editions, so at times, you can use the Oracle solution or pieces of it if you are using the latest edition of SQL Server (if you need to use lead and lag for example). The important functions that still exist are there for the most part (Concat for example, is not).
Most people know how to use partitioning, cases, and subqueries, but can they cast an integer as a string to cast it again into decimal, average that decimal using a case statement that filters out negative values and partition the average as a window function based on multiple criteria all in one line? This book turns you into a magician, and it is all hands on examples, no filler, no lengthy unneeded explanations. Learn by doing.
Add Prime
to get Fast, Free delivery
Download the free Kindle app and start reading Kindle books instantly on your smartphone, tablet, or computer - no Kindle device required.
Read instantly on your browser with Kindle for Web.
Using your mobile phone camera - scan the code below and download the Kindle app.
There is a newer edition of this item:
Frequently bought together
This item: SQL Cookbook: Query Solutions and Techniques for Database Developers
$29.56
Get it as soon as Friday, May 2
Only 1 left in stock - order soon.
+
$36.49
Get it as soon as Wednesday, Apr 30
In Stock
+
$22.00
Get it as soon as Wednesday, Apr 30
Only 1 left in stock - order soon.
Total price: $00
To see our price, add these items to your cart.
Choose items to buy together.
Customers who viewed this item also viewed
Page 1 of 1 Start overPage 1 of 1
From the brand
-
Sharing the knowledge of experts
O'Reilly's mission is to change the world by sharing the knowledge of innovators. For over 40 years, we've inspired companies and individuals to do new things (and do them better) by providing the skills and understanding that are necessary for success.
Our customers are hungry to build the innovations that propel the world forward. And we help them do just that.
-
Your partner in learning
-
Bestsellers
-
Software Development
-
Programming Languages
-
AI / Machine Learning
-
Data Science
-
Data, Databases and more
-
Cloud Services
-
Business
-
Finance
-
Blockchain / Cryptocurrency
-
Security
-
Cookbooks
-
Head First series
-
97 Things series
-
Lean series
About the author
Top reviews from the United States
There was a problem filtering reviews. Please reload the page.
- Reviewed in the United States on August 12, 2017
- Reviewed in the United States on September 23, 2015
- Reviewed in the United States on December 15, 2011
Top reviews from other countries
-
-
- jorge marcanoReviewed in Canada on January 7, 2021
Product on excelente conditions
