Introduction to SQL DBA Certificate

Free Reservation button

Duration: 30 Hours 

Microsoft Certified IT Professional - Database Administrator (MCITP-DBA)

Course Outline
 

1. Introduction

1.1. Benefits of Obtaining MCITP SQL Server 2008/2012/2014 DBA Certificate
1.2. MCITP SQL Server 2008/2012/2014 DBA Certificate Path
- MCTS (Microsoft Certified Technology Specialist)
- MCITP (Microsoft Certified IT Professional)
- Upgrade: Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008/2012/2014 DBA
1.3. MCTS: SQL Server 2008/2012/2014, Implementation and Maintenance (70-432)
- Working with SQL Server 2008/2012/2014 for database administrator tasks: installing, configuring & maintaining
1.4. MCITP: Database Administrator 2008/2012/2014 (70-450)
- Designing, Optimizing and Maintaining a Database Server Infrastructure using SQL Server 2008/2012/2014
1.5. Upgrade (70-453)
- Transition Your MCITP SQL Server 2005 DBA to MCITP SQL Server 2008/2012/2014 DBA
1.6. How to Prepare and Take MCTS/MCITP Exams
1.7. SQL Server 2008/2012/2014 New Features
 

2. MCTS - SQL Server 2008/2012/2014, Implementation and Maintenance

2.1. Installing and Configuring SQL Server 2008/2012/2014
- Install SQL Server 2008/2012/2014 and related services
- Configure SQL Server instances
- Configure SQL Server services
- Configure additional SQL Server components
- Implement database mail
- Configure full-text indexing
2.2. Maintaining SQL Server Instances
- Manage SQL Server Agent jobs
- Manage SQL Server Agent alerts
- Manage SQL Server Agent operators
- Implement the declarative management framework (DMF)
- Back up a SQL Server environment
2.3. Managing SQL Server Security
- Manage logins and server roles
- Manage users and database roles
- Manage SQL Server instance permissions
- Manage database permissions
- Manage schema permissions and object permissions
- Audit SQL Server instances
- Manage transparent data encryption
- Configure surface area
2.4. Maintaining a SQL Server Database
- Back up databases
- Restore databases
- Manage and configure databases
- Manage database snapshots
- Maintain database integrity
- Maintain a database by using maintenance plans
2.5. Performing Data Management Tasks
- Import and export data
- Manage data partitions
- Implement data compression
- Maintain indexes
- Manage collations
2.6. Monitoring and Troubleshooting SQL Server
- Identify SQL Server service problems
- Identify concurrency problems
- Identify SQL Agent job execution problems
- Locate error information
2.7. Optimizing SQL Server Performance
- Implement Resource Governor
- Use the Database Engine Tuning Advisor
- Collect trace data by using SQL Server Profiler
- Collect performance data by using Dynamic Management Views (DMVs)
- Collect performance data by using System Monitor
- Use Performance Studio
2.8. Implementing High Availability
- Implement database mirroring
- Implement a SQL Server clustered instance
- Implement log shipping
- Implement replication
 

3. MCITP - Database Administrator

       Designing, Optimizing and Maintaining a Database Server Infrastructure using Microsoft SQL Server 2008/2012/2014
      
   3.1. Designing a SQL Server Instance and a Database Solution
- Design for CPU, memory, and storage capacity requirements
- Design SQL Server instances
- Design physical database and object placement
- Design a migration, consolidation, and upgrade strategy
3.2. Designing a Database Server Security Solution
- Design instance authentication
- Design instance-level security configurations
- Design database, schema, and object security parameters
- Design a security policy and an audit plan
- Design an encryption strategy
3.3. Designing a Database Solution for High Availability
- Design a failover clustering solution
- Design database mirroring
- Design a high-availability solution that is based on replication
- Design a high-availability solution that is based on log shipping
- Select high-availability technologies based on business requirements
3.4. Designing a Backup and Recovery Solution
- Design a backup strategy
- Design a recovery strategy
- Design a recovery test plan
3.5. Designing a Monitoring Strategy
- Design a monitoring solution at the operating system level
- Design a monitoring solution at the instance level
- Design a solution to monitor performance and concurrency
3.6. Designing a Strategy to Maintain and Manage Databases
- Design a maintenance strategy for database servers
- Design a solution to govern resources
- Design policies by using Policy-Based Management
- Design a data compression strategy
- Design a management automation strategy
3.7. Designing a Strategy for Data Distribution
- Administer SQL Server Integration Services (SSIS) packages
- Design a strategy to use linked servers
- Design a replication strategy for data distribution
 Free Reservation button
Last updated: | -- | Powered by WECAN.ca CMS