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.

  • Introduction
  • Installing Microsoft S Q L Server- Part1
  • Installing Microsoft S Q L Server- Part2
  • Choosing A Collation Setting
  • Installing Microsoft SQL Server Demo
  • Navigating S Q L Server
  • Management Studio Demo
  • SQL Server Configuration Manager
  • SQL Server Configuration Manager Demo
  • Data Types
  • Databases
  • Creating A Database
  • Creating A Database Demo
  • Tables
  • Sparse Columns
  • Creating A Table Demo
  • Views
  • Creating A View Demo
  • Contraints
  • Creating A Contraint Demo
  • Store Procedures
  • Common Language Runtime
  • Store Procedures Demo
  • Functions
  • Three Function Types
  • Functions Demo
  • Service Broker
  • Using Service Broker
  • Data Integrity
  • Planning And Education
  • Permissions
  • Logins And Roles
  • More Roles And Credentials
  • Users And Roles Demo
  • Assigning A Role Demo
  • Additional Security Tools
  • Some Security Tools Demo
  • Backups
  • Restoring Databases
  • Backups Demo
  • Endpoints
  • Endpoints Demo
  • Linking Servers
  • Triggers- Part1
  • Triggers- Part2
  • Triggers Demo
  • Replication
  • Replication Coverage- Part1
  • Replication Coverage- Part2
  • Replication Demo
  • Indexing
  • SQL Searching
  • Searching And Indexing In S Q L Demo
  • Transactions
  • Locks
  • Locks Demo
  • Moving Data
  • Handling Specialty Data
  • X M L Demo
  • High- Availability- Part1
  • High- Availability- Part2
  • Creating A Snaphot Demo
  • 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
  • Monitoring And Optimizing S Q L Server
  • Monitoring And Optimizing S Q L Server Demo
  • S Q L Server Management Tools- Part1
  • S Q L Server Management Tools- Part2
  • Troubleshooting Techniques- Part1
  • Troubleshooting Techniques- Part2
  • Troubleshooting Utilities Demo
  • Conclusion

Instructor led lectures

All IT Nuggets 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

IT Nuggets 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

IT Nuggets 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

IT Nuggets 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.