Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

R3,999.00

Description

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.

 

Module 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
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 Contsraint 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 ManagementTools-Part 1
27.2 SQL Server ManagementTools-Part 2
Module 28: Troubleshooting Techniques
28.1 TroubleshootingTechniques-Part 1
28.2 TroubleshootingTechniques-Part 2
28.3 Troubleshooting Utilities Demo
28.4 Conclusion

Reviews

There are no reviews yet.

Be the first to review “Microsoft 70-432: SQL Server 2008 Implementation and Maintenance”

Your email address will not be published. Required fields are marked *