Microsoft MCTS SQL 2005 70-431 Implementation and Maintenance Certification Training
 Description
Exam 70-431: MCTS Certification: Microsoft SQL Server 2005—Implementation and Maintenance became available January 30, 2006. This is a Microsoft Certified Technology Specialist (MCTS)
certification exam.This certification helps professionals target specific technologies and distinguish themselves by demonstrating in-depth knowledge and expertise in their specialized technologies.
Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement have extensive knowledge of the product, understand how to use the tools and
Transact-SQL language, and know how to explore the user interface. Technology Specialists generally become database administrators, developers, or business intelligence developers.
Audience Profile
Candidates for this exam are professionals who typically pursue careers as database administrators, database developers or business intelligence developers. Additionally, they can
be people who do not work with Microsoft SQL Server as a part of their primary job functions, but who want to show their breadth of technology experience, such as developers, systems
administrators, and others. This course also greatly benefits people who do not work with Microsoft SQL Server as part of their primary job role, but want to show their depth of technology
experience, such as systems administrators, developers and many others. This also shows that you have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance your
technical expertise, and you can implement and maintain databases by using specific instructions and specifications
SQL Course Outline Implementing a Microsoft SQL Server 2005 Database
 It is recommended that students have the following
knowledge and/or experience prerequisites before taking this training course:
- Tools Usage
- UI Navigation
- Wizards usage
- Writing code in the appropriate language (Transact-SQL, CLR, etc)
- Code debugging or syntactic issue resolution
- Troubleshooting
- Use code or UI Navigation to accomplish specific tasks
- Basic Knowledge of the Microsoft Windows operating systems
- Working Knowledge of Transact-SQL
- Working Knowledge of relational databases
- Some experience with database design
 Audience
This course also greatly benefits people who do not work with Microsoft SQL Server as part of their primary job role, but want to show their depth of technology experience, such as systems
administrators, developers and many others. This also shows that you have sought out knowledge and experience with Microsoft SQL Server 2005 to enhance your technical expertise, and you can
implement and maintain databases by using specific instructions and specifications
Our Training Course
- Full multi-media interactive training
- Available in CD-ROM or Online formats
- Learn at your own pace, anytime or anywhere
- Course time: 20 Hours
- Hands on interactive exercises
|
Online MCTS Microsoft SQL 70-431 Course One Year Access with Books
|
$495.00
|
sp431cd
|
|
|
CD-ROM MCTS Microsoft SQL 70-431 Course with Books
|
$495.00
|
sp431on
|
|
|
Online MCITP Certification Track Microsoft SQL 70-431, 70-441 and 70-442 courses with Books
|
$1195.00
|
spmcipton
|
|
|
CD-ROM MCITP Certification Track Microsoft SQL 70-431, 70-441 and 70-442 courses with Books
|
$1195.00
|
spmcipton
|
|
Implementing and Maintaining a Microsoft SQL Server 2005 Database Exam 70-431 Course
Certification Training Course Content
Implementating a Microsoft SQL Database
Module-1 Creating Databases and Database Files
Creating Databases.
Creating Filegroups.
Creating Schemas.
Creating Database Snapshots
Module-2 Creating Data Types and Tables
Creating Data Types.
Creating Tables.
Creating Partitioned Tables.
Module-3 Using XML
Retrieving XML by Using FOR XML
Shredding XML by Using OPENXML
Using the xml Data Type
Module-4 Creating and Tuning Indexes
Planning Indexes
Creating Indexes
Optimizing Indexes
Creating XML Indexes
Module-5 Implementing Data Integrity
Data Integrity Overview
Implementing Constraints
Implementing Triggers
Implementing XML Schemas
Module-6 Implementing Views
Introduction to Views
Creating and Managing Views
Optimizing Performance by Using Views
Module-7 Implementing Stored Procedures and Functions
Implementing Stored Procedures
Creating Parameterized Stored Procedures
Creating Functions
Handling Errors
Controlling Execution Context
Module-8 Implementing Managed Code in the Database
Introduction to the SQL Server Common Language Runtime
Importing and Configuring Assemblies
Creating Managed Database Objects
Module-9 Using Service Broker
Service Broker Overview
Creating Service Broker Objects
Sending and Receiving Messages
Maintaining A Microsoft SQL 2005 Database
Module-1 Installing and Configuring SQL Server 2005
Preparing to install SQL Server
Installing SQL Server
Managing a SQL Server 2005 Installation
Module-2 Managing Databases and Filess
Planning databases
Creating databases
Managing databases
Module-3 Disaster Recovery
Planning a Backup Strategy
Backing Up User Databases
Restoring User Databases
Recovering Data from Database Snapshots
System Database and Disaster Recovery
Module-4 Managing Security
Overview of SQL Server Security
Securing the Server Scope
Securing the Database Scope
Managing Keys and Certificates in SQL Server
Module-5 Monitoring SQL Server
Viewing Current Activity
Using System Monitor
Using SQL Server Profiler
Using DDL Triggers
Using Event Notifications
Module-6 Transferring Data
Overview of Data Transfer
Introduction to SQL Server Integration Services
Using SQL Server Integration Services
Module-7 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
Module-8 Maintaining High Availability
Introduction to High Availability
Implementing Server Clustering
Implementing Database Mirroring
Implementing Log Shipping
Module-9 Introduction to Replication
Overview of Replication
Replication Scenarios
|
