MCDBA - Microsoft Certified Database Administrator

I-World Technology Sdn Bhd
Johor Bahru, Kuala Lumpur, Petaling Jaya, Penang, Malaysia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' The Microsoft Certified Database Administrator (MCDBA) on Microsoft SQL Server 2000 credential is the premier certification for professionals who implement and administer Microsoft SQL Server databases. The certification is appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure SQL Server.

The MCDBA on SQL Server 2000 Certification Is Appropriate For
Database Administrators
Database Analysts
Database Developers

By earning the premier MCDBA on SQL Server 2000 credential, individuals are demonstrating that they have the skills necessary to lead organizations in the successful design, implementation, and administration of SQL Server databases.

Course Duration:
72 Hours (Part-time or Fulltime available)

Who should attend:
student has Experience using the Microsoft Windows Server 2003 operating system, understanding of basic relational database conceepts, including logical and physical database design, and knowledge of basic Transact-SQL syntax (SELECT, UPDATE, and INSERT statements). Ideally be familiarity with the role of the database administrator.

Course modules:

70-290 Managing and Maintaining a Microsoft Windows Server 2003 Environment --- 18 Hours
Module 1: Introduction to Administering Accounts and Resources
Module 2: Managing User and Computer Accounts
Module 3: Managing Groups
Module 4: Managing Access to Resources
Module 5: Implementing Printing
Module 6: Managing Printing
Module 7: Preparing to Monitor Server Performance
Module 8: Monitoring Server Performance
Module 9: Maintaining Device Drivers
Module 10: Managing Disks
Module 11: Managing Data Storage
Module 12: Managing Disaster Recovery
Module 13: Maintaining Software by Using Microsoft Software Update Services

70-293 Planning and Maintaining a Microsoft Windows Server 2003 Network Infrastructure --- 18 Hours
Module 1: Introducing Windows Server 2003 Network Infrastructure Planning, Tools, and Documentation
Module 2: Planning and Optimizing a TCP/IP Physical and Logical Network
Module 3: Planning and Troubleshooting Routing
Module 4: Planning a DHCP Strategy
Module 5: Optimizing and Troubleshooting DHCP
Module 6: Planning a DNS Strategy
Module 7: Optimizing and Troubleshooting DNS
Module 8: Planning and Optimizing WINS
Module 9: Planning and Troubleshooting IPSec
Module 10: Planning Network Access
Module 11: Troubleshooting Network Access
Module 12: Preparing for the Course Lab

70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
Module 1: Overview of Programming SQL Server
Module 2: Creating and Managing Database
Module 3: Creating Data Types And Tables
Module 4: Implementing Data Integrity
Module 5: Planning Indexes
Module 6: Creating and Maintaining Indexes
Module 7: Implementing Views
Module 8: Implementing Stored Procedures
Module 9: Implementing User-Defined Functions
Module 10: Implementing Triggers
Module 11: Programming Across Multiple Servers
Module 12: Optimizing Query Performance
Module 13: Performing Advance Query Analysis
Module 14: Managing Transactions and locks

70-228 Installing, Configuring, and Administering Microsoft SQL Server 200 Enterprise Edition --- 18 Hours
Module 1: SQL Server Overview
Module 2: Planning to Install SQL Server
Module 3: Managing Database Files
Module 4: Managing Security
Module 5: Performing Administrative Tasks
Module 6: Backing Up Databases
Module 7: Restoring Databases
Module 8: Monitoring SQL Server for Performance
Module 9: Transferring Data
Module 10: Maintaining High Availability
Module 11: Introducing Replication

...''

Phone:+603-2710 0038 (KL) / +603-7877 7505 (PJ) / +604-643 5343 (PG) / +607-226 8869 (JB)

School Address:

C-0-5, Block C, Megan Avenue II
Jalan Yap Kwan Seng
50450 Kuala Lumpur, Malaysia.

505, Block A4, Leisure Commerce Square
No. 9, Jalan PJS 8/9
46150 Petaling Jaya, Selangor, Malaysia.

1-2-18, Krystal Point II
Lebuh Bukit Kecil 6
11900 Bayan Lepas
Pulau Pinang, Malaysia.

Johor Bahru
18-01, Menara Landmark
80100 Johor Bahru
Johor, Malaysia.





Jobs & Resumes: Johor Bahru, Kuala Lumpur, Petaling Jaya, Penang
Houses & Roommates: Johor Bahru, Kuala Lumpur, Petaling Jaya, Penang
Travel Agencies: Kuala Lumpur,

Search other schools for MCDBA - Microsoft Certified Database Administrator training resources.

MCP - MS Exchange Server 2003 (Implementing & Managing)
MCTS - MS SQL 2005 (Implementing & Managing)
MCSA - Microsoft Certified System Associate (Server 2003)
MCSA - Microsoft Certified System Associate (Security Track)
MCSA - Microsoft Certified System Associate (Messaging Track)
MCSE - Microsoft Certified System Engineer (Server 2003)
CCNP - Cisco Certified Network Professional
CompTIA A+
CompTIA Network +
MS Word Essentials
MS Word Advanced
Access VBA Programming
Analyzing Financial Data with MS Excel
FrontPage
Powerpoint
MS Outlook
MS Access Advanced
MS Access Essentials

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.