MICMCDBA01) Microsoft Certified Database Administrator (MCDBA) Windows 2000 Curriculum
Smartforce · SmartForce eBooks · 2000
From the Publisher: General Information Course Duration: 140 hours Audience: IT professionals including database administrators, application developers, independent software vendors, system integrators, Internet consultants and network administrators who want to become Microsoft Certified Database Administrators (MCDBA) Prerequisites: Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator Topics Covered Installation Administration Groups and Terminal Services Files and Folders Advanced File and Folder Hardware Configuration and Optimization Storage & Printing Events Backup & Recovery Network Protocols and Remote Access Group Policy Users Update: New Features and Architecture Addressing & Naming Services IP Routing Security Architecture and Features Fundamentals of Database Design Normalization and Physical Database Design Basic Transact SQL Creating Databases Data Integrity and Loading Techniques Indexes and Views Advanced Transact SQL Stored Procedures and Triggers Transactions and Distributed Data Monitoring and Optimizing Architecture and Features Installation Upgrading and Migration Creating Databases Data Integrity and Loading Techniques Indexes and Views Configuration and Systems Enhancement Backing Up Data Restoring and Managing Data Automating Administration Security Replication Monitoring and Optimizing Minimum Requirements to run SmartForce products: 486/33 processor or higher 8MB of RAM VGA display (256 colors recommended) 10-20MB of hard disk space DOS version 3.1 or higher Windows version 3.1/Windows 95 Supported Network Operating Systems: Novell NetWare 3.1x/4.1x Windows NT 3.51/4.0 OS/2 LAN Manager Banyan Vines Course Aim To prepare students for the exams required to become a MCDBA professional Learning Objectives After taking this course, the user should be able to: Provide students with the skills and knowledge to pass the follow exams required to become a MCBDA professional Exam 70-028 SQL Server 7.0 System Administration, exam 70-029 SQL Server 7.0 Database Implementation, exams 70-210/70-215 Implementing & Administering Windows 2000 Server and Professional, and exam 70-216: Implementing a Windows 2000 Network Infrastructure