Client's Area

MCTS - Microsoft SQL Server 2008 Certification Training Course in London

MCTS - Microsoft SQL Server 2008 Certification Training Course in London


Upcoming MCTS - SQL Server 2008 Classes:


Choose your preferred start date from the list below, and then click on Reserve your place.

Course Session Starting Date Day(s) Price  
10:00 - 17:00 Sun 22 Oct 2017 4 £950.00 Reserve your place
18:30 - 21:30 Mon, Thu 06 Nov 2017 8 £950.00 Reserve your place
10:00 - 17:00 Mon, Tue, Wed, Thu 20 Nov 2017 4 £950.00 Reserve your place
10:00 - 17:00 Sat 09 Dec 2017 4 £950.00 Reserve your place
  • Classroom based course
  • eNotes included
  • Hands on training
  • Free online support after course

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


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

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

T-SQL
Constraints
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
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.