1 Installing and Configuring SQL Server 2005
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
|
Duration 2 hours |
2 Creating Databases
Create and alter databases
Employ views for data query operations
Use indexed views
Use partitioned views
|
Duration 2 hours |
3 Working with Tables and Programmability Objects
Implementing a table
Implementing triggers
Implementing functions
Implementing stored procedures
Implementing constraints
Implementing indexes
|
Duration 3 hours |
4 Implementing Database Objects
Perform queries that extract data
Produce reports
Insert, update, and remove data
Use full-text queries
Use system tables and views
|
Duration 4 hours |
5 Supporting the XML Framework
Recognise 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
|
Duration 2 hours |
6 Enhancing Data Consumption and Throughput
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
|
Duration 2 hours |
7 Maintaining and Backing Up Databases
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
|
Duration 3 hours |
8 Monitoring Performance
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
|
Duration 2 hours |
9 Troubleshooting and Optimising
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
|
Duration 2 hours |
10 Implementing High Availability
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
|
Duration 3 hours |
11 Practice Exams
This exam testing session provides practice questions for the SQL Server 2005 MCTS 70-431 exam.
|
Duration 1 hours |
