SQL 2008 Certification Training

"The instructor was very thorough and was a reliable source of Microsoft knowledge. He taught in an organized fashion with clarity and understanding. When I had questions he would carefully explain the answers and why. I am glad I chose CED Solutions over the other training schools I researched. It was a choice I do not regret and I look forward to returning in the future for additional certifications."

-Eric Fellen, Bayonne, NJ

Custom Training Quote

• Aug 17 - Aug 23, 2013
• Nov 09 - Nov 15, 2013

• Includes roundtrip airfare and lodging
  
  (Atlanta and Fort Lauderdale boot camps only)
• Hands-on instruction by a certified instructor
• Includes all course materials and practice exams
• Onsite Testing
• Breakfast and Lunch provided each day

Can't travel or you want to stay with your family or business. No problem! Stay in your own city and save the additional expenses of roundtrip airfare, lodging, transportation, and meals and receive the same great instruction live from our instructors in our Live Instructor-Led Remote Classroom Training.

Remote Classroom Training

Our Remote Classroom Training is a live class with students observing the instructor and listening through your computer speakers. You will see the instructor's computer, slides, notes, etc., just like in the classroom. You will be following along, doing work, labs, and individual assignments.

When you earn a Microsoft Certified Technology Specialist (MCTS) certification, you validate your deep technical knowledge and skill using the features and functionality of key technology areas in Microsoft SQL Server 2008.

Microsoft Certified IT Professional: Database Administrator (MCITP: Database Administrator) is the premier certification for database server administrators. This certification demonstrates that you can keep up with your enterprise business solutions 24 hours a day, 7 days a week.

• Exam 70-432
• Exam 70-450

Exam 70-432

Microsoft SQL Server 2008, Implementation and Maintenance

Installing and Configuring SQL Server 2008

• Install SQL Server 2008 and related services.
• Configure SQL Server instances.
• Configure SQL Server services.
• Configure additional SQL Server components.
• Implement database mail.
• Configure full-text indexing.

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

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.

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.

Performing Data Management Tasks

• Import and export data.
• Manage data partitions.
• Implement data compression.
• Maintain indexes.
• Manage collations.

Monitoring and Troubleshooting SQL Server

• Identify SQL Server service problems.
• Identify concurrency problems.
• Identify SQL Agent job execution problems.
• Locate error information.

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.
• Implement a SQL Server clustered instance.
• Implement log shipping.
• Implement replication.

[ Back to top ]

Exam 70-450

Designing, Optimizing, and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

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

[ Back to top ]

CED Solutions is your best choice for SQL 2008, SQL 2008 training, SQL 2008 certification, SQL 2008 boot camp, SQL 2008 certification training, SQL 2008 certification course, SQL 2008 course, SQL 2008 class.