Introduction SQL Server 2005 DBA Certificate & Real Project
 
Microsoft Certified IT Professional - Database Administrator (MCITP-DBA)
Course Outline
 
Part 1. Introduction (1 hr)
1.1. Benefits of Obtaining MCITP SQL Server 2005 DBA Certificate
1.2. MCITP SQL Server 2005 DBA Certificate Path
§ MCTS (Microsoft Certified Technology Specialist)
§ MCITP (Microsoft Certified IT Professional)
1.3. Exam 1: Designing a Database Infrastructure Using Microsoft SQL Server 2005 (70-443)
§ Microsoft’s requirements to pass the exam.
§ Course topics to cover the exam requirements.
§ Exercise and questions prepared for passing the exam.
1.4. Exam 2: Designing a Database Infrastructure Using Microsoft SQL Server 2005 (70-444)
§ Microsoft’s requirements to pass the exam.
§ Course topics to cover the exam requirements.
§ Exercise and questions prepared for passing the exam.
 
Part 2. Database Server Infrastructure (4 hrs)
       2.1. Database Server Size
       2.2. Processor and Memory Requirements
       2.3. Disk Subsystem
       2.4. Windows and SQL Server Versions
       2.5. Deployment
       2.6. Database Consolidation
 
Part 3. Security (8 hrs)
       3.1. Database Server Security
           - Security Overview
           - Business Security Needs
           - Group Policy
           - Traffic Encryption
           - Attack Surface Reduction
       3.2. Endpoints
           - Overview
           - TCP
           - HTTP
       3.3. Database Security Design
           - Instance Level Security
           - Database Level Security
           - Object Level Security
 
Part 4. High Availability (5 hrs)
       4.1. High Availability Plan
           - Database Availability Requirements
           - Database Storage
           - Migration
       4.2. Failover Clustering
           - Windows Clustering
           - SQL Server 2005 Failover Cluster Instances
       4.3. Database Mirroring
           - Overview
           - Initializing Database Mirroring
           - Failover and Failback
 
Part 5. Log Shipping and Replication (3 hrs)
       5.1. Log Shipping
           - Overview
           - Initializing Log Shipping
           - Failover and Failback
       5.2. Replication
           - Overview
           - Snapshot
           - Merge Replication
           - Transactional Replication
           - Failover and Failback
 
Part 6. Physical Database Design (5 hrs)
       6.1. Tables
       6.2. Filegroups
       6.3. Indexes
       6.4. Views
       6.5. Procedures and Functions
       6.6. Database Conventions
 
Part 7. Recovery and Archive (3 hrs)
       7.1. Data Recovery Needs
       7.2. Backup Types
       7.3. Database Recovery
       7.4. Backup Media
       7.5. Data Archive Plan
       7.6. Partitions Archive
 
Part 8. Preparing for MCITP Exams (1 hr)
 
Project overview and environment setup
Course Outline 
 
  • Case 1. Installing SQL Server
- Installing new SQL Server 2000/2005 instances & ServicePack
  • Case 2. Migrating SQL Server 2000 to 2005.
- Moving database files
  • Case 3. Database creation
- Creating databases & tables
  • Case 4. Indexes
- Creating and adjusting indexes
  • Case 5. Views
- Designing and creating views & indexed views
  • Case 6. Monitoring databases & indexes
- Verifying files, locations, index parameters
  • Case 7. SQL Server Security
- Logins and their permissions
  • Case 8. Database Security
- Database users, Roles and Schemas
  • Case 9. Object Security
- Access permissions & object ownership
  • Case 10. Security Control
       - Manage permissions using stored procedures
  • Case 11. Encryption
- Encrypting data on columns
  • Case 12. Replication
       - Implement, verify & manage replication
  • Case 13. Working with data loading
- Bulk Insert and bcp
  • Case 14. Packages
- Data loading and extracting
  • Case 15. Backup
- Full, differential and transaction log backups 
 
  • Case 16. Recovery
- Restore backups
  • Case 17. High availability
- Auto Failover: Database Mirroring
  • Case 18. Configuring SQL Server Agent
- Database mail, jobs and alerts
  • Case 19. Monitoring SQL Server
- Activity Monitor, DMV/DMF & Profiler
  • Case 20. Disaster Recovery
- Setting up DR environment
  • Case 21. More Data Synchronization
- Implement, verify & manage log shipping
  • Case 22. More Performance Tuning
- Using Database engine Tuning Advisor
  • Case 23. Optimizing Query Performance
- Tuning queries (1) - Subquery
  • Case 24. Optimizing Query Performance
- Tuning queries (2) - Incorrect keyword
  • Case 25. Optimizing Query Performance
- Tuning queries (3) - Solving Table-Scan
  • Case 26. Optimizing Query Performance
- Tuning queries (4) - View
  • Case 27. Optimizing Query Performance
- Tuning queries (5) - Cursor
  • Case 28. Optimizing Query Performance
- Tuning queries (6) - Solving blocking
  • Case 29. Optimizing Query Performance
- Tuning queries (7) - Optimizing transactions
  • Case 30. Optimizing Query Performance
- Tuning queries (8) - Managing index
  • Case 31. More Database Maintenance (1)
- Shrinking database
  • Case 32. More Database Maintenance (2)
- Backup SQL Server system databases
  • Case 33. More Database Maintenance (3)
- Repair SQL Server from corruption
  • Case 34. More Database Maintenance (4)
- Managing tempdb
  • Case 35. More Database Maintenance (5)
- Linked server

More info button
(Let someone contact you) 

Share
Last update:. Visits -- | Web site design and hosting by WECAN.ca CMS