Price:
£200.00
Format
Paper Based with CD Roms
Approx Time
120 Hours
|
|
MCP 70-228 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 Microsoft Certified Professional 70-228 course is appropriate for anyone who will be installing and managing SQL Server 2000. This includes implementations in small LANs, large enterprises, or any environment in between. It will also be helpful for anyone with database administration, anyone managing SQL Server implementation, and anyone considering SQL Server as part of a business solution. This course can be used for preparation for Microsoft Exam 70-228: Installing, Configuring, and Administering Microsoft SQL Server™ 2000 Enterprise Edition.
Our unique distance learning training programme is delivered in Paper based and CD Rom materials and comes with an additional Examination Card displaying important information about the qualification and exams.
-
Paper Based Course Materials Covering Specific Microsoft Curriculum
-
Additional CD Rom Course Guide with Interactive Training
-
Specific MCP Qualification and Exam Card
-
The Course Includes Test Preparation Software
-
Only £200.00 inc P&P
Microsoft Certified Professionals (MCPs) receive the following benefits:
Our MCP 70-228 Certification Course Includes the Following Modules:-
- Module 1 – Getting Started with SQL Server 2000
The following topics are covered in this lesson: SQL Server introduction, SQL Server features, SQL Server installation, Special installation concerns and Database administration.
- Module 2 – Databases and Capacity Planning
The following topics are covered in this lesson: SQL Server organization and data storage, Database management and Capacity planning and management
- Module 3 – Database and object management
The following topics are covered in this lesson: Managing databases and Database object fundamentals.
- Module 4 – Data Management
The following topics are covered in this lesson: Data conversions, Bulk copy program (bcp) and BULK INSERT, INSERT, UPDATE, DELETE, and SELECT, Data Transformation Services (DTS) and Data migration planning.
- Module 5 – Backup, restore and fault tolerance
The following topics are covered in this lesson: Data security, Database backup, Database restore and Managing data security.
- Module 6 – Client configuration and management
The following topics are covered in this lesson: Network communications and XML Support.
- Module 7 – Security Management
The following topics are covered in this lesson: Server login and database user management, Security management and Security planning.
- Module 8 – Distributed data environment
The following topics are covered in this lesson: Nonlinked servers and Linked Servers.
- Module 9 – Replication Management
The following topics are covered in this lesson: Replication concepts, Publishing and distribution, Managing subscriptions and Replication planning and management.
- Module 10 – Ongoing Management
The following topics are covered in this lesson: SQL Mail, Automating management and SQL Server management.
- Module 11 – Monitoring and Observation
The following topics are covered in this lesson: Monitoring overview, Windows monitoring tools, SQL Server monitoring tools and Database optimization.
The following topics are covered in this lesson: Sample setup.iss and Project Goals.
- Appendix B – Additional Object References
The following topics are covered in this lesson: System Tables, System functions, Data types and precision storage and DBCC command statements.
Qualification/Exam:
On completion of this Curriculum, you can apply for the Internationally Recognised MCP 70-228 examination at any Authorized Prometric or Pearson Vue Testing Centre. 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 MCP 70-228 COURSE
Submit a Testimonials for MCP 70-228 COURSE
|
