GCSE
A Level
AS/A2 Level
Child Care
Social Care
Health & Fitness
General Interest
Writing & Journalism
Animal Care
Business & Finance
CAT (Certified Accounting Technician)
Vocational
Web Design
CIW (Certified Internet Webmaster)
ACE (Adobe Certified Expert)
Desktop Computing
PC Repair / IT
Network / Telecoms
Microsoft
Online Courses
MCTS COURSE
Category: Microsoft

Spread the payments for this course over
4 monthly payments. 1 initial payment of £80,
followed by 3 monthly payments of £40.

The MCTS (Microsoft Certified Technology Specialist) 70-431 qualification in Microsoft SQL Server 2005 - Implementation and Maintenance validates proven expertise in administering, deploying, and maintaining Microsoft SQL Server 2005 or developing business process and integration solutions using BizTalk Server 2006.

Microsoft Certified Technology Specialists in Microsoft SQL Server 2005 (MCTS: SQL Server 2005) implement and maintain databases using specific instructions and specifications. They have thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and know how to explore the user interface.

The course will prepare students for Microsoft’s 70-431 exam (TS: Microsoft SQL Server 2005-Implementation and Maintenance). In addition, the course is appropriate for any person pursuing Database Administrator, Database Developer, or Business Intelligence Developer careers, or for any other persons who need a technical understanding of SQL Server 2005 features and implementation. The course comes with MeasureUp exam prep software.

Course Objectives:

  • Install SQL Server 2005.
  • Use SQL Server management tools.
  • Create and manage databases.
  • Develop a database design for data.
  • Create tables, constraints, and indexes.
  • Retrieve data from SQL Server 2005 databases.
  • Create programmable objects.
  • Manage data in a SQL Server 2005 database.
  • Support XML data in a SQL Server 2005 database.

Our MCTS 70-431 Certification Course Includes the Following Modules:-

  • Module 1 – SQL Server 2005 Installation

The following topics are covered in this lesson: SQL Server features; SQL Server installation; and Alternative installations.

  • Module 2 – SQL Server management tools

The following topics are covered in this lesson: SQL Server 2005 services; Management tools; SQL Server settings; and Database Mail.

  • Module 3 – Database Management

The following topics are covered in this lesson: SQL Server data storage; Database management; and Capacity planning and management.

  • Module 4 – Data Design

The following topics are covered in this lesson: The data design process; Table and data design; Data normalization; and Data types.

  • Module 5 – Table Restraints & Indexes

The following topics are covered in this lesson: Objects; Tables and constraints; and Indexes.

  • Module 6 – Data Retrieval

The following topics are covered in this lesson: Queries; Transact-SQL functions; Data organization; Multiple table queries Data modification; and Query Designer.

  • Module 7 – Programmable Objects

The following topics are covered in this lesson: Programming fundamentals; User views; Stored procedures; and User-defined functions.

  • Module 8 – Data Management

The following topics are covered in this lesson: Multiple language support; Full-text search; Partitions; Error handling; Transactions and locking; and Triggers.

  • Module 9 – XML Support

The following topics are covered in this lesson: XML fundamentals; The XML data type; XML methods and indexes; and XML & relational data integration.

  • Module 10 – Data Transfers

The following topics are covered in this lesson: Bulk transfers; SQL Server 2005 Integration Services; and XML import and export.

  • Lesson 11 – SQL Server Security

The following topics are covered in this lesson: Principles; Server securables; Database and schema securables; SQL auditing; Encryption; and CLR security.

  • Lesson 12 – Management & Maintenance

The following topics are covered in this lesson: SQL Server Agent; Distributed queries; and Replication.

  • Lesson 13 – SQL Server Administration

The following topics are covered in this lesson: Monitoring and optimization; Database optimization; Database tune-ups; and Query optimization concepts.

  • Lesson 14 – Reliability & Availability

The following topics are covered in this lesson: Database backup; Database restore; Log shipping; Database snapshots; and Mirrored databases.

  • Lesson 15 – Applications

The following topics are covered in this lesson: Service Broker; and HTTP endpoints.

  • Lesson 16 – Troubleshooting & Repair

The following topics are covered in this lesson: Blocks and deadlocks; SQL Server errors; and Recovery.

Course Prerequisites: MCP 70-290: Managing and Maintaining a Windows Server 2003 Environment.
 
Exam:
On completion of this Curriculum, you can apply for the Internationally Recognised MCP 70-431 examination. The examination fee is £88 +VAT.
 
You can find or register for your nearest exam centres from Prometric or Pearson Vue testing centres.

View Testimonials for MCTS COURSE
Submit a Testimonials for MCTS COURSE