Microsoft Certified Database Administrator (MCDBA)

*Eligibility criteria applies.

Free IT courses, Microsoft, CISCO and PC Maintenance Certification

Presently we have funds to cover 50 employed people to take IT courses from us.
These courses will take you to a Microsoft or CISCO or PC Maintenance certification.

If you are not employed you can also call the number below and ask about available courses.

Requirements:

• You have to be employed full time or part time, working at any place with less than 5,000 employees in any position.
• Your employer has to agree that you can take the course.
• You have to have basic IT skills and an interest in learning.

During the course you will have to come twice a week to Selby Centre in Tottenham, Haringey.
The classes will be held in the evenings and on weekends so there will be no interruption on your job.*

If you are NOT a UK or EU citizen please check your entry visa page in your passport: If “NO RECOURSE TO PUBLIC FUNDS” is stamped in we can not offer you a free course but you can still take our course by paying the fee.

Curriculum
Certificate Requirements

To earn a Microsoft Certified Database Administrator (MCDBA) certificate, you must complete 1 required course containing the following learning modules:

MOC2151 – Windows 2000 Network and Operating System Essentials
Introduction to Windows 2000 and Networking

• Administration of a Windows 2000 Networks
• Securing a Windows 2000 Network
• Examining the Network
• Examining Network Protocols
• Examining TCP/IP
• Examining IP Addressing
• Optimizing IP Address Allocation
• Examining Web Services

MOC2152 – Implementing Windows Professional Server

• Installing or Upgrading to Windows 2000
• Configuring the Windows 2000 Environment
• Connecting Windows 2000 based Clients to Network
• Creating and Managing User Accounts
• Managing Access to Resources by Using Groups
• Managing Data by Using NTFS
• Providing Network Access to File Resources
• Monitoring and Optimizing Performance in Windows 2000
• Implementing Security in Windows 2000
• Configuring Printing
• Configuring Windows 2000 for Mobile Computing
• Configuring and Managing Disks
• Implementing Disaster Protection
• Installing and Configuring Terminal Services
• Implementing Windows 2000 Clients
• Implementing Windows 2000- based Servers

MOC2072 – Administrating a Microsoft SQL Server 2000 Database

• SQL Server Overview
• Planning To Install SQL Server
• Managing Database Files
• Managing Security
• Performing Administrative Tasks
• Backing up Databases
• Restoring Databases
• Monitoring SQL Server for Performance
• Transferring Data
• Maintaining High Availability
• Introducing Replication

MOC2073 – Programming a Microsoft SQL Server 2000 Database

• SQL Server Overview
• Overview of Programming SQL Server
• Creating and Managing Databases
• Introduction to Data Structures
• Creating Data Types and Tables
• Implementing Data Integrity
• Planning Indexes
• Creating and Maintaining Indexes
• Implementing Views
• Implementing Stored Procedures
• Implementing User defined Functions
• Implementing Triggers
• Programming Across Multiple Servers
• Optimizing Query Performance
• Analyzing Queries
• Managing Transactions and Locks

MOC 2153 – Implementing A Network Infrastructure Using Windows 2000

• Introduction to the Microsoft Windows 2000 Networking Infrastructure
• Automating IP Address Assignment Using DHCP
• Implementing Name Resolution by Using DHCP
• Implementing by Name Resolution by Using WINS
• Configuring Network Security by Using Public Key Infrastructure
• Configuring Network Security by Using IPSEC
• Configuring Remote Access
• Supporting Remote Access to a Network
• Extending Remote Access Capabilities by Using IAS
• Configuring a Windows 2000 based Server as a Router
• Configuring Internet Access for a Network
• Configuring a Web Server
• Deploying Windows 2000 Professional by Using RIS
• Managing a Windows 2000 Network
• Troubleshooting Windows 2000 Network Service
• Configuring Network connectivity between Operating Systems