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
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
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
3.1 Data Types
Module 4: Databases
4.1 Databases
4.2 Creating A Database
4.3 Creating A Database Demo
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
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
6.1 Views
6.2 Creating A View Demo
Module 7: Constraints
7.1 Constraints
7.2 Creating A Contsraint Demo
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
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
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
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)
11.1 Data Integrity
11.2 Planning And Education (demo to be recorded)
Module 12: Permissions
12.1 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
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
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
15.1 Backups
15.2 Restoring Databases
15.3 Backups Demo
Module 16: Endpoints
16.1 Endpoints
16.2 Endpoints Demo
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
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
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
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
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
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
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
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
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
28.1 TroubleshootingTechniques-Part 1
28.2 TroubleshootingTechniques-Part 2
28.3 Troubleshooting Utilities Demo
28.4 Conclusion
Reviews
There are no reviews yet.