MCTS: SQL Server 2005 Call: 0207 392 9696 
 
Request Brochure
 
 
Name :
Email :
Phone :
Course :
Address :
Call Now: 0207 392 9696
 

QUICK TIME TABLE
 Weekday
StartsDay(s)Time
Aug 5 2008 Tue, Thurs18:30-21:30
Aug 15 2008 Friday10.00-17.00
Aug 26 2008 Tue, Thurs18:00-21:00
 Weekend
StartsDay(s)Time
Jul 5 2008 Saturday10.00-17.00
Jul 11 2008 Friday10:00-17:00
Aug 2 2008 Saturday10.00-17.00
 Fast Track
StartsDay(s)Time
Jul 28 2008 M-T-W-T10.00-18.00
Aug 26 2008 T-W-T-F10.00-18.00
Sep 22 2008 M-T-W-T10.00-18.00

MCTS SQL 2005 SPECIALS
   MCTS SQL 2005 &
   Oracle OCP 10g - £1650
   You save £450       
   MCTS SQL 2005 &
   MCSE - £1650
   You save £450      
   MCTS SQL 2005 &
   MCTS Web - £1550
   You save £250       

 
 
Raves reviews responses
 
It was a good course. Much improvement by the lecturer compared with the classes I took with him before. The airconditioning and lighting in the classrooms can improve. - Mamad
View All Reviews

MCTS Certification
SQL Server 2005

 
  • SQL Server 2005: £800
  • Hands On Tutor Led
  • Free Books , VAT, Mock Exam Inc.
  • Max 10 Per Class (check our facilities)
  • Re-sit Exam Fee Guarantee
  • or Call 0207 392 9696
 

MCTS: SQL Server 2005

Course Explanation

With Microsoft SQL server database technology growing by leaps and bounds there is an increasing demand for Microsoft Certified Technology Specialists. The MCTS SQL server 2005 course enables you to create databases and database files, use XML-related features in Microsoft SQL Server 2005, Plan, create, and optimize indexes, etc.

If you choose to be a specialist in database management as administrators and developers, then this is the course for you. You get first hands-on training in Implement data integrity in Microsoft SQL Server 2005 databases using constraints, triggers, and XML schemas. You can also configure Database Mirroring, monitoring the SQL Server, overview of replication scenarios, while viewing your current activity. So if you choose to be an excellent business intelligence developer or a database administrator, then MCTS SQL 2005 is the course for you.
Microsoft IT Academy

Certification Exam Code
70–431 Microsoft SQL Server 2005—Implementation and Maintenance

 

Course Contents (10 sessions of 3hrs each)

Day 1
3 hrs 		Exam 70-431 Microsoft SQL Server 2005-Implementation and Maintenance

Create databases and database files.
• Create databases.
• Create filegroups.
• Create schemas.
• Create database snapshots.

Create data types and tables.
• Creating Data Types.
• Creating Tables.
• Creating Partitioned Tables.
Day 2
3 hrs

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.

Plan, create, and optimize indexes.
• Planning Indexes.
• Creating Indexes.
• Optimizing Indexes.
• Creating XML Indexes.
Day 3
3 hrs

Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas.
• Creating Constraints.
• Creating Triggers.
• Implementing XML Schemas.

Implement views.
• Creating Views.
• Creating Indexed Views.
• Creating Partitioned Views.

Implement stored procedures and functions.
• Creating Stored Procedures.
• Creating Functions.
Day 4
3 hrs

Implement managed code in the database.
• Importing an Assembly.
• Creating Managed Database Objects.

Use Service Broker to build a messaging-based solution.
• Creating Service Broker Objects.
• Implementing the Initiating Service.
• Implementing the Target Service.

Install and configure SQL Server 2005.
• Preparing to install SQL Server.
• Installing SQL Server.
• Managing a SQL Server 2005 Installation.
Day 5
3 hrs

Manage database files.
• Planning databases.
• Creating databases.
• Managing databases.

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.
Day 6
3 hrs

Perform administrative tasks.
• Configuring the SQL Server Agent.
• Creating Operators and Jobs.
• Creating Alerts.

Automating Administrative Tasks
• Automating Administrative Tasks in SQL Server 2005.
• Configuring the SQL Server Agent.
• Creating Jobs and Operators.
• Creating Alerts.
• Managing Multiple Servers.
• Managing SQL Server Agent Security
Day 7
3 hrs

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

Database Backup Recovery
• Back up databases.
• Restore databases.
Day 8
3 hrs

Monitor SQL Server.
• Viewing Current Activity.
• Using System Monitor.
• Using SQL Server Profiler.
• Using DDL Triggers.
• Using Event Notifications.
Day 9
3 hrs 		Transfer data.
• Create an SSIS Package.
• Deploying an SSIS Package.
Day 10
3 hrs 		Introduction to Replication
• Overview of Replication.
• Replication Scenarios.
• Creating a Publication.
• Creating a Subscription.
After Course Free Lab Access
Copyright © 2008 LSCE London (UK). All rights reserved.