Microsoft 70-432: SQL Server 2008 Implementation and Maintenance


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.

Course Modules & Videos

The Microsoft 70-432: SQL Server 2008 Implementation and Maintenance course is organized into the following modules. Click a module title to view the video list contained in each section.

Module 1: Installing Microsoft SQL Server

  • Introduction
  • Installing Microsoft S Q L Server- Part1
  • Installing Microsoft S Q L Server- Part2
  • Choosing A Collation Setting
  • Installing Microsoft S Q L Server Demo

Module 2: Navigating SQL Server

  • Navigating S Q L Server
  • Management Studio Demo
  • S Q L Server Configuration Manager
  • S Q L Server Configuration Manager Demo

Module 3: Data Types

  • Data Types

Module 4: Databases

  • Databases
  • Creating A Database
  • Creating A Database Demo

Module 5: Tables

  • Tables
  • Sparse Columns
  • Creating A Table Demo

Module 6: Views

  • Views
  • Creating A View Demo

Module 7: Contraints

  • Contraints
  • Creating A Contraint Demo

Module 8: Store Procedures

  • Store Procedures
  • Common Language Runtime
  • Store Procedures Demo

Module 9: Functions

  • Functions
  • Three Function Types
  • Functions Demo

Module 10: Service Broker

  • Service Broker
  • Using Service Broker

Module 11: Data Integrity

  • Data Integrity
  • Planning And Education

Module 12: Permissions

  •  Permissions

Module 13: Logins, Roles and Credentials

  • Logins And Roles
  • More Roles And Credentials
  • Users And Roles Demo
  • Assigning A Role Demo

Module 14: Additional Security Tools

  • Additional Security Tools
  • Some Security Tools Demo

Module 15: Backing Up and Restoring Databases

  • Backups
  • Restoring Databases
  • Backups Demo

Module 16: Endpoints

  • Endpoints
  • Endpoints Demo

Module 17: Linking Servers

  • Linking Servers

Module 18: Triggers

  • Triggers- Part1
  • Triggers- Part2
  • Triggers Demo

Module 19: Replication

  • Replication
  • Replication Coverage- Part1
  • Replication Coverage- Part2
  • Replication Demo

Module 20: Performing Indexing and Full-Text Searching

  • Indexing
  • S Q L Searching
  • Searching And Indexing In S Q L Demo

Module 21: Transactions and Locks

  • Transactions
  • Locks
  • Locks Demo

Module 22: Moving Data

  • Moving Data

Module 23: Handling Specialty Data

  • Handling Specialty Data
  • X M L Demo

Module 24: High-Availability Methods

  • High- Availability- Part1
  • High- Availability- Part2
  • Creating A Snaphot Demo

Module 25: Maintaining and Automating a SQL Server

  • Maintaining And Automating A S Q L Server- Part1
  • Maintaining And Automating A S Q L Server- Part2
  • Setting Up A S Q L Email Demo

Module 26: Monitoring and Optimizing SQL Server

  • Monitoring And Optimizing S Q L Server
  • Monitoring And Optimizing S Q L Server Demo

Module 27: SQL Server Management Tools

  • S Q L Server Management Tools- Part1
  • S Q L Server Management Tools- Part2

Module 28: Troubleshooting Techniques

  • Troubleshooting Techniques- Part1
  • Troubleshooting Techniques- Part2
  • Troubleshooting Utilities Demo
  • Conclusion

Instructor led lectures

All ITNO Courses replicate a live class experience with an instructor on screen delivering the course’s theories and concepts.

These lectures are pre-recorded and available to the user 24/7. They can be repeated, rewound, fast forwarded.

Visual Demonstrations, Educational Games & Flashcards

ITNO recognizes that all students do not learn alike and different delivery mediums are needed in order to achieve success for a large student base. With that in mind, we delivery our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimization & Progress Tracking

Our courses are optimized for all mobile devices allowing students to learn on the go whenever they have free time. Students can access their courses from anywhere and their progress is completely tracked and recorded.

Practice Quizzes and Exams

ITNO Online’s custom practice exams prepare you for your exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure you are confident on the topic you are learning.

World Class Learning Management System

ITNO provides the next generation learning management system (LMS). An experience that combines the feature set of traditional Learning Management Systems with advanced functionality designed to make learning management easy and online learning engaging from the user’s perspective.