Welcome to the e-Learning SQL Server 2005 MCTS 70-431 course powered by XYZ.co.uk. Classroom versions of this course are also available. If you would like us to host a e-Learning SQL Server 2005 MCTS 70-431 course at your premises, at a location, date and time of your choosing – then please complete this form.

e-Learning SQL Server 2005 MCTS 70-431

At eLearning.co.uk all of our courses are delivered online. This gives you the opportunity to study at your own pace and within your own time. Online learning allows you to study in the evenings, weekends, or even the odd hour during the day! With each course you will have full tutor and technical support available via the telephone and by e-mail – so you are not on your own by any means. This e-Learning SQL Server 2005 MCTS 70-431 course will award you with the same certification as the classroom version of this course – usually for a cheaper cost and with the additional benefit of flexible study times!

Once you’ve decided to go ahead and enrol on this e-Learning SQL Server 2005 MCTS 70-431 course, you will receive an e-mail shortly after containing your user name and password, receipt of payment and full course joining instructions. Use this with the link/url provided in the e-mail and you can log into the online training system and begin learning right away. This e-Learning SQL Server 2005 MCTS 70-431 online learning course will use various interactive features and different types of media to enable you to stay engaged whilst learning. The course has been designed to be simple to follow and solely with the user in mind – so don’t worry about the technical side of things.

If you want to learn a little more about e-Learning in general, watch the video below. If you want to know more about your chosen course, please scroll down.

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.

About the course

Installing and Configuring SQL Server 2005 - Duration 2 Hour(s)

• 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

Creating Databases - Duration 2 Hour(s)

• Create and alter databases Employ views for data query operations Use indexed views Use partitioned views

Working with Tables and Programmability Objects - Duration 3 Hour(s)

• Implementing a table Implementing triggers Implementing functions Implementing stored procedures Implementing constraints Implementing indexes

Implementing Database Objects - Duration 4 Hour(s)

• Perform queries that extract data Produce reports Insert, update, and remove data Use full-text queries Use system tables and views

Supporting the XML Framework - Duration 2 Hour(s)

• 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

Enhancing Data Consumption and Throughput - Duration 2 Hour(s)

• 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

Maintaining and Backing Up Databases - Duration 3 Hour(s)

• 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

Monitoring Performance - Duration 2 Hour(s)

• 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

Troubleshooting and Optimising - Duration 2 Hour(s)

• 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

Implementing High Availability - Duration 3 Hour(s)

• 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

Practice Exams -  Duration 1 Hour(s)

• This exam testing session provides practice questions for the SQL Server 2005 MCTS 70-431 exam.

Qualification

70-431

Course study options

Course Study Format
This course is delivered through online method. The course is available for you to complete at your convenience over a 12 month period.

IT Training Course Tutor Support
Home study courses include step by step online training and keyword search facilities.
Our Interactive online IT Training courses will take you step by step though your chosen eLearning courseware using show and ask training methods.

Study Hours
This is only an approximate figure and is dependent upon how much time you can dedicate to your studies and how well you grasp the learning concepts in the course material.

Technical Requirements

• Windows: Windows 98, 2000, XP, Vista, Windows 7 – Acrobat Reader 4.0 and above
  OR
  Macintosh: Mac OS X, Mac OS 9.2 – Acrobat Reader 4.0 and above
• An up to date internet browser such as Internet Explorer, Mozilla Firefox, or Safari.
• Internet connection (broadband recommended.)

Cost - Per Person

Make An Enquiry Or Book This Training Here