Microsoft Official Academic Course

Textbook

70-443 and 70-450: Microsoft SQL Server Database Design and Optimization

December 2009, ©2010
70-443 and 70-450: Microsoft SQL Server Database Design and Optimization (EHEP001594) cover image

This book is for students preparing to become certified for the 70-443 and 70-450 Microsoft SQL Server 2005/2008 Database Design and Optimization, Database Administration exam.  The Microsoft Official Academic Course (MOAC) lessons correlate and are mapped to the Microsoft Certified Information Technology Professional (MCITP) 70-443 and 70-450 certification exam.  This text covers installing and configuring  the Microsoft SQL Server, managing and maintaining databases or multidimensional databases, user accounts, database availability, recovery, and reporting.   This book also guides you through designing and implementation of security and server automation.    The MOAC IT Professional series is the Official from Microsoft, turn-key Workforce training program that leads to professional certification and was authored for college instructors and college students. 


MOAC  gets instructors ready to teach and students ready for work by delivering essential resources in 5 key areas:  Instructor readiness, student software, student assessment, instruction resources, and learning validation.   With the Microsoft Official Academic course program, you are getting instructional support from Microsoft; materials that are accurate and make course delivery easy. 

Custom Select
Create a customized edition with Wiley Custom Select
Table of Contents
Lesson 1: Designing the Hardware and Software Infrastructure

Lesson 2: Designing Physical Storage

Lesson 3: Designing a Consolidation Strategy

Lesson 4: Analyzing and Designing Security

Lesson 5: Designing Windows Server-Level Security

Lesson 6: Designing SQL Server Service-Level and Database-Level Security

Lesson 7: Designing SQL Server Object-Level Security 

Lesson 8: Designing a Physical Database

Lesson 9: Creating Database Conventions and Standards

Lesson 10: Designing a SQL Server Solution for High Availability

Lesson 11: Designing a Data Recovery Solution for a Database       

Lesson 12: Designing a Data-Archiving Solution

        

 

Available Versions

Exam 70-443 & 70-450: Microsoft SQL Server Database Design and Optimization
by Microsoft Official Academic Course
ISBN 978-0-470-18365-6
December 2009, ©2010
Paperback, 336 pages
US $140.95 Add to Cart
Exam 70-443 & 70-450 SQL Server Database Design Optimization with MOAC Labs Online Set
by Microsoft Official Academic Course
ISBN 978-1-118-30561-4
November 2011
Paperback
US $196.95 Add to Cart
Exam 70-443 & 70-450: Microsoft SQL Server Database Design and Optimization with Lab Manual Set
by Microsoft Official Academic Course
ISBN 978-0-470-18374-8
December 2009, ©2010
Paperback, 456 pages
US $149.95 Add to Cart
Exam 70-443 & 70-450: Microsoft SQL Server Database Design and Optimization with Lab Manual and MOAC Labs Online Set
by Microsoft Official Academic Course
ISBN 978-1-118-17654-2
December 2011
Paperback
US $213.95 Add to Cart
70-443 & 70-450 MOAC Labs Online Reg Code
by Microsoft Official Academic Course
ISBN 978EOARC00048
December 2012
Digital Content (Online or Downloadable)
US $78.95 Add to Cart
Exam 70-443 & 70-450: MOAC Labs Online
by Microsoft Official Academic Course
ISBN 978-1-118-14021-5
August 2011, ©2011
Paperback
US $79.95 Add to Cart
E-book
Exam 70-443 & 70-450: Microsoft SQL Server Database Design and Optimization
by Microsoft Official Academic Course
ISBN 978-1-118-45335-3
May 2012
Wiley E-Text
E-book
Exam 70-443 & 70-450 Microsoft SQL Server Database Design and Optimization Lab Manual Desktop Edition
ISBN 978-1-118-45341-4
May 2012
Wiley E-Text
Get technical support for this product Print this page Share