MCTS - Microsoft SQL Server 2005 Certification Training

Course details

This MCTS course includes following exam.
Exam 70-431 Microsoft SQL Server 2005-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 2005 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 2005

• Select an edition of SQL Server 2005 to meet business needs.
• Install SQL Server 2005.
• Identify alternative SQL Server installations.
• Configuring SQL Server 2005
• Use SQL Server 2005 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 2005

• 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.