Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Database Development

Course Overview

Focus on earning an MCTS SQL Server 2008 Database development certification on our intensive accelrated Microsoft MCTS track.

This Accelerated certification programmes provide you with everything you need to gain certification in a shortest time. Including:

• Course based on Microsoft Official Curriculum
• Extended delivery days - normally 8:30am - 6:00pm
• Practice tests taken with full support from your instructor
• Exam 70-433 TS: Microsoft SQL Server 2008, Database Development taken on the last day of the course
• Free exam re-test voucher should you fail your first attempt

Not sure whether this is the right Microsoft training course for you? Use our quick search bar to find the right Microsoft training course for you.

Related Courses

• Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Implementation and Maintenance
• MCTS: Microsoft SQL Server 2012, Implementation and Maintenance Power Camp
• MCTS: Microsoft SQL Server 2012, Business Intelligence Development and Maintenance

Audience

This course is intended for IT Professionals who administer and maintain SQL Server databases.

Prerequisites

Delegates should have experience in:-

• Knowledge of the Microsoft Windows operating system and its core functionality. (Use windows explorer / internet explorer (i.e. things like find web page , create a folder); Login (CTRL ALT DELETE); Start a service using services add-in. (administration tools); Use a mouse, start menu etc.)
• Working knowledge of Transact-SQL.
• Working knowledge of relational databases.
• Some experience with database design.

Course Outline

• Installing and Configuring SQL Server
• Managing Databases and Files
• Disaster Recovery
• Managing Security
• Transferring Data
• Automating Administrative Tasks
• Implementing Replication
• Maintaining High Availability
• Monitoring SQL Server
• Troubleshooting and Performance Tuning
• Creating Databases and Database Files
• Creating Data Types and Tables
• Creating and Tuning Indexes.
• Implementing Data Integrity by Using Constraints and Triggers
• Using XML
• Implementing Views.
• Implementing Stored Procedures
• Implementing Functions
• Implementing Managed Code in the Database
• Managing Transactions and Locks
• Using Service Broker

 

Microsoft Certified Technology Specialist (MCTS): SQL Server 2008 Database Development / MCTSSQDD

Request availability or enquire by clicking a date: