Microsoft 70-432: SQL Server 2008 Implementation and Maintenance
About this course
This course will cover the following topics to prepare students for the Microsoft 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.
Microsoft certifications are in high demand across small and large Information Technology organizations around the world. Hiring managers prefer candidates who not only have an understanding of the topic(s) and experience, but having the training certification in the subject. As a result, all Microsoft certifications are accepted worldwide and are part of the industry standards.</p>
This Microsoft 70-432 exam measures your ability to accomplish the technical tasks below:
- Installing and configuring SQL Server 2008 (11%)
- Maintaining SQL Server instances (9%)
- Managing SQl Server security (18%)
- Maintaining a SQL Server database (17%)
- Performing data management tasks (10%)
- Monitoring and troubleshooting SQL Server (14%)
- Optimizing SQL Server performance (12%)
- Implementing high availability (9%)
Candidates should have one to two years of experience using SQL Server 2008 or two to three years of experience using a previous version of SQL Server. Candidates for this exam are IT professionals who work in jobs in which database administration is their main area of responsibility. Or who work in environments in which databases are central to their primary job roles. These job roles include the following:
- IT generalists who work in environments in which SQL Server 2008 is part of an overall solution
- IT professionals who manage systems that run SQL Server 2008
- Developers who build applications that use SQL Server 2008
- IT professionals who work with third-party applications that are built on SQL Server 2008
Course Outline
Lesson01 Installing Microsoft SQL Server
- 1.1 Introduction
- 1.2 InstallingMicrosoftSQLServer-Part1
- 1.3 InstallingMircosoftSQLServer-Part2
- 1.4 ChoosingACollationSetting
- 1.5 InstallingMicrosoftSQLServerDemo
Lesson02 Navigating SQL Server
- 2.1 NavigatingSQLServer
- 2.2 ManagementStudioDemo
- 2.3 SQLServerConfigurationManager
- 2.4 SQLServerConfigurationManagerDemo
Lesson03 Data Types
- 3.1 DataTypes
Lesson04 Databases
- 4.1 Databases
- 4.2 CreatingADatabase
- 4.3 CreatingADatabaseDemo
Lesson05 Tables mcsa_432_mod_
- 5.1 Tables
- 5.2 SparseColumns
- 5.3 CreatingATableDemo
Lesson06 Views
- 6.1 Views
- 6.2 CreatingAViewDemo
Lesson07 Contraints
- 7.1 Contraints
- 7.2 CreatingAContraintDemo
Lesson08 Store Procedures
- 8.1 StoreProcedures
- 8.2 CommonLanguageRuntime
- 8.3 StoreProceduresDemo
Lesson09 Functions
- 9.1 Functions
- 9.2 ThreeFunctionTypes
- 9.3 FunctionsDemo
Lesson10 Service Broker
- 10.1 ServiceBroker
- 10.2 UsingServiceBroker
Lesson11 Data Integrity
- 11.1 DataIntegrity
- 11.2 PlanningAndEducation (demo to be recorded)
Lesson12 Permissions
- 12.1 Permissions
Lesson13 Logins, Roles, and Credentials
- 13.1 LoginsAndRoles
- 13.2 MoreRolesAndCredentials
- 13.3 UsersAndRolesDemo
- 13.4 AssigningARoleDemo
Lesson14 Additional Security Tools
- 14.1 AdditionalSecurityTools
- 14.2 SomeSecurityToolsDemo
Lesson15 Backing Up and Restoring Databases
- 15.1 Backups
- 15.2 RestoringDatabases
- 15.3 BackupsDemo
Lesson16 Endpoints
- 16.1 Endpoints
- 16.2 EndpointsDemo
Lesson17 Linking Servers
- 17.1 LinkingServers
Lesson18 Triggers
- 18.1 Triggers-Part1
- 18.2 Triggers-Part2
- 18.3 TriggersDemo
Lesson19 Replication
- 19.1 Replication
- 19.2 ReplicationCoverage-Part1
- 19.3 ReplicationCoverage-Part2
- 19.4 ReplicationDemo
Lesson20 Performing Indexing and Full-Text Searching
- 20.1 Indexing
- 20.2 SQLSearching
- 20.3 SearchingAndIndexingInSQLDemo
Lesson21 Transactions and Locks
- 21.1 Transactions
- 21.2 Locks
- 21.3 LocksDemo
Lesson22 Moving Data
- 22.1 MovingData
Lesson23 Handling Specialty Data
- 23.1 HandlingSpecialtyData
- 23.2 XMLDemo
Lesson24 High-Availability Methods
- 24.1 High-Availability-Part1
- 24.2 High-Availability-Part2
- 24.3 CreatingASnaphotDemo
Lesson25 Maintaining and Automating a SQL Server
- 25.1 MaintainingAndAutomatingASQLServer-Part1
- 25.2 MaintainingAndAutomatingASQLServer-Part2
- 25.3 SettingUpASQLEmailDemo
Lesson26 Monitoring and Optimizing SQL Server
- 26.1 MonitoringAndOptimizingSQLServer
- 26.2 MonitoringAndOptimizingSQLServerDemo
Lesson27 SQL Server Management Tools
- 27.1 SQLServerManagementTools-Part1
- 27.2 SQLServerManagementTools-Part2
Lesson28 Troubleshooting Techniques
- 28.1 TroubleshootingTechniques-Part1
- 28.2 TroubleshootingTechniques-Part2
- 28.3 TroubleshootingUtilitiesDemo
- 28.4 Conclusion