Rating:
Author: Itzik Ben-Gan
ISBN : B00AA36TL6
New from $41.60
Format: PDF, EPUB
Download Free Training Kit : Querying Microsoft SQL Server 2012 for everyone book with Mediafire Link Download Link
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.
A Note Regarding Practice Tests
Assess your skills with practice tests. After purchasing this product, Amazon will e-mail you an Access Code and redemption instructions for this download content. You can work through hundreds of questions using multiple testing modes to meet your specific learning needs. You get detailed explanations for right and wrong answers-- including a customized learning path that describes how and where to focus your studies.
Download latest books on mediafire and other links compilation Free Training Kit (Exam 70-461): Querying Microsoft SQL Server 2012 [Kindle Edition]
- File Size: 3597 KB
- Print Length: 752 pages
- Simultaneous Device Usage: Unlimited
- Publisher: Microsoft Press; 1 edition (November 26, 2013)
- Sold by: Amazon Digital Services, Inc.
- Language: English
- ASIN: B00AA36TL6
- Text-to-Speech: Enabled
X-Ray:
- Lending: Not Enabled
- Amazon Best Sellers Rank: #187,042 Paid in Kindle Store (See Top 100 Paid in Kindle Store)
- #52
in Books > Computers & Technology > Microsoft > Development > SQL Server - #90
in Books > Computers & Technology > Databases > SQL
- #52
in Books > Computers & Technology > Microsoft > Development > SQL Server - #90
in Books > Computers & Technology > Databases > SQL
Free Training Kit : Querying Microsoft SQL Server 2012
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.
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.
-
Download Link 2