MCITP: Database Administrator SQL Server 2008 -

Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator 2008) for SQL Server 2008 is Microsoft's premier certification for database server administrators. In this economic client, you need something to stand out. The SQL 2008 certification will reflect your knowledge and skills on this enterprise product.

Database administrators architect the network infrastructure, install or configure Microsoft SQL Server and manage or maintain databases or multidimensional databases, user accounts, database availability, recovery, and reporting. They also design or implement security or server automation and monitor and troubleshoot SQL Server activity.

Our MCITP: DBA program is a very hands on environment.  Our instructors guide you through step by step examples and demonstrations, not just long lectures.  Your instructor will create real world scenarios for lab environments. 

WE LIMIT OUR CLASS SIZES TO 12 STUDENTS - THIS ALLOWS FOR MORE ATTENTION FROM THE INSTRUCTOR, MORE SPACE FOR STUDENTS TO WORK AND MORE FOCUSED ENVIRONMENT.

SQLCertifications.com & Advanced Custom Training can get you there:

Our student pass the Microsoft Certification Exams. Our resources and methods are second to none.  We have a 98% success rate of students passing these exams the first time.

During the course of the class day, we teach you how to use the technology with real world examples.  You will actually build a Business Intelligence Solution project from start to finish, with the instructor leading by demonstration throughout the process.

Facilities:

Our facilities are second to none.  Our training center is located 45 minutes south of Tampa in beautiful Sarasota, FL.  We use top end computer equipment, 20in monitors, cpu's with Virtualization, plenty of memory. Our chairs are comfortable - our desk allow plenty of room for student computer, your laptop and book.
  
Students stay at Marriott & Hilton brand hotels which provide full studio amenities including flat panel tvs, microwave and refrigerator in every room.  Students have access to 20+ restaurants within walking distance of the hotel.

Compare Us To The Competition - 

Many of our competitors place 30+ students in a classroom with only one instructor.  Often they try to extend the life of very old equipment with lag and slow performance on the software used today.  Our competitors often use less than desirable (extended stay) type of hotels in areas not suited for professionals.

Our Microsoft Certified Trainers (MCTs) are not instructors who "read from books".  Rather, our trainers are real world consultants who work directly with companies in addition to training our camps.  

Our MCITP Program:

• Focuses on accelerated learning.  We cover concecpts in a clear, condensed fashion.  We focus on the important objectives and cut out the "fluff". 
• Uses real world examples and terminology.  Our instructors explain technical concepts in a way students can see and relate to. No two students are alike - and our class is dynamic to cater to the needs of the students.

With Advanced Custom Training, you will learn hands on, from the best instructors.

SQL Server 2008 offers significant changes to the technology. Several existing features have been enhanced and new features added.

Enhanced features T-SQL enhancements Performance improvements Enhanced Database Mirroring  Online-maintenance operations Business-intelligence enhancements Management-GUI enhancements Security enhancements Increased memory usage with Standard Edition XML enhancements Better e-mail handling 64-bit support

New features Policy Based Management Streamlined Installation  Performance Data Collection Language Integrated Query (LINQ)  Date DataType & Time DataType  Transparent Data encryption

 

Bootcamp Schedule -

Classroom hours are from 8:00am until 5:00pm daily. During these hours, students will participate in interactive lectures and demonstrations. Students will have hands on lab exercises based on topics related to the technology and certification expectations.  Additionally, students will spend several hours in the evening reviewing practice questions to prepare for the offical certification exam.

Course Materials -

We use a combination of Microsoft courseware along and custom labs written to demonstrate the different test objectives in a visual, hands on environment.  Additionally, we provide videos which demonstrate even more details so students will have constant visuals of topics.

Daily lectures, labs, and review sessions are supplemented by a combination of:

• Microsoft Courseware 
• Additional Files & Resources for add on labs
• Self Study Practice Test Resources.

Exam Delivery Schedule -

The MCITP: SQL 2008 Database Administrator bootcamp prepares students to achieve 3 certifications during the program: MCP, MCTS: SQL Server 2008, MCITP: SQL Sever 2008 Database Administator.

Days	Module Description		Exam
1-4	TS: Microsoft SQL Server 2008, Implementation and Maintenance		70-432
4-7	PRO: Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008		70-450

The MCITP: Database Administrator 2008 certification requires two exams to achieve this certification 70-432 & 70-450.

Students take both of these test onsite at our training facility while attending our course.  Below are the objectives of these exams as presented by Microsoft.

Installing and Configuring SQL Server 2008

Install SQL Server 2008 and related services.
This objective may include but is not limited to: file locations; default paths; service accounts

Configure SQL Server instances.
This objective may include but is not limited to: sp_configure

Configure SQL Server services.
This objective may include but is not limited to: configuration manager; SQL browser

Configure additional SQL Server components.
This objective may include but is not limited to: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), replication

Implement database mail.
This objective may include but is not limited to: set up and configure

Configure full-text indexing.
This objective may include but is not limited to: enable/disable, index population

Maintaining SQL Server Instances

Manage SQL Server Agent jobs.
This objective may include but is not limited to: create and schedule jobs; notification of job execution; disable/enable jobs; change job step order; logging

Manage SQL Server Agent alerts.
This objective may include but is not limited to: performance condition alerts; SQL event alerts; Windows Management Instrumentation (WMI) alerts

Manage SQL Server Agent operators.
This objective may include but is not limited to: operator schedules; fail safe operator; add a new operator; notification methods

Implement the declarative management framework (DMF).
This objective may include but is not limited to: create a policy; verify a policy; schedule a policy compliance check; enforce a policy; create a condition

Back up a SQL Server environment.
This objective may include but is not limited to: operating system-level concepts

Managing SQL Server Security

Manage logins and server roles.
This objective may include but is not limited to: create logins; disable/enable logins; security model (authentication mode); password policy enforcement; fixed server roles; alter logins

Manage users and database roles.
This objective may include but is not limited to: user mapping; user-defined roles; fixed roles; guest, public, dbo; creating and deleting user roles

Manage SQL Server instance permissions.
This objective may include but is not limited to: logon triggers; permissions vs. fixed role membership; cross-database ownership chaining; impersonation

Manage database permissions.
This objective may include but is not limited to: impersonation; cross-database ownership chaining

Manage schema permissions and object permissions.
This objective may include but is not limited to: manage schema ownership

Audit SQL Server instances.
This objective may include but is not limited to: use DDL triggers and logon triggers; C2; common criteria; login failures; event notifications

Manage transparent data encryption.
This objective may include but is not limited to: impact of transparent data encryption on backups

Configure surface area.
This objective may include but is not limited to: sp_configure

Maintaining a SQL Server Database

Back up databases.
This objective may include but is not limited to: full backups; differential backups; transaction log; compressed backups; file and filegroup backups; verifying backup

Restore databases.
This objective may include but is not limited to: online restores; full restores; differential restores; transaction log; file and filegroup restores; verifying restore; tail of the transaction log

Manage and configure databases.
This objective may include but is not limited to: files, file groups, and related options; database options; recovery model; attach/detach data

Manage database snapshots.
This objective may include but is not limited to: create, drop, revert

Maintain database integrity.
This objective may include but is not limited to: DBCC CHECKDB; suspect pages

Maintain a database by using maintenance plans.
This objective may include but is not limited to: Maintenance Plan Wizard; Maintenance Plan Designer

Performing Data Management Tasks

Import and export data.
This objective may include but is not limited to: BCP; BULK INSERT; OPENROWSET; GUI tools

Manage data partitions.
This objective may include but is not limited to: switching data from one partition to another; add a filegroup; alter a partition function; alter a partition scheme

Implement data compression.
This objective may include but is not limited to: sparse columns; page/row

Maintain indexes.
This objective may include but is not limited to: create spatial indexes; create partitioned indexes; clustered and non-clustered indexes; XML indexes; disable and enable indexes; filtered index on sparse columns; indexes with included columns; rebuilding/reorganizing indexes; online/offline

Manage collations.
This objective may include but is not limited to: column collation; database collation; instance collation

Monitoring and Troubleshooting SQL Server

Identify SQL Server service problems.
This objective may include but is not limited to: DB Engine service; SQL Agent service; SQL Browser service

Identify concurrency problems.
This objective may include but is not limited to: blocks, locks, deadlocks, activity monitor; relevant Dynamic Management Views

Identify SQL Agent job execution problems.
This objective may include but is not limited to: proxy accounts; credentials; job history

Locate error information.
This objective may include but is not limited to: error log; agent log; job execution history; event logs

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.

Implementing High Availability

Implement database mirroring.
This objective may include but is not limited to: monitoring, configuring, failover

Implement a SQL Server clustered instance.
This objective may include but is not limited to: monitoring, configuring, failover

Implement log shipping.
This objective may include but is not limited to: monitoring, configuring, failover

Implement replication.
This objective may include but is not limited to: monitoring, configuring, failover

Designing a SQL Server Instance and a Database Solution

Design for CPU, memory, and storage capacity requirements.
This objective may include but is not limited to: RAID, calculating table size, IO throughput, transaction per second, data compression, non-uniform memory access (NUMA), tempdb capacity

Design SQL Server instances.
This objective may include but is not limited to: instance configuration, surface area configuration, CPU affinity, memory allocation, max degree of parallelism (MAXDOP), collation

Design physical database and object placement.
This objective may include but is not limited to: heap and index placement, filestream, data and log files, filegroups, partition placement, large object placement, full text catalog

Design a migration, consolidation, and upgrade strategy.
This objective may include but is not limited to: multi-instance considerations, SQL Server version upgrade, instance and database collation, server-level and instance-level objects, service pack application

Designing a Database Server Security Solution

Design instance authentication.
This objective may include but is not limited to: choosing authentication type, logon triggers, regulatory requirements

Design instance-level security configurations.
This objective may include but is not limited to: Windows service accounts, filestream, proxy, credentials, instance-level permissions, certificate and key management, endpoint security, using SSL certificates, TCP ports

Design database, schema, and object security parameters.
This objective may include but is not limited to: users, roles, certificate and key management, Service broker, Common Language Runtime (CLR), ownership chains

