London College Of Online Learning

HOME >> IT CERTIFICATIONS >> DATABASES, MICROSOFT >> Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

£59.00

Duration: 19 Hours 58 Minutes

72 Course Videos

Microsoft 70-432: SQL Server 2008 Implementation and Maintenance

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 configure 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, optimising 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.

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

This exam has been retired, but continues to be a valuable resource for learning!

For complete information on this certification course, please visit the Microsoft website for details and exam pricing.

Course Videos

This course contains the following modules and videos. Click the down arrow to view video details.

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 SQL Server
Management Studio Demo
SQL Server Configuration Manager
SQL 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: Constraints

Constraints
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
SQL Searching
Searching And Indexing In SQL Demo

Module 21: Transactions and Locks

Transactions
Locks
Locks Demo

Module 22: Moving Data

Moving Data

Module 23: Handling Specialty Data

Handling Specialty Data
XML Demo

Module 24: High-Availability Methods

High-Availability- Part1
High-Availability- Part2
Creating A Snapshot Demo

Module 25: Maintaining and Automating a SQL Server

Maintaining And Automating A SQL Server- Part1
Maintaining And Automating A SQL Server- Part2
Setting Up A SQL Email Demo

Module 26: Monitoring and Optimizing SQL Server

Monitoring And Optimizing SQL Server
Monitoring And Optimizing SQL Server Demo

Module 27: SQL Server Management Tools

SQL Server Management Tools- Part1
SQL Server Management Tools- Part2

Module 28: Troubleshooting Techniques

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

Our Learning System Includes

Instructor Led Lectures

All of our IT Courses recreate a real time class experience with a highly qualified and experienced instructor delivering the course’s theories and concepts on screen. All of our lectures are pre-recorded and available to the user 24/7. They can easily be paused, repeated, rewound and fast-forwarded.

Visual Presentations

We understand that all students are different when it comes to learning, therefore different types of delivery mediums are needed in order to achieve success for students. Taking that into account, we deliver our content in a variety of different ways to ensure that students stay engaged and productive throughout their courses.

Mobile Optimisation & Progress Tracking

Our courses are optimised for all mobile devices allowing users to learn on the go whenever they have spare time and wish to do so. Users can access their courses from anywhere and their progress is completely tracked and recorded delivering peace of mind to each and every user.

Practice Quizzes and Exams

Our custom practice exams prepare students for their exams differently and more effectively than the traditional exam preps on the market. Students will have practice quizzes after each module to ensure that they are confident on the topic they are learning.

World Class Learning Management System

We provide the next generation Learning Management System (LMS) to all of our students. This is an experience that combines the feature set of traditional LMS with advanced functionality designed to make learning management easy and online learning engaging from the student’s perspective.