Microsoft 70-432: SQL Server 2008 Implementation and Maintenance
Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

$49
Instructor
Reviews
Rating

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

Reviews

0 Rated 0 out of 0 Ratings
5 stars
4 stars
3 stars
2 stars
1 stars