Need some help?
Name Name
Contact Number Contact Number 1
Contact Number Contact Number 2
e-mail e-mail
Basic/ Office Courses
View Basic to Advanced Computer Training Courses
CompTIA Courses
View CompTIA Training Courses
Microsoft Courses
View Technical Microsoft Training Courses
Cisco Courses
View Cisco Training Courses
Web Design Courses
View Web Design Training Courses
Other IT Courses
View all other IT Training Courses

SQL Server 2005 MCTS 70-431 Training Online Course

    SQL Server 2005 MCTS 70-431 Training Online Course Total Time: 26 hour(s)

SQL Server 2005 MCTS 70-431 Training Online Course. Database administrators, developers and business intelligence developers can use this series to study for the Microsoft Certified Technology Specialist (MCTS) certification exam 70-431: Microsoft SQL Server 2005 Implementation and Maintenance. This online training covers all of the information needed to meet the exam objectives, and includes practice questions, simulations, and exercises to get plenty of practice for exam day.

Try A Free Demo
Live Labs Available
24/7 Tutor Available
Need help? Click Here
 
Buy SQL 2005 Server Training Free IT Training Demo Live Labs Tutor Support Contact e-careers computer training


SQL Server 2005 MCTS 70-431 Training Online Course Lessons:

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

  If you would like some advice on training or the special deals available then complete your details below.

Query

Telephone: 0871 222 8790

Alternate Number: 01279 814 876

Fax: 01279 816 093

E-Mail: info@e-careers.co.uk

Address:
10 Riverside Business Park,
Stony Common Road,
Stansted Mountfitchet,
Essex,
CM24 8PL

Career Training Helpline