Design a security policy and an audit plan.
This objective may include but is not limited to: Policy-Based Management Framework, security functions, sp_helprotect, catalog views, extended events, notifications

Design an encryption strategy.
This objective may include but is not limited to: Transparent Data Encryption, encrypting protected data, certificate and key management, filestream

Designing a Database Solution for High Availability

Design a failover clustering solution.
This objective may include but is not limited to: cluster resource group, cluster setup considerations, number of nodes, service accounts

Design database mirroring.
This objective may include but is not limited to: whether to use a witness server, Windows Server considerations, suspend vs. stop, automatic or manual failover, automatic page repair, database snapshots for reporting, managing instance-level objects

Design a high-availability solution that is based on replication.
This objective may include but is not limited to: different replication types, topologies, recover from replication failure, synchronization, health monitoring

Design a high-availability solution that is based on log shipping.
This objective may include but is not limited to: manage instance-level objects, changing roles, reporting secondary instance for reporting, monitor server, reinitializing, consistency check on secondary instance

Select high-availability technologies based on business requirements.
This objective may include but is not limited to: failover clustering, database mirroring, log shipping, replication

Designing a Backup and Recovery Solution

Design a backup strategy.
This objective may include but is not limited to: recovery model, compression, choosing backup types, scheduling, backup media, file and filegroups backup, verifying backups, key management, mirrored backups, cluster considerations

Design a recovery strategy.
This objective may include but is not limited to: page, file, filegroup, partial and online restores, orphan users, instance rebuild, encryption considerations, handling media failures, transaction logs, point in time and mark recovery, filestreams

Design a recovery test plan.
This objective may include but is not limited to: log shipping, replication, hardware considerations, scheduling a database restore test, handling high availability failures

Designing a Monitoring Strategy

Design a monitoring solution at the operating system level.
This objective may include but is not limited to: system monitor counters, event logs, dynamic management views and functions, Windows Management Instrumentation (WMI), remote monitoring, analyze results

Design a monitoring solution at the instance level.
This objective may include but is not limited to: instance, database and object monitoring, data collection, event notifications, dynamic management objects, analyze results

Design a solution to monitor performance and concurrency.
This objective may include but is not limited to: Dedicated Administrator Connection (DAC), locking, blocking, deadlocks, dynamic management objects, index utilization, tracing, analyze

Designing a Strategy to Maintain and Manage Databases

Design a maintenance strategy for database servers.
This objective may include but is not limited to: rebuild for page-level compression, index and heap maintenance, partition management, statistics

Design a solution to govern resources.
This objective may include but is not limited to: Resource Governor (CPU, memory, number of requests per second; resource pools, resource groups), query governor

Design policies by using Policy-Based Management.
This objective may include but is not limited to: designing policies and conditions

Design a data compression strategy.
This objective may include but is not limited to: row vs. page level, update frequency, compression ratio, compressing partitions, specific indexes

Design a management automation strategy.
This objective may include but is not limited to: SQL Server PowerShell, WMI, SQL Server Agent, event notifications, DDL triggers

Designing a Strategy for Data Distribution

Administer SQL Server Integration Services (SSIS) packages.
This objective may include but is not limited to: design security for accessing packages, troubleshoot and restart package, schedule package execution, deploy packages to same or different instances

Design a strategy to use linked servers.
This objective may include but is not limited to: security, providers, distributed transactions

Design a replication strategy for data distribution.
This objective may include but is not limited to: selecting replication types, conflict resolution, health monitoring, horizontal and vertical partitioning

Advanced Custom Training offers the highest quality technical education in an all-inclusive course package specifically designed for the needs and ease of our students. We attend to every detail so our students can focus solely on their educational objectives.

• All inclusive package includes Airfare (Roundtrip to Tampa/Sarasota Florida), Transportation to and from airport, 7 Days of Hotel Accommodations, Breakfast and Lunch, Unlimited Beverages and Snacks.
• Intensive Hands-on Training by Microsoft Certified Trainers utilizing our (Lecture | Lab | Demo | Video) Delivery
• Microsoft Courses  and custom materials comprised of comprehensive study materials, Microsoft training materials, practical lab manuals, and practice test resources
• Examination Vouchers
• On-site Certification Testing
• Examination Passing Policy

Advanced Custom Training has the best well-equipped educational facilities where you will attend instruction and labs and have access to comfortable study and rest/break room.

Our Microsoft Certified Trainers teach to accommodate every student’s learning needs by working one on one with students, hands-on labs, self-testing, question and answer sessions. 

Which class/camp are you interested in? * MCPD: .Net Visual Studio 2008 Bootcamp MCITP: Windows 7 or Server 2003/2008 Bootcamp MCITP: SQL 2008 Business Intelligence Bootcamp MCITP: SQL 2008 Admin Bootcamp MCITP: SQL 2008 Developer Bootcamp MCITP: SQL 2008 Admin/Dev Combo Bootcamp Microsoft On-site Training Non-bootcamp Microsoft Training First Name * Last Name * Email Address * Phone Number