tailieunhanh - MCTS Exam 70-432: Microsoft SQL Server 2008 — Implementation and Maintenance

Introduction CHAPTER 1 Installing and Confi guring SQL Server 2008 CHAPTER 2 Database Confi guration and Maintenance CHAPTER 3 Tables CHAPTER 4 Designing SQL Server Indexes CHAPTER 5 Full Text Indexing CHAPTER 6 Distributing and Partitioning Data CHAPTER 7 Importing and Exporting Data CHAPTER 8 Designing Policy Based Management | Microsoft MCTS EXAM 70-432 Microsoft SQL Server 2008-Implementation and Maintenance Mike Hotek SELF-PACED Training Kit Exam 70-432 Microsoft SQL Server 2008 Implementation and Maintenance 0BJECTIVE LOCATION IN BOOK INSTALLING AND CONFIGURING SQL SERVER 2008 Configure additional SQL Server components. Chapter 1 Lessons 3 and 4 Chapter 5 Lessons 1 2 and 3 Configure SQL Server instances. Chapter 1 Lesson 3 Configure SQL Server services. Chapter 1 Lesson 3 Install SQL Server 2008 and related services. Chapter 1 Lesson 3 Chapter 5 Lessons 1 2 and 3 Implement database mail. Chapter 1 Lesson 4 Configure full-text indexing. Chapter 5 Lessons 1 2 and 3 MAINTAINING SQL SERVER INSTANCES Manage SQL Server Agent jobs. Chapter 10 Lesson 2 Manage SQL Server Agent alerts. Chapter 10 Lesson 4 Manage SQL Server Agent operators. Chapter 10 Lesson 3 Implement the declarative management framework DMF . Chapter 8 Lessons 1 and 2 Back up a SQL Server environment. Chapter 9 Lessons 1 2 and 3 MANAGING SQL SERVER SECURITY Manage logins and server roles. Chapter 11 Lesson 3 Manage users and database roles. Chapter 11 Lesson 3 Manage SQL Server instance permissions. Chapter 11 Lesson 4 Manage database permissions. Chapter 11 Lesson 4 Manage schema permissions and object permissions. Chapter 11 Lesson 4 Audit SQL Server instances. Chapter 11 Lesson 5 Manage transparent data encryption. Chapter 11 Lesson 6 Configure surface area. Chapter 8 Lessons 1 2 and 3 Chapter 11 Lesson 2 0BJECTIVE LOCATION IN BOOK MAINTAINING A SQL SERVER DATABASE Back up databases. Chapter 2 Lesson 1 Chapter 9 Lesson 1 Restore databases. Chapter 9 Lessons 2 and 3 Manage and configure databases. Chapter 2 Lessons 2 3 and 4 Manage database snapshots. Chapter 9 Lesson 3 Maintain database integrity. Chapter 2 Lesson 4 Maintain a database by using maintenance plans. Chapter 9 Lesson 1 PERFORMING DATA MANAGEMENT TASKS Import and export data. Chapter 7 Lessons 1 2 3 and 4 Manage data partitions. Chapter 6 Lessons 1 2 3 and 4 .