SQL 2005 for Administrators Workshop

As apart of our ongoing training, CITO in partnership with Microsoft via the Premier Support Agreement will be providing SQL 2005 for Administrators Workshop to the GOJ MIS Officers, scheduled for December 7-9, 2009.

Venue: Microsoft Jamaica Inc., Pan Caribbean Building, 10th Floor, 60 Knutsford Boulevard, Kingston 10
The goal of this workshop is to provide training for database administrators and other new comers to SQL 2005 the knowledge and skill to on how to install, configure, secure, and maintain Microsoft ® SQL Server 2005 databases and servers. Along with updates and changes from the last version of SQL Server and new technologies added to the Application.

This training will also provide in-depth understanding of the most commonly encountered issues by Microsoft Support on various topics that are being discussed along with their current status, solutions or workarounds.

Agenda:
Day ONE:

1. Introduction and Overview of SQL2005
i. Components and new features for Administrators

2. Installing, Upgrading and Maintaining SQL 2005
i. Installation
ii. Upgrade wizard
iii. Migration options

3. Tools
i. Management Studio
ii. Configuration Manager
iii. SQLCMD Utility
iv. SQL Management Objects

4. Monitoring SQL 2005
i. Profiler
ii. DDL Triggers
iii. Event Notifications

Day TWO:

5. Indexes in SQL 2005
i. New types indexes

6. Security in SQL 2005
i. Securing SQL server
ii. Permissions
iii. Certificates

7. Disaster Recovery
i. Backup and Restore
ii. Database Snapshots
iii. Database Mirroring
iv. Log Shipping

Day THREE:

8. Replication
i. Snapshot
ii. Transactional
a) Peer-to-Peer
iii. Merge

9. Clustering

Issues that support is seeing currently related to the topics will be discussed along with their resolution.

Hardware Requirements: Provided

Duration: 3 days (8:30-16:30)
To ensure the high-quality knowledge transfer expected by the attendees of this 3 -day’s workshop, class size is limited to a maximum of 16 officers.

Early departure on any day is not accepted.
Officers should anticipate consistent start and end times for each day. Persons who are not able to attend all three (3) full days need NOT apply.
Kindly RSVP to register for a seat in this session.