Microsoft 70-432: SQL Server 2008 Implementation and Maintenance
TRY IT FREE FOR 48 HOURS
Access our entire library for 48 hours.
Just fill out the form below.

This course will cover the following topics to prepare students for the 70-432 SQL Server 2008 Implementation and Maintenance exam: how to install and configuring SQL Server 2008, maintaining SQL Server instances, managing SQL Server security, maintaining a SQL Server database, performing data management tasks, monitoring and troubleshooting SQL Server, optimizing SQL Server performance, and implementing high availability.
Lesson 1: Installing Microsoft SQL Server
1.1 Introduction
1.2 Installing Microsoft SQL Server-Part 1
1.3 Installing Mircosoft SQL Server-Part 2
1.4 Choosing A Collation Setting
1.5 Installing Microsoft SQL Server Demo
Lesson 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
Lesson 3: Data Types
3.1 Data Types
Lesson 4: Databases
4.1 Databases
4.2 Creating A Database
4.3 Creating A Database Demo
Lesson 5: Tables
5.1 Tables
5.2 Sparse Columns
5.3 Creating A Table Demo
Lesson 6: Views
6.1 Views
6.2 Creating A View Demo
Lesson 7: Constraints
7.1 Constraints
7.2 Creating A Contsraint Demo
Lesson 8: Store Procedures
8.1 Store Procedures
8.2 Common Language Runtime
8.3 Store Procedures Demo
Lesson 9: Functions
9.1 Functions
9.2 Three Function Types
9.3 Functions Demo
Lesson 10: Service Broker
10.1 Service Broker
10.2 Using Service Broker
Lesson 11: Data Integrity
11.1 Data Integrity
11.2 Planning And Education (demo to be recorded)
Lesson 12: Permissions
12.1 Permissions
Lesson 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
Lesson 14: Additional Security Tools
14.1 Additional Security Tools
14.2 Some Security Tools Demo
Lesson 15: Backing Up and Restoring Databases
15.1 Backups
15.2 Restoring Databases
15.3 Backups Demo
Lesson 16: Endpoints
16.1 Endpoints
16.2 Endpoints Demo
Lesson 17: Linking Servers
17.1 Linking Servers
Lesson 18: Triggers
18.1 Triggers-Part 1
18.2 Triggers-Part 2
18.3 Triggers Demo
Lesson 19: Replication
19.1 Replication
19.2 Replication Coverage-Part 1
19.3 Replication Coverage-Part 2
19.4 Replication Demo
Lesson 20: Performing Indexing and Full-Text Searching
20.1 Indexing
20.2 SQL Searching
20.3 Searching And Indexing In SQL Demo
Lesson 21 Transactions and Locks
21.1 Transactions
21.2 Locks
21.3 Locks Demo
Lesson 22: Moving Data
22.1 Moving Data
Lesson 23: Handling Specialty Data
23.1 Handling Specialty Data
23.2 XML Demo
Lesson 24: High-Availability Methods
24.1 High-Availability-Part 1
24.2 High-Availability-Part 2
24.3 Creating A Snapshot Demo
Lesson 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
Lesson 26: Monitoring and Optimizing SQL Server
26.1 Monitoring And Optimizing SQL Server
26.2 Monitoring And Optimizing SQL Server Demo
Lesson 27: SQL Server Management Tools
27.1 SQL Server Management Tools-Part 1
27.2 SQL Server Management Tools-Part 2
Lesson 28: Troubleshooting Techniques
28.1 Troubleshooting Techniques-Part 1
28.2 Troubleshooting Techniques-Part 2
28.3 Troubleshooting Utilities Demo
28.4 Conclusion