جلوبال لتكنولوجيا المعلومات - دورات وخدمات تكنولوجية عالمية

MCTS: SQL SERVER SPECIALIST

Microsoft MCTS training from Gatlin International is the safe, convenient and affordable way to get the knowledge you need to advance your career as a Microsoft Certified Technology Specialist. Microsoft MCTS in Microsoft SQL Server 2008 (MCTS: SQL Server 2008) implement and maintain databases using specific instructions and specifications.

Audience Profile

Candidates for this exam work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidate will have knowledge and expertise with the following:

Defining high-availability solutions
Data distribution
Automating administrative tasks (for example, checking db stats, backups)
Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
Defining security solutions
Monitoring and troubleshooting the database server
Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
Designing and executing deployments
Deployments and migration
Defining the infrastructure (for example, storage, hardware, and number of servers or instances)

MCTS: SQL SERVER SPECIALIST

To achieve this certification you must pass the designated exam. You can prepare for the exam by attending the courses listed below.

Certification Exam

70-432: TS: Microsoft SQL Server 2008 Implementation and Maintenance

About this ExamThis exam is targeted at the professional level SQL Server 2008 Database Administrator. It tests your ability to make appropriate design and technology choice considerations for your SQL Server 2008 installations.

Audience Profile

Candidates for this exam work in an environment in which Microsoft SQL Server 2008 is used for database solutions. Candidates should have at least three years of experience administering databases in an enterprise-level organization and designing, deploying, optimizing, maintaining, and supporting database service life cycle. Candidates should also have experience with the following:

Defining high-availability solutions
Data distribution
Automating administrative tasks (for example, checking db stats, backups)
Maintaining administrative tasks (for example, determining index rebuild time, file groups for backup)
Defining security solutions
Monitoring and troubleshooting the database server
Performance optimization (for example, physical tuning, including hardware, operating system, instance-level tuning), PerfMon
Designing and executing deployments
Deployments and migration
Defining the infrastructure (for example, storage, hardware, and number of servers or instances)

Credit Toward CertificationExam 70-450: PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008: counts as credit toward the following certification(s):Microsoft Certified IT Professional: Database Administrator 2008

MCTS: SQL SERVER SPECIALIST

Global IT can help you to realise your ambition and set you on the path to a new and profitable future.

Here at Global IT, we have everything you need to get yourself back on track. You'll be hand-in-hand with Global IT resource for turning raw potential into career reality.

Job Opportunites with the MCTS SQL

DATA BASE ADMINISTRATOR
WEB DATABASE SUPPORT
DATABASE MAINTAIN AND DESIGN

All we ask of you is effort and commitment, the end result will bring its own ample reward.

Your Guarantee

The Global IT has successfully taught Hundreds of students from all over Palestine. Our vast experience gives us the confidence to say to you that you cannot fail. We can assure you that you will gain new skills and successfully achieve valuable qualifications - a guarantee of a successful future. More career opportunities will be opened up to you.

MCTS: SQL SERVER SPECIALIST

Exam 70-432: TS: Microsoft SQL Server 2008, Implementation and Maintenance

1. 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

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

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

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

5. Performing Data Management Tasks

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

6. Monitoring and Troubleshooting SQL Server

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

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

8. Implementing High Availability

Implement database mirroring
Implement a SQL Server clustered instance
Implement log shipping
Implement replication