"it training in london ,it training london ,it schools in london ,it professional courses in london ,computer networking london ,networking infrastructure training ,microsoft networking course ,it training courses uk ,it career training uk ,it training providers ,microsoft office course,sage line 50 training ,autocad training course ,autocad training london ,graphics design training ,acca training courses ,acca course ,acca course uk ,acca tuition providers ,ccna training course ,ccna certification training ,ccna course in london ,java certification ,computer programming courses ,mcad training course ,mcts training courses ,it training course ,it project certification,professional it courses , www.londonoxbridgecollege.com"

Oxbridge College offers wide range of services and high quality IT, Management & Accountancy certification courses with hands-on, tutor led training in the heart of the City of London

MCTS SQL Server 2005 Certification

£750

Description:

The Microsoft Certified Technology Specialist SQL server course enables you to create databases and database files, partition tables; use XML related features, implantation of data integrity & constraints, indexes and many more features.

This course creates excellent business intelligence developer and database administrator in you. If you think you need this qualification then this course is for you.

There is only one certification exam to become MCTS SQL Server Certified after completion of the course.

Certification Exam:

70–431 Microsoft SQL Server 2005—Implementation and Maintenance

Course Contents:

1. Exam 70-431 Microsoft SQL Server 2005-Implementation and Maintenance	2. Use XML-related features in Microsoft SQL Server 2005
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.	• 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.
3. Implement data integrity in Microsoft SQL Server 2005 databases by using constraints, triggers, and XML schemas	4. Implement managed code in the database
• 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.	• 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.
5. Manage database files	6. Perform administrative tasks
• 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	• 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
7. Configuring Database Mirroring	8..Monitor SQL Server
• 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.	• Viewing Current Activity. • Using System Monitor. • Using SQL Server Profiler. • Using DDL Triggers. • Using Event Notifications.
9. Transfer data	10..Introduction to Replication
• Create an SSIS Package. • Deploying an SSIS Package.	• Overview of Replication. • Replication Scenarios. • Creating a Publication. • Creating a Subscription.

Enquiry / Registration

020 7729 1152

info@londonoxbridgecollege.com

Course Includes

5 Week Course
10 Classes, 3hr each
Hands-On, Tutor Led
Small class size
Books Included
Mock Exams
Extra Practical hours

Brochure Request