Microsoft 70-432: Sql Server 2008, Implementation And Maintenance

Module 1: Installing Microsoft SQL Server

• 1.1 Introduction
• 1.2 Installing Microsoft SQL Server-Part 1
• 1.3 Installing Microsoft SQL Server-Part 2
• 1.4 Choosing A Collation Setting
• 1.5 Installing Microsoft SQL Server Demo

Module 2: Navigating SQL Server

• 2.1 Navigating SQL Server
• 2.2 Management Studio Demo
• 2.3 SQL Server Configuration Manager
• 2.4 SQL Server Configuration Manager Demo

Module 3: Data Types

• 3.1 Data Types

Module 4: Databases

• 4.1 Databases
• 4.2 Creating A Database
• 4.3 Creating A Database Demo

Module 5: Tables

• 5.1 Tables
• 5.2 Sparse Columns
• 5.3 Creating A Table Demo

Module 6: Views

• 6.1 Views
• 6.2 Creating A View Demo

Module 7: Constraints

• 7.1 Constraints
• 7.2 Creating A Constraint Demo

Module 8: Store Procedures

• 8.1 Store Procedures
• 8.2 Common Language Runtime
• 8.3 Store Procedures Demo

Module 9: Functions

• 9.1 Functions
• 9.2 Three Function Types
• 9.3 Functions Demo

Module 10: Service Broker

• 10.1 Service Broker
• 10.2 Using Service Broker

Module 11: Data Integrity

• 11.1 Data Integrity
• 11.2 Planning and Education (demo to be recorded)

Module 12: Permissions

• 12.1 Permissions

Module 13: Logins, Roles, and Credentials

• 13.1 Logins and Roles
• 13.2 More Roles and Credentials
• 13.3 Users and Roles Demo
• 13.4 Assigning A Role Demo

Module 14: Additional Security Tools

• 14.1 Additional Security Tools
• 14.2 Some Security Tools Demo

Module 15: Backing Up and Restoring Databases

• 15.1 Backups
• 15.2 Restoring Databases
• 15.3 Backups Demo

Module 16: Endpoints

• 16.1 Endpoints
• 16.2 Endpoints Demo

Module 17: Linking Servers

• 17.1 Linking Servers

Module 18: Triggers

• 18.1 Triggers-Part 1
• 18.2 Triggers-Part 2
• 18.3 Triggers Demo

Module 19: Replication

• 19.1 Replication
• 19.2 Replication Coverage-Part 1
• 19.3 Replication Coverage-Part 2
• 19.4 Replication Demo

Module 20: Performing Indexing and Full-Text Searching

• 20.1 Indexing
• 20.2 SQL Searching
• 20.3 Searching and Indexing In SQL Demo

Module 21: Transactions and Locks

• 21.1 Transactions
• 21.2 Locks
• 21.3 Locks Demo

Module 22: Moving Data

• 22.1 Moving Data

Module 23: Handling Specialty Data

• 23.1 Handling Specialty Data
• 23.2 XML Demo

Module 24: High-Availability Methods

• 24.1 High-Availability-Part 1
• 24.2 High-Availability-Part 2
• 24.3 Creating A Snapshot Demo

Module 25: Maintaining and Automating a SQL Server

• 25.1 Maintaining and Automating A SQL Server-Part 1
• 25.2 Maintaining and Automating A SQL Server-Part 2
• 25.3 Setting Up A SQL Email Demo

Module 26: Monitoring and Optimizing SQL Server

• 26.1 Monitoring and Optimizing SQL Server
• 26.2 Monitoring and Optimizing SQL Server Demo

Module 27: SQL Server Management Tools

• 27.1 SQL Server Management Tools-Part 1
• 27.2 SQL Server Management Tools-Part 2

Module 28: Troubleshooting Techniques

• 28.1 Troubleshooting Techniques-Part 1
• 28.2 Troubleshooting Techniques-Part 2
• 28.3 Troubleshooting Utilities Demo
• 28.4 Conclusion