MCTS - Microsoft SQL Server 2008 Certification Training Course in London
Upcoming Web Design Classes:
15 Dec 2019
10:00 - 17:00 Sun
30 Dec 2019
18:30 - 21:30 Mon, Thu
13 Jan 2020
10:00 - 17:00 Mon, Tue, Wed, Thu
Mon, Tue, Wed, Thu
01 Feb 2020
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.
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
DML and DDL
Create data types and tables
Creating Data Types
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.
RAID Levels (0,1,5,10)
Plan, create, and optimize indexes
Types of views
Implement stored procedures and functions
Creating Stored Procedures
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Managing Keys and Certificates in SQL Server.
Creating and Managing Users.
Database Backup Recovery (Disaster Recovery)
Back up databases.
Create database snapshots
Setting the Recovery Model.
Perform administrative tasks
Configuring the SQL Server Agent.
Creating Operators and Jobs.
Automating Administrative Tasks with SQL Server Agent
Configure Database Mail
Transaction log shipping
Monitor Transaction log shipping.
Introduction to Replication
Overview of Replication.
Creating a Publication.
Creating a Subscription.
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.
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.