EXAM PREP GUIDE Ace your preparation for the skills measured by MCITP Exam 70-443—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce what you’ve learned by applying your knowledge to real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: <ul>
<li>Install, consolidate, and configure multiple database instances</li> <li>Design tables, file groups, and indexes for a physical database</li> <li>Develop and implement security policies at the server, database, and object levels</li> <li>Design, implement, and configure clustering, log shipping, database mirroring, and replication</li> <li>Create plans for data archiving, data backups, and disaster recovery</li> </ul>
PRACTICE TESTS: Assess your skills with practice tests on CD. 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. Your training kit includes: <ul> Details inside. <li>Official self-paced study guide.</li> <li>Practice tests with multiple, customizable testing options and a learning plan based on your results.</li> <li>375+ practice and review questions.</li> <li>Case scenarios, practice exercises, and best practices.</li> <li>180-day evaluation version of Microsoft SQL Server 2005 Enterprise Edition.</li> <li>20 Webcasts with 25+ additional hours of instruction.</li> <li>Fully searchable eBook of this guide.</li> </ul>
For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

MCITP Self-Paced Training Kit (Exam 70-443): Designing a Database Server Infrastructure Using Microsoft® SQL Server(TM) 2005 (Pro Certification)

Computers & Technology

Hotek, Mike

Mackin, J.C.

Certification

Microsoft Press

Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to build database solutions that solve real-world business problems. Learn to integrate SQL Server data in your applications, write queries, develop reports, and employ powerful business intelligence systems. Discover how to: 
<ul>
<li>Install and work with core components and tools </li>
<li>Create tables and index structures </li>
<li>Manipulate and retrieve data </li>
<li>Secure, manage, back up, and recover databases </li>
<li>Apply tuning plus optimization techniques to generate high-performing database applications </li>
<li>Optimize availability through clustering, database mirroring, and log shipping </li>
<li>Tap business intelligence tools—Reporting, Analysis, and Integration Services </li>
</ul>
 CD features: <ul>
<li>Practice exercises and code samples </li>
<li>Fully searchable eBook </li>
</ul>
 For customers who purchase an ebook version of this title, instructions for downloading the CD files can be found in the ebook.

Microsoft® SQL Server® 2008 Step by Step

Operating Systems

EXAM PREP GUIDE Ace your preparation for the skills measured by MCTS Exam 70-432—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: 
<ul>
<li>Configure, manage, back up, and restore databases </li>
<li>Create a partitioned table, index, or indexed view </li>
<li>Configure services and components to manage your environment </li>
<li>Help prevent unauthorized access at each security infrastructure layer </li>
<li>Design and deploy high-availability solutions </li>
<li>Manage SQL Server Agent jobs, alerts, and operators </li>
<li>Identify service, concurrency, and job execution problems </li>
</ul>
 PRACTICE TESTS Assess your skills with the practice tests on CD. 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. Your kit includes: <ul>
<li>15% exam discount from Microsoft. (Limited time offer). Details inside. </li>
<li>Official self-paced study guide. </li>
<li>Practice tests with multiple, customizable testing options and a learning plan based on your results. </li>
<li>250+ practice and review questions. </li>
<li>Case scenarios, exercises, and best practices. </li>
<li>Sample chapters from related Microsoft Press® books. </li>
<li>180-day trial of SQL Server 2008 Enterprise Edition. </li>
<li>Fully searchable eBook of this guide. </li>
</ul>

MCTS Self-Paced Training Kit (Exam 70-432): Microsoft® SQL Server® 2008 - Implementation and Maintenance: Microsoft SQL Server 2008--Implementation and Maintenance

Ace your preparation for the skills measured by MCTS Exam 70-433—and on the job. Work at your own pace through a series of lessons and reviews that fully cover each exam objective. Then, reinforce and apply what you’ve learned through real-world case scenarios and practice exercises. This official Microsoft study guide is designed to help you make the most of your study time. Maximize your performance on the exam by learning to: <ul>
<li>Create and manage database objects</li> <li>Query and modify data; implement subqueries and CTEs * Optimize table structures and data integrity</li> <li>Create stored procedures, functions, and triggers</li> <li>Manage transactions, error handling, and change tracking</li> <li>Tune query performance</li> <li>Implement database mail, full-text search, Service Broker, scripts</li> <li>Work with XML and SQLCLR Assess your skills with the practice tests on CD. 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.</li> </ul>
Your kit includes:

MCTS Self-Paced Training Kit (Exam 70-433): Microsoft® SQL Server® 2008 - Database Development: Microsoft SQL Server 2008 Database Development

Weber, Ann

Thernstrom, Tobias

What you need to get the job done. The latest book from the best-selling SQL Server author Mike Hotek. SQL Server 2012 Data Design and Retrieval is your reference for building databases and querying data. I no longer have a publisher making me stay away from all of the advanced topics. If you bought one of my prior books and quickly found yourself outgrowing it, this one is MUCH different. SQL Server professionals of all levels will find something in this book which will impact the way you design databases and manage data. This is the most in-depth book I have ever written on SQL Server. This book takes you on a tour from the basics through the advanced details delivering a reference which you can employ in solving the real-world problems faced every day by database professionals. Each topic is reinforced with detailed exercises taken from real customer implementations. All of the content is updated for SQL Server 2012 SP1 and includes the new features which were introduced. Each topic starts with the basics, giving beginners a good starting point, and then drills down to the advanced details which will interest even the most seasoned SQL Server professionals. This book is also a great starting point for the 70-461 Querying Microsoft SQL Server 2012 certification exam. I believe in learning the material for your job and using an exam to verify mastery. If you are simply looking for a cookbook to pass an exam, this isn't the book for you. If you want to really learn SQL Server and be able to apply it to your job, you've found the right book. We start with a brief overview of SQL Server and walk you through getting everything you need for the examples installed. Once installed, the structure of a database is covered including details on FILESTREAM storage and how it works in SQL Server 2012. After getting through the pre-requisites, Chapter 5 becomes the launch point for a tour de force through designing, mainpulating, and querying data. You will get a very detailed discussion of all of the data types and specifically when and how to use them with examples that show you why a FLOAT is actually more accurate than a DECIMAL. Mike also explains, how to REALLY design a database without all of the baffling technobabble. Once we have some tables, we dive into a detailed discussion of the on-disk storage mechanisms, how a row is actually stored, and how to compute the real space consumption. You learn all of the ins and outs of manipulating data, including how to manipulate trees and subtrees within a hierarchy. The concurrency chapter provides an in-depth view into everything having to do with transaction management. If that wasn't enough, we then take you through basic, intermediate, and advanced querying applying everything that you could think of doing with a SELECT statement, inlcuding 20+ pages on window functions and querying XML on the way to a deep dive into spatial data. After finding out how to write a SELECT statement to find the nearest Starbucks, we finish off the book with a 150+ page dissertation on SQL Server indexes. You'll drill through every component of every type of index, including an explanation of how statistics are actually built with some examples on how the stats can have a completely unexpected effect on your query plans. The book finishing not just with partitioning but a real world implementation which very few DBAs even know how to do on the way to explaining just why something as simple as the nullability of a column can double the number of processor cycles your queries require.

SQL Server 2012 Data Design and Retrieval

Databases & Big Data

CreateSpace Independent Publishing Platform