SQL Server 2008 Books

 Location:  Home » All SQL Server 2008 Books » SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2  
List by Topic
All SQL Server 2008 Books
Integration Services (SSIS)
Reporting Services
Analysis Services
Data Warehouse
Spatial Data
SQL Server Software
Subcategories
Paperback
Mass Market
Trade
Related Categories
• MOD Booksurge Books
Specialty Stores
Books
• Textbook Buyback
Specialty Stores
Books
• SQL Server
Development
Microsoft
Computers & Internet
Subjects
• General
Languages & Tools
Programming
Computers & Internet
Subjects
• Paperback
Binding (binding)
Refinements
Books
• Printed Books
Format (feature_browse-bin)
Refinements
Books

SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2

SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2Author: Rick A Morelan
Creators: Tom Ekberg, Jessica Brown, Irina Berger
Publisher: BookSurge Publishing
Category: Book

List Price: $35.00
Buy New: $27.76
as of 7/30/2010 02:06 CDT details
You Save: $7.24 (21%)



Seller: Amazon.com
Rating: 5.0 out of 5 stars 5 reviews
Sales Rank: 203923

Media: Paperback
Pages: 518
Shipping Weight (lbs): 2.4
Dimensions (in): 9.9 x 6.9 x 1.3

ISBN: 1439253188
Dewey Decimal Number: 005
EAN: 9781439253182
ASIN: 1439253188

Publication Date: December 9, 2009
Shipping: Eligible for FREE Super Saver Shipping
Availability: Usually ships in 24 hours

Also Available In:

  • Kindle Edition - SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2

Similar Items:


Editorial Reviews:

Product Description
Do you know most of the SQL basics and now want to become that go-to person for those intricate query questions? Once you know the basics of the SQL language, it?s time to take the next step toward specialization: query writing! All objects in SQL support the need to get data in and out of databases, and writing queries is the key to capturing the data you want. ?SQL Queries Joes 2 Pros? shows you a proven roadmap that has helped many beginning SQL students get their certifications and launch their careers. If you want to get ready for MCTS certification, this is the second book of the Joes 2 Pros series. This book is totally focused on providing a fun, hands-on experience as it evolves your basic SQL skills and amps up your level of query writing expertise. This is Volume II of the Joes 2 Pros certification track designed to prepare you for the 70-433 SQL 2008 exam. If you are a total beginner, we recommend you first become familiar with the material in the ?Beginning SQL Joes 2 Pros.?


Customer Reviews:
5 out of 5 stars Complete your T-SQL learning experience!   July 2, 2010
Timothy Bochard (Poway, CA USA)
1 out of 1 found this review helpful

This book picks up where the first book left off. The first book takes a measured approach to the basic syntax of T-SQL DDL, DML, DCL, and TCL. The first chapter in book 2 reviews what was covered in book 1, and then continues on more advanced topics. The same thoughtful, easy-to-read and practical approach to learning is used. You won't find better T-SQL training anywhere. So, whether you are learning the language for the first time, a pro who is just "brushing up" for an interview, or just need a ready reference, this two book series is a "must" for your bookshelf.


5 out of 5 stars In All That Getting get An Understanding   May 31, 2010
S. Manley
3 out of 3 found this review helpful

Hello, I want to recommend Rick Morelan's Joes 2 Pros teaching aids as a must have in your quest to learn Microsoft SQL server 2008. I am currently a student In a 12 to 36 week Intensive program that teaches business intelligence. Learning SQL in a Microsoft environment is my goal and purpose but the instruction leaves me void of a complete understanding. The pace of the course; as you may already know is extremely fast; this is because most of these programs are set up just to make money off the BI and IT boom and If you are a novice or an enthusiast wanting to learn SQL you'll get swallowed up as the course progress through topics such as recursive queries, pivots, CTE, and the various joins: leaving you confused and frustrated.

Nevertheless, after failing several test in my BI course and after wanting to throw in the towel; I was up late one night contemplating about my next steps and I discovered Rick's Joes2Pros videos on YouTube; they were so clear and concise I knew then that I had to have them If I wanted to be successful in my course; that I already paid 19,000 thousand dollars for. I purchase Rick's DVD's and every one of his teaching aids I found on Amazon and I can tell you that this was the best move I made. If I knew any better I would not have taken the 19,000 Bi classes to learn SQL I would have just purchased Rick's books which are excellent teaching aids that cater to your overall understand of SQL server 2008 in a Microsoft environment. I have been help immensely I now understand joins and other concept that I had trouble with in my BI course which I now have learned from the Joes2Pros teaching aids; I know you would agree ;if you to made Joes2Pros the center piece of you SQL server collection.



5 out of 5 stars A great buy for learning SQL and SQL Querying   April 8, 2010
A. Miklos (Lake Stevens, WA USA)
1 out of 1 found this review helpful

I have taken several SQL classes and looked up tutorials online. Most left me confused and less than satisfied. This book and the previous volume filled the void. They teach at the appropriate pace with easy to understand examples and exercises. Without it, I would have struggled needlessly in my classes. I highly recommend this book for anyone who is a beginner and wants or needs to have a good understanding of SQL. SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008, Volume 2


5 out of 5 stars Makes Writing SQL Queries A Pleasure   February 26, 2010
Ranjita Dogra (Seattle, WA)
3 out of 3 found this review helpful

After reading the first book of the series, I was inspired to enhance the skills that I had just learnt, which made me dive right into the second book. This book teaches you to write complex queries in a step-by-step process. The diagrams help you visualize how the queries work. There are plenty of great hands-on skill checks and well thought of review tests. The bug catcher is a lot of fun!! I am amazed at how confident I am now in writing intricate queries that I never imagined I would be capable of, prior to reading this book. I am determined now to read all five volumes of series. Waiting for the rest of the books in the series to come out...


5 out of 5 stars Quality Continued   January 21, 2010
Mary E. Knowles (Bonney Lake, WA)
6 out of 6 found this review helpful

I've been waiting for this second book to come out and now will continue to look for the rest of the series. What I really appreciate about this series is the easy to follow tutorials that don't confuse things with too much tech dialogue like I've seen in other books. Step by step guidance to understanding the premise of creating specific code and its application. The Points to Ponder enforce the rules surrounding the premise (also fabulous quick reference material). The teaching technique is simply great in this series. It truly speaks on a user friendly level. This is the only way to not only learn SQL, but to prepare for Microsoft Certification, since this series specifically uses that goal as a basic principle.

CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME.
Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com