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.
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Maße
Höhe: 274 mm
Breite: 206 mm
Dicke: 5 mm
Gewicht
ISBN-13
978-0-470-18374-8 (9780470183748)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
The Microsoft Official Academic Course series is a complete program for instructors and institutions to prepare and deliver great courses on Microsoft software technologies. With MOAC, we recognize that, because of the rapid pace of change in the technology and curriculum developed by Microsoft, there is an ongoing set of needs beyond classroom instruction tools for an instructor to be ready to teach the course. MOAC endeavors to provide solutions for all these needs in a systematic manner in order to ensure a successful and rewarding course experience for both instructor and student-technical and curriculum training for instructor readiness with new software releases, the software itself for student use at home for building hands-on skills, assessment and validation of skill development, and a great set of tools for delivering instruction in the classroom and lab. All are important to the smooth delivery of an interesting course on Microsoft software, and all are provided with the Microsoft Official Academic Course program.
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
