MCTS - Microsoft SQL Server 2008 Certification Training Course in London

Upcoming Web Design Classes:

19 Jun 2022
10:00 - 17:00 Sun
04 Jul 2022
18:30 - 21:30 Mon, Thu
Mon, Thu
18 Jul 2022
10:00 - 17:00 Mon, Tue, Wed, Thu
Mon, Tue, Wed, Thu
06 Aug 2022
10:00 - 17:00 Sat

MS SQL Server Course Overview

This MCTS course includes following exam.
Exam 70-432 Microsoft SQL Server 2008-Implementation and Maintenance

Who is this SQL SERVER course for?

This training course is for you if you are interested in becoming Microsoft Certified Technology Specialist. This training course can be taken as a part-time evening course or even on the weekends. Each course is restricted to a maximum of six delegates to ensure an excellent training experience.

Learn from MCTS trainers

This course will be offered by MCTS certified trainers who are working in the industry as Microsoft engineers. Those consultants write and teach our MCTS & MCSE training courses, so their experience directly informs course content.

Course Contents

Introduction to Databases and Terminology
Categories of RDMS
What is MS SQL
Purpose of MS SQL
Introduction of SQL 2008 server

Introduction to SQL Language
Introduction of SSMS
Create data types and tables
Creating Data Types
Creating Tables.

Database Diagrams
Join Types (inner join , outer join, cross join, union )

Installing SQL Server 2008
Select an edition of SQL Server 2008 to meet business needs.
Install SQL Server 2008.
Identify alternative SQL Server installations.
Configuring SQL Server 2008
Use SQL Server 2008 management tools.

Introduction to creating Databases
Manage database files.
Planning databases.
Creating databases.
Managing databases.
RAID Levels (0,1,5,10)

Plan, create, and optimize indexes
Planning Indexes
Creating Indexes
Optimizing Indexes

Partition functions
Partition schemes
Partition indexes

Implement views
Creating Views
Types of views

Implement stored procedures and functions
Creating Stored Procedures
Creating Functions

Manage security
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Managing Keys and Certificates in SQL Server.
Creating Logins.
Creating and Managing Users.
Creating Triggers.

Database Backup Recovery (Disaster Recovery)
Back up databases.
Restore databases.
Create database snapshots
Setting the Recovery Model.

Perform administrative tasks
Configuring the SQL Server Agent.
Creating Operators and Jobs.
Creating Alerts.
Automating Administrative Tasks with SQL Server Agent
Configure Database Mail

Transaction log shipping
Primary Server
Secondary server
Monitor Transaction log shipping.

Introduction to Replication
Overview of Replication.
Replication Scenarios.
Creating a Publication.
Creating a Subscription.

Http Endpoints
Purpose of Http endpoints
Configuration of http endpoints
Security of endpoints

Configuring Database Mirroring
Setting the Recovery Model
Backing Up and Restoring the Database
Starting Database Mirroring
Performing and Automatic and Manual Failover

Monitor SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using Event Notifications.

Transfer data
Create an SSIS Package.
Deploying an SSIS Package.

Use XML-related features in Microsoft SQL Server 2008
Retrieving XML by Using FOR XML.
Shredding XML by Using OPENXML.
Using the xml Data Type.
Mapping Relational Data and XML.
Storing XML Natively in the Database.
Creating XML Indexes.
Implementing XML Schemas.