database administrator course database administrator courses database administration courses certified internet webmaster training administrator courses microsoft word for beginners database administration course network administrator course microsoft office courses microsoft access course objectives

Homepage › IT, Computing, Telecommunications Courses › Operating Systems Courses › Windows 2000 and XP Courses

Microsoft Certified Database Administrator (MCDBA)

in 5E Ltd (England)

Classes Degree

Place:

Haringey

Price:

Free Course

Special offers/ funding

Free courses as long as funding is available.

Price details

Free, funded courses as long as we have funding available.

Special offers

Duration:

4 Months

Start:

23/01/2009 other dates
See course programme

Requirements:

Admission to the Microsoft Certified Database Administrator (MCBDA) program is restricted to students ... see more

Course objectives:

Program Objectives To give graduates the ability to describe SQL Server architecture, plan for a SQL Server installation and install an instance of SQL Server. To give graduates skill in monitoring and optimizing SQL Server performance and maintaining high availability. To provide graduates expertise in configuring login security, planning and implementing database permissions

See course programme
Course details
venues and dates
Course alerts similar to these

More courses Subject area

Place

Request information

Contact directly and with no obligation with

5E Ltd

You must complete all fields on this form in order for us to send it to the course provider.
We have highlighted incomplete/ incorrect details in red.

* Compulsory fields

*Name *Surname

*E-mail

*Country/ region *Area/ County

*I would like more information on

By clicking "Email request / Telephone" you registering and accepting the Terms of Use and privacy policy of Emagister.

I wish to receive the personalised newsletter (during a maximum period of 15 days)

Availability?
How do I enrol?
Where can I get more information?

The person in charge of this course will receive your information request instantly.

Response time:

:| :) ;)

Average Fast Very fast

Course details

Type Degree Duration 4 Months

Method / place Contact course provider Inhouse / Classes in Haringey where

Students per class 12

Suitability Individuals who seek the skills necessary to lead organizations in the successful design, implementation and administration of SQL Server databases. Individuals who seek to increase their marketability for positions as database administrators, database analysts, database developers and other related technical positions.

Course objectives Program Objectives To give graduates the ability to describe SQL Server architecture, plan for a SQL Server installation and install an instance of SQL Server. To give graduates skill in monitoring and optimizing SQL Server performance and maintaining high availability. To provide graduates expertise in configuring login security, planning and implementing database permissions

Requirements	Admission to the Microsoft Certified Database Administrator (MCBDA) program is restricted to students who have six to 12 months of experience working with a desktop operating system. see more

Price	Free Course Special offer + Price details Free courses as long as funding is available. Price details Free, funded courses as long as we have funding available. Request this special offer here

back
Course programme
ex-students and opinions

Get direct information on how to enrol, venues and availability...

Windows 2000 and XP courses (from other course providers)

Microsoft Windows XP Beginners
Office-Training
Distance - £65 + VAT

Microsoft Certified Systems Administrator (MCSA)
The Business Develpoment Academy
London - Price: On request

Supporting Users Running the Microsoft Windows XP Operating System - (Microsoft Training Course: 2261)
F1 Computing Systems
London - £1,050 + VAT

Supporting Users Running the Microsoft Windows XP Operating System
PPi Learning Services
London - £995 + VAT

MS Windows XP Advanced
Macresource Computer Training
London - £245 + VAT

Compare the selected courses

+ windows 2000 and xp Courses + Windows 2000 and XP Courses in London + Courses in London + 5E Ltd Courses

Course programme

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified Database Administrator (MCDBA)

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

see the full course programme

back
more information
ex-students and opinions

on request

get more information on the programme directly from 5E Ltd.

Request information for free

Get direct information on how to enrol, venues and availability...

Venues and dates


Where	Haringey, Selby Centre, Selby Road
When	Start: 23/01/2009 Finish: 24/04/2009 See calendar

Where	Haringey, Selby Centre, Selby Road
When	Start: 23/12/2008 Finish: 20/03/2009 See calendar

Get direct information on how to enrol, venues and availability...

Ex-students

back
Course programme
more information

Opinions

Have you attended this course?

Voice your opinion and help thousands of other users

opinions

from users who have attended
this course.

Get direct information on how to enrol, venues and availability...

On 5E Ltd

Provider description

FREE 40+ NVQ COURSES FREE IT COURSES FREE TRAIN TO GAIN COURSES

Health Care, ITQ, Accounting, Customer Service, Management, Literacy and Numeracy and many more courses are available presently.
You have to meet the criteria to qualify for a free course.
300+ online courses.

Employed OR unemployed: Contact us!

• 5 E has been accredited by
- Oxford Cambridge RSA (OCR)
- City & Guilds
- NCFE
- Comptia
- Microsoft Office Specialst (MOS)
- Microsoft Office Partner
- Institute of Leadership & Management (ILM)
- British Computer Society (BCS)
- CISCO

• 5 E is an Testing Centre for
- Thompson Prometrics Test Centre
- Pearson Vue
- Wall Garden Test Centre – City & Guilds
- Electric Paper – British Computer Society
- Skills for Life – City & Guilds

Advantages of studying with 5E Ltd

We have seven locations to serve you: Haringey (4 locations): Selby Centre, Selby Road N17 8JL Tel: 07942 754959 Barnet, Colindale Enfield, Edmonton Redbridge, Ilford

Course provider history

5 E Ltd is a not for profit training provider based in North London, covering the boroughs of Haringey, Enfield, Barnet and Redbridge and has been established since 1998. 5 E Ltd has over 9 years experience of successfully delivering projects for Government Office London, London Development Agency, Department of Work & Pensions and Jobcentre Plus (Deprived Area Funding), Learning and Skills Council, European Refugee Fund, European Social Funds, Local Authority (Haringey & Enfield Councils), Single Regeneration Budget, Urban Futures, Upper Lee Valley Partnership (ULVP), European Regional Development Funds, North Central London Strategic Health Authority, The Selby Trust, Nextsteps and other funding bodies.

Specialises in

The organisation has an average throughput of 10,000 clients per year being assisted through the following service provisions: IAG, Assessment and Action Planning, Skills for Life, ICT, basic skills (5 Levels QCA/ Literacy/Numeracy Levels 1 & 2), ESOL (including occupational and embedded ESOL), numeracy/literacy, vocational training, Learn Direct and specialist ICT provision, application, software and hardware, integrated employability, sector specific basic skills, Health and Safety, Food Hygiene, Customer Service, Retail and others modules customized for specific vocational areas, communication and business English, multimedia and PC Maintenance, customer services, business administration, management and leadership, employability training, mentoring, work experience, volunteering, job brokerage, referrals and in work support Pre-employment training and support into/post employment support, Workforce development options and business support to SME’s.