Microsoft SQL Server 2000

Microsoft SQL Server 2000 is Microsoft's most scalable, reliable, and high performing RDBMS (Relational Database Management System) to date.

We have two certified courses:
Installing, Configuring, and Administering Microsoft SQL Server 2000 Exam: 70-228
and Designing and Implementing Databases with Microsoft SQL Server 2000 Exam: 70-229 successful completion of both or either will gain you a MCP (Microsoft Certified Professional) credit, which you can use towards becoming a MCSE, MCSA, MCDBA.

Installing, Configuring, and Administering Microsoft SQL Server™ 2000

This course includes two days of Instructor Led tuition, a Microsoft certified Study Guide from Sybex Press and NETg exam preparation software. You will also be given practical test sessions to simulate real database solutions.

Once you have completed the course, you will then take Exam: 70-228. Trainers will be available in classrooms at all times is you need assistance.

Syllabus
Introduction to SQL Server 2000 and Relational Databases.
Installing Upgrading and Configuring SQL Server 2000
SQL Server Tools Utilities and Queries
Planning, Creating, and Managing a Database in SQL Server 2000.
Security and SQL Server 2000
Implementing Database Backups and Restorations
Managing your Data
Implementing Proactive Administration and IIS support in SQL Server 2000
Creating and Implementing a Replication Solution in SQL Server 2000
Monitoring and Optimizing SQL Server 2000

Prerequisites	Experience in using a Database program, such as Microsoft Access
Study Mode	Scheduled
Duration	2 days of lectures + 50 hours practical
Start date	20th Feb 06
Fees	£355

Want to do this course? Please contact our enrolment office, or book online.

back to top

Designing and Implementing Databases with Microsoft SQL Server 2000

This course includes two days of Instructor Led tuition, a Microsoft certified Study Guide from Sybex Press and NETg exam preparation software. You will also be given practical test sessions to simulate real database solutions.

Once you have completed the course, you will then take Exam: 70-229. Trainers will be available in classrooms at all times if you need assistance.

Syllabus
Database Logical Modelling
Database Physical Modelling
Creating and Maintaining Tables
Implementing Data Integrity
Creating and Maintaining Indexes
Creating and Maintaining Database Objects
Accessing Data
Modifying Data
Importing and Exporting Data
Locking
Developing a security Plan
Analyzing and Optimzing Data Access

Prerequisites	Experience in using a Database program, such as Microsoft Access
Study Mode	Scheduled
Duration	2 days of lectures + 50 hours practical
Start date	22th Feb 06
Fees	£355

Want to do this course? Please contact our enrolment office, or book online.

back to top

Oxford House Computer Training is a BS EN ISO 9001:2000 approved Education, Training and IT Services Company (Certificate Number: GB 8898)