ONLINE SQL Server 2005 MCTS 70-431 TRAINING FEATURES
Learn SQL Server 2005 MCTS 70-431 online with these interactive online SQL Server 2005 MCTS 70-431 courses.
Affordable Pricing (Only $99.95 for the complete series)
A full year to complete the SQL Server 2005 MCTS 70-431 courses
Retake the SQL Server 2005 MCTS 70-431 courses as many times as you like
Measure your progress with assessment tests after each course
Earn completion certificates after passing each assessment test
1. SQL Server 2005 MCTS 70-431:1 Installing and Configuring SQL Server 2005
Time: 2 hours
This course explains how to prepare for the installation and configuration of SQL Server 2005.
Objectives
Evaluate your hardware and software requirements prior to installation
Install SQL Server 2005
Configure linked servers for use with SQL Server 2005
Establish login security
Topics
Preparing for Installation
Installing SQL Server 2005
Postinstallation Procedures
SQL Server Login Security
2. SQL Server 2005 MCTS 70-431:2 Creating Databases
Time: 2 hours
This course explains how to use SQL Server 2005 to create databases and establish views you can employ to work with data.
Objectives
Create and alter databases
Employ views for data query operations
Use indexed views
Use partitioned views
Topics
Defining Databases
Views
Using Indexed Views
Using Partitioned Views
3. SQL Server 2005 MCTS 70-431:3 Working with Tables and Programmability Objects
Time: 3 hours
This course provides you with information concerning job skills tested by Microsoft Exam MCTS70-431.
Objectives
Implementing a table
Implementing triggers
Implementing functions
Implementing stored procedures
Implementing constraints
Implementing indexes
Topics
Table Basics
Column Attributes
Indexes
Primary and Foreign Keys
Cascading Actions and Triggers
Partitioned Tables
Implementing Partitioned Tables
Programmability Objects
Full-Text Searches
Security
4. SQL Server 2005 MCTS 70-431:4 Implementing Database Objects
Time: 4 hours
This course explains how to work with the data in database tables.
Objectives
Perform queries that extract data
Produce reports
Insert, update, and remove data
Use full-text queries
Use system tables and views
Topics
Listing Table Contents
Enhancing Reports
Querying Data
Conditional Data Filtering
Data Querying via Full-Text Indexes
Using System Tables and Stored Procedures
Using Views and Data Types
Inserting Records
Changing Stored Data
Removing Unwanted Data
5. SQL Server 2005 MCTS 70-431:5 Supporting the XML Framework
Time: 2 hours
This course explains how to manage the XML data and features that are integrated into SQL Server 2005.
Objectives
Recognize the importance of XML within a SQL Server database
Identify the new features and functionality for XML in SQL Server 2005
Describe how to output data in XML format
Use the xml data type
Explain methods associated with the xml data type
Create XML indexes
Topics
Managing XML data
Supported XML features
XML basics
The XML data type
XML method interactions
Other SQL Server XML support
6. SQL Server 2005 MCTS 70-431:6 Enhancing Data Consumption and Throughput
Time: 2 hours
This course explains how to move large amounts of data either within a single server or between servers. Bulk Copy Program (BCP) and SQL Server Integration Services (SSIS) are also discussed.
Objectives
Explain importing and exporting data with SQL Server 2005
Import and export data using the Bulk Copy Program (BCP)
Use OPENROWSET to access any OLE DB data source
Use SSIS to handle the import and export of data
Implement Service Broker
Assemble components into a service
Topics
Importing and Exporting Data
Using the Bulk Copy Program
Using OPENROWSET and SSIS
Implementing Service Broker
Assembling Components into a Service
7. SQL Server 2005 MCTS 70-431:7 Maintaining and Backing Up Databases
Time: 3 hours
This course explains how to use SQL Server 2005 to maintain and backup databases.
Objectives
Identify the new features in SQL Server database maintenance
Perform a database backup
Identify the various backup types
Use the T-SQL BACKUP statement
Restore data from a backup
Create a database snapshot
Automate maintenance with job scheduling
Topics
SQL Server Database Maintenance
Performing Database Backups
Backup Types
Using the T-SQL BACKUP Statement
Restoring Data from a Backup
Working with Database Snapshots
Automating Maintenance with Job Scheduling
8. SQL Server 2005 MCTS 70-431:8 Monitoring Performance
Time: 2 hours
This course explains how to monitor the performance of a SQL Server 2005 system.
Objectives
Describe monitoring tools used by SQL Server 2005
Identify the features of Log File Viewer
Describe the types of server-maintained information found in SQL Server 2005
List types of System Monitor counters
Define a SQL Profiler trace
Topics
SQL Server Management Studio
Using Activity Monitor
Working with Log File Viewer
Server-Maintained Information
Using Windows System Monitor
Working with SQL Server Profiler
Defining a Profiler Trace
9. SQL Server 2005 MCTS 70-431:9 Troubleshooting and Optimizing
Time: 2 hours
This course explains how to troubleshoot issues that may arise when using SQL Server 2005. It also provides information on optimizing SQL Server for the best performance.
Objectives
List the settings that affect statistics
Describe how SQL Server deals with multiple users
Discuss indexing strategies
Describe how partitioning can improve performance
List tools that assist with maintenance tasks
Topics
Tuning the Operating System and Hardware
Locks, Blocks, and Deadbolts
Indexing Strategies
Data Partitioning Across Servers
Working with the DTA
Using the Database Console Command
10. SQL Server 2005 MCTS 70-431:10 Implementing High Availability
Time: 3 hours
This course explains how to implement high-availability solutions such as log shipping, database mirroring, failover clusters, and replication.
Objectives
Describe the costs and risks involved in certain high-availability solutions
Implement log shipping and explain how it operates
Enable database mirroring using trace flags and use failover clustering
Discuss the strategies, types, and elements of replication
Explain Microsoft Analysis Services in SQL Server 2005
Topics
High-availability solutions
Implementing log shipping
Database mirroring and failover clustering
Replication strategies
Types of replication
Elements of replication
Microsoft analysis services
11. SQL Server 2005 MCTS 70-431:11 Practice Exams
Time: 1 hours
This course provides practice questions for the SQL Server 2005 MCTS 70-431 exam.
Objectives
Complete the first set of practice exam questions.
Complete the second set of practice exam questions.
Topics
Practice Exam 1
Practice Exam 2
Resources for SQL Server 2005 MCTS 70-431
Microsoft SSAS Training - Webucator provides onsite and instructor-led online SQL Server Analysis Services training.
Know of a good resource for SQL Server 2005 MCTS 70-431 Online Training? Please Let Us Know.
