MCTS 70-431 COURSE
Category:
Microsoft Courses
Course Format
Course Book with CD & Online Practice Exams
Approximate Study Time
100 Hours (Self Study)
|
Payment Options
You can spread the payments for this course
over 4 monthly payments.
Initial payment of £80.00
Followed by 3 monthly
payments of £40.00 |
Price:
£200.00
VAT Exempt
Approximate Delivery Time
1-2 Working Days (Courier Service) |
|
|
|
The Microsoft Certified Technology Specialist 70-431 (Microsoft SQL Server 2005 - Implementation and Maintenance) Course 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 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 the Microsoft 70-431 exam. 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.
PLEASE NOTE: The MCTS 70-431 Course is designed as a theory-based course but does contain all relevant information on how to complete practical exercises if you have the available equipment, software & resources available.
Benefits of MCP Certification:
-
Industry recognition of your knowledge with Microsoft products and technologies;
-
Access to technical and product information, through the MCP Secured site;
-
Invitations to Microsoft conferences, technical training sessions, and special events.; and
-
An MCP logo, certificate, transcript, wallet card, and lapel pin to identify you as an Microsoft Certified Professional (MCP) to colleagues or clients.
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.
The MCTS 70-431 Certification course consists of the following items:
- MCTS 70-431 Certification Course Book
The following Units are covered in the MCTS 70-431 Course Book:
- Unit 1 – SQL Server 2005 Installation
The following topics are covered in this Unit: SQL Server features; SQL Server installation; and Alternative installations.
- Unit 2 – SQL Server management tools
The following topics are covered in this Unit: SQL Server 2005 services; Management tools; SQL Server settings; and Database Mail.
- Unit 3 – Database Management
The following topics are covered in this Unit: SQL Server data storage; Database management; and Capacity planning and management.
The following topics are covered in this Unit: The data design process; Table and data design; Data normalization; and Data types.
- Unit 5 – Table Restraints & Indexes
The following topics are covered in this Unit: Objects; Tables and constraints; and Indexes.
The following topics are covered in this Unit: Queries; Transact-SQL functions; Data organization; Multiple table queries Data modification; and Query Designer.
- Unit 7 – Programmable Objects
The following topics are covered in this Unit: Programming fundamentals; User views; Stored procedures; and User-defined functions.
The following topics are covered in this Unit: Multiple language support; Full-text search; Partitions; Error handling; Transactions and locking; and Triggers.
The following topics are covered in this Unit: XML fundamentals; The XML data type; XML methods and indexes; and XML & relational data integration.
The following topics are covered in this Unit: Bulk transfers; SQL Server 2005 Integration Services; and XML import and export.
- Unit 11 – SQL Server Security
The following topics are covered in this Unit: Principles; Server securables; Database and schema securables; SQL auditing; Encryption; and CLR security.
- Unit 12 – Management & Maintenance
The following topics are covered in this Unit: SQL Server Agent; Distributed queries; and Replication.
- Unit 13 – SQL Server Administration
The following topics are covered in this Unit: Monitoring and optimization; Database optimization; Database tune-ups; and Query optimization concepts.
- Unit 14 – Reliability & Availability
The following topics are covered in this Unit: Database backup; Database restore; Log shipping; Database snapshots; and Mirrored databases.
The following topics are covered in this Unit: Service Broker; and HTTP endpoints.
- Unit 16 – Troubleshooting & Repair
The following topics are covered in this Unit: Blocks and deadlocks; SQL Server errors; and Recovery.
- MCTS 70-431 CD Rom MeasureUp Software
The MeasureUp Practice Tests prepare you to pass the certification exam and the exams of daily life on the job. Practice tests are written by industry experts in the subject matter. They work closely with certification providers to understand the exam objectives, participate in beta testing and take the exam themselves before creating new practice tests. MeasureUp's quality content and innovative technology have earned the prestigious credential of Microsoft Certified Practice Test Provider.
Pre-Requirements:
Students should be familiar with the use and working of Personal Computers and should ideally be certified to any of the following qualification levels:
-
CompTIA A+ and Network+
-
MCP Exam 70-290
To use the course materials in a practical nature you would be required to have the following software packages:
Course Duration & Support:
Students may register at any time. The courses are designed as self-study courses but if you have any problems you can email our email support. As the course is self study you can complete in as little or as long a time as you prefer, and we do not impose a cut-off date for study.
Assessment:
Assessment is from the Microsoft 70-431 Examination. Examinations are in a multiple choice/multiple answer format.
Qualification:
|
On Completion of the MCTS 70-431 Certification Courses, you can apply for the Microsoft 70-431 Examination.
Examinations must be sat at a registered Prometric testing centre and are currently £88.00 + VAT each.
You can locate testing centres and schedule appointments on their Website: Prometric. |
 |
View Testimonials for MCTS 70-431 COURSE
Submit a Testimonials for MCTS 70-431 COURSE
|
