MCDBA Self-Paced Learning
- Preparation for the four exams needed to obtain the MCDBA certification
- Whole courses consisting of SQL Server 2000 Implementing Database Design, SQL Server 2000
Administration, Windows Server 2003 Managing a Network Environment, and Windows Server 2003 Planning Network Infrastructure included
What's included?
- Each interactive vignette includes a pre-test to help you assess your current knowledge level
- Post-tests help evaluate your individual comprehension of the course and help you master each skill to help further preparation and achievement level
- Each vignette for the course also includes labs which allow hands on experimentation of what was just learned- such labs show relevance in real world scenarios
- Labs include hands-on skill sets that allow the user to feel comfortable and learn at their own pace without intimidation or feel of competition
- Glossaries included in the interactive medium are continuously available to reference course associated terms and help differentiate one meaning from another
- Course outlines provided for each section in PDF form act as study material and easy user reference guide
- Links to other web resources and outside documents included within the actual interface help supply additional information on the core topic to help further the knowledge of the user- as far as the mind wants to go!
Required Microsoft Exam Preparation
Preparation for the following four required Microsoft exams:
- 70-228 Installing, Configuring, and Administering Microsoft SQL Server 2000 Enterprise Edition
- 70-229 Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition
- 70-290 - Managing and Maintaining a Microsoft Windows Server 2003 Environment
- 70-291 - Implementing, Managing, and Maintaining a Microsoft Windows Server 2003 Network Infrastructure
Sample Course Objectives
SQL Server 2000 Administration
Session 1
Section A: Introduction
Section B: Installation Options
Section C: Installation
Section D: Troubleshooting Installations
Section E: Upgrade from 6.5
Section F: Upgrade Methods
Section G: Server Security
Session 2
Section A: Database Security
Section B: Database Permissions
Section C: Creating Databases
Section D: Placing Database Files
Section E: Altering a Database
Session 3
Section A: Constraints
Section B: Foreign Key Constraints
Section C: Indexes
Section D: Index Maintenance
Section E: Stored Procedures
Session 4
Section A: Triggers
Section B: Views
Section C: Database Backup
Section D: Backup Transaction Logs
Section E: Filegroup & Optimize Backups
Session 5
Section A: Restore & Recovery
Section B: High Availability Solutions
Section C: Relocating Data
Section D: Replication Overview
Session 6
Section A: Types of Replication
Section B: Implementing Replication
Section C: Linked Servers
Section D: Server Automation
Session 7
Section A: Managing Automation
Section B: SQL Mail Integration
Section C: Monitoring SQL Server
Section D: Optimizing Database Performance
Section E: IIS Virtual Directory
SQL Server 2000 Implementing Database Design
Session 1
Section A: Introduction
Section B: Normalization
Section C: Creating a Database
Section D: Placing Database Files
Section E: Maintaining Databases
Section F: Basic SQL Data Types
Session 2
Section A: Advanced SQL Data Types
Section B: Creating a Table
Section C: Data Integrity Concepts
Section D: Data Integrity Implementation
Section E: Primary Key Constraint
Section F: Foreign Key Constraint
Session 3
Section A: Select Statement
Section B: Formatting Result Sets
Section C: Summarizing Data
Section D: Functions & Set Options
Section E: Inner Joins
Session 4
Section A: Outer Joins, Cross Joins & Unions
Section B: Subqueries
Section C: Insert, Delete & Update
Section D: Indexing
Section E: Indexes & Fillfactor
Section F: Indexes & Fragmentation
Session 5
Section A: Index Statistics
Section B: Query Optimization
Section C: SQL Profiler
Section D: Views
Section E: Linked Servers
Session 6
Section A: Indexed & Distributed Views
Section B: Programming SQL
Section C: Other Language Elements
Section D: Transactions
Section E: Locks & Lock Types
Session 7
Section A: Lock Manipulation
Section B: Cursors
Section C: Stored Procedures
Section D: User Defined Functions
Section E: After Triggers
Session 8
Section A: Instead-Of Triggers
Section B: Data Movement
Section C: Replication
Section D: Permissions & Roles
Section E: XML
Windows Server 2003 Managing a Network Environment
Session 1
Section A: Introduction
Section B: Installation
Section C: Upgrading Windows 2000
Section D: Hardware Support
Section E: Troubleshoot Hardware
Session 2
Section A: Server 2003
Section B: Basic Dynamic Volumes
Section C: Fault Tolerant Volumes
Section D: Managing Volumes
Section E: File Systems
Section F: Computer Accounts
Session 3
Section A: User Accounts
Section B: Advanced User Accounts
Section C: User Account Properties
Section D: User Profiles
Section E: Groups
Section F: Managing Groups
Session 4
Section A: NTFS Permissions
Section B: Share Permissions
Section C: NTFS Features
Section D: Printers
Section E: Windows Licensing
Section F: Software Update Services
Session 5
Section A: Remote Administration
Section B: Remote Desktop
Section C: Web Server
Section C: Web Server
Section E: Shadow Copies
Section F: Backup
Section G: Disaster Recovery Windows Server 2003 Planning Network Infrastructure
Session 1
Section A: Introduction
Section B: TCP/IP Networking
Section C: Network Availability
Section D: Network Performance
Section E: Planning for Growth
Section F: DHCP Planning
Section G: Troubleshooting
Session 2
Section A: Internet Connectivity
Section B: Network Address Translation
Section C: Internet Security & Acceleration
Section D: Enhancing ISA Server
Section E: Clustering Technologies
Section F: Planning RRAS
Session 3
Section A: RRAS Advanced Features
Section B: IP Troubleshooting
Section C: Secure Remote Access
Section D: RAS Authentication
Section E: Planning IPSec Policy
Section F: Planning IPSec Deployment
Session 4
Section A: IPSec Troubleshooting
Section B: DNS
Section C: Integrating DNS
Section D: Planning WINS
Section E: Security Design Process
Section F: Security Baseline
Session 5
Section A: Perimeter Security
Section B: Securing Public Servers
Section C: Authentication/Encryption
Section D: Certificates
Section E: CA Design
Section F: Planning for Administration
