Training Kit : Querying Microsoft SQL Server 2012 Author: Itzik Ben-Gan | Language: English | ISBN:
0735666059 | Format: PDF
Training Kit : Querying Microsoft SQL Server 2012 Description
Ace your preparation for Microsoft® Certification Exam 70-461 with this 2-in-1 Training Kit from Microsoft Press®. Work at your own pace through a series of lessons and practical exercises, and then assess your skills with practice tests on CD—featuring multiple, customizable testing options.
Maximize your performance on the exam by learning how to:
- Create database objects
- Work with data
- Modify data
- Troubleshoot and optimize queries
You also get an exam discount voucher—making this book an exceptional value and a great career investment.
- Paperback: 752 pages
- Publisher: Microsoft Press; 1 edition (December 12, 2012)
- Language: English
- ISBN-10: 0735666059
- ISBN-13: 978-0735666054
- Product Dimensions: 9 x 7.4 x 1.4 inches
- Shipping Weight: 2.6 pounds (View shipping rates and policies)
1st, a small disclaimer...
At the time of this review, 12/13/12 I have not finished reading or studying this book yet; as a matter of fact, I challenge any person or reviewer saying he or she has finished the book, as frankly speaking would be difficult or impossible to believe. However, I decided to jump ahead and give my honest review from what I've read so far. I have no business relationship with any of the authors whatsoever.
Having said that, I like this book so far. It is way, way better than its previous version. It goes more in-depth and gives a more holistic approach to T-SQL. I'll explain that in a few.
So far, i've read: Chapter 1, which is an intro to what set theory is. Chapter 2, which is about SELECT statements. Chapter 15, which is about Indexes and Chapter 17, which is about optimization. All those cover the basics and more about what you need for your day to day job and to fully understand T-SQL and their proper usage. The Index and Optimization chapters have plenty of illustrations and the concepts are exposed in a clear but concise manner.
Each chapter, as the typical MS cert books, has questions an answers but there are also lot of labs with exercises and T-SQL queries to play with. You only need a SQL2012 instance (any flavor) to practice.
I consider this book a hybrid between Itzik's bestseller, T-SQL fundamentals and previous SQL query book from Microsoft. This new version keeps its simplicity while going more in detail and giving a non proprietary and holistic approach to what T-SQL is or should be.
I've been reading Itzik's books for several years now and he has improved his writing skills a lot.
I've been using SQL Server at work for a couple of years now, but I'm not a DBA; I mostly just run simple queries to test that data was loaded correctly by our ETL process. This year I'm leading a small group of coworkers who want to become more proficient in SQL Server, so we're studying for the MCSA in SQL Server 2012. This certification requires passing exams in three areas; the material on the first exam, 70-461, is the subject of this book.
The book starts out with the obligatory disclaimers: real-world experience is required to pass the exam, and you should already understand how to write a query and run it, even if you don't know the fine details. Naturally, you'll need a copy of SQL Server 2012 (a trial copy is fine). The book comes with a CD containing practice tests, an PDF of the text, and a copy of the scripts (which can also be downloaded from O'Reilly). Finally, the book includes a coupon code for 15% off any Microsoft Certified Professional Program exam; the tests normally run $150, so that's probably a $22.50 savings if you plan to take the exam.
Before getting into the code, we start off with Chapter 1: Foundations of Querying, where we learn a little about set theory and the difference between standard SQL and Microsoft's T-SQL. (Incidentally, if you're trying to do a search for how to do something in SQL Server and want to avoid getting results from other flavors of SQL, searching in T-SQL is a good way to do it.) Chapter two brings in some code: the select statement. At this point, you'll need to have installed the TSQL2012 database (which, as mentioned, is a free download). With the basics down, chapters three through seven discuss various ways of querying and managing the data, including filtering, sorting, combining, and grouping.
Training Kit : Querying Microsoft SQL Server 2012 Preview
Link
Please Wait...