MAINTAINING A MICROSOFT SQL SERVER 2005 DATABASE

(1)

w w w . c o m f o r i . c o m

This course is intended for IT Professionals who want to

become skilled on SQL Server 2005 product features

and technologies for maintaining a database.

WHO SHOULD ATTEND?

MAINTAINING A MICROSOFT®

®

_{® SQL}

SERVER™

™

_{™ 2005 DATABASE}

VENUE: COMFORI

VENUE: COMFORI –

–

– TH IT

TH IT

TH IT RESOURCE CENTRE , SUBANG JAYA

TH IT

RESOURCE CENTRE , SUBANG JAYA

Key Benefits of Attending this Workshop

In this workshop students will able:

• Install and configure SQL Server 2005.

• Manage database files.

• Backup and restore databases.

• Manage security.

• Monitor SQL Server.

• Transfer data into and out of SQL Server.

• Automate administrative tasks.

• Replicate data between SQL Server

instances.

• Maintain high availability.

DATE: 24

(2)

WORKSHOP OVERVIEW

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL

Server 2005 database. The course focuses on teaching individuals how to use SQL Server 2005 product features

and tools related to maintaining a database.

Brian is Solutions Architect /Enterprise Portal/Identity Management for Avant Quest Sdn Bhd and Principal Consultant/Solutions Architect for Bizcom Solutions. Currently holding the position as Solutions Architect, he is responsible for the solutions architecture and project development. He involved vigorously in the management of project team. He has recently completed the deployment and development for the Identity Integration Management Systems for a local telco company. In this project, he involved in the user’s requirement study and development of Directory Services Integration. He also created web parts for WSS and SPS and MOSS. Another project he involved was in the MS Active Directory Auto Provisioning systems with a local telecommunication company. He also work closely with Microsoft Malaysia in providing technology awareness and Proof Of Concept for potential client interested in Microsoft new products such as Microsoft Office SharePoint Server 2007, Microsoft Identity Integration Server 2003. He also provides consultancy and training for clients and Microsoft partners.

Brian is an active developer with 10 years experience using MS Visual Basic (VB) and MS Visual Basic for Application(VBA). He also well verse in Active Server Pages (ASP) and VB Scripting using Microsoft Visual InterDev 6.0. He had used Visual Studio .NET 2003 to create ASP.NET web application with C#, and it is under his maintenance. When he is not involved in development, he will be teaching and evangelizing Microsoft.NET technologies and visions. He is the speaker for Microsoft Technical and Partner Briefing Seminars in Singapore. He also designed one of the Hot Labs Session during Visual Studio .Net launching in Singapore.

He has been involved in Projects and Trainings such as Application Development-Desktop/Client-Server –VB/VB.Net, Web Site/Application Development-ASP/ASP.Net, Database Design, Programming and Implementation , Business Solutions Design , MS SQL Server 2000 Performance Tuning , MS SQL Server 2000 OLAP Implementation(Data Warehousing) , MS Biztalk Server 2004-Training Consultancy(For SHELL IT), MS Biztalk Server 2006-Training(For Avanade, Maidin), .Net Migration for ASP.Net (Pantai Medical Care-PMCare S/B), SPS 2003 Deployment and Web part development for Angkasa, Document Management Systems 3.0(DiGi), MS Active Directory Auto Provisioning Systems(DiGi), MIIS 2003 – Training and consultancy , Microsoft Office Sharepoint Server 2007 Integration With Lotus Domino(Sunway Group-Suncity), Microsoft Identity Integration Server 2003 Implementations and Training(Maxis).Brian is proficient in many programming languages such as MS Visio, VB.Net, C#.Net, ASP.Net, MS SQL Server- T-SQL, Visual Studio 6.0, Visual Studio .Net 2002/2003/2005, ADO.Net, MS Component Services(COM+) Development and others.

Brian Academic Qualifications are BA (Hons) UKM , PROFESSIONAL QUALIFICATIONS :

• Microsoft Certified Professional, MCP • Microsoft Certified Application Developer, MCAD • Microsoft Certified Solution Developer, MCSD • Microsoft Certified Trainer, MCT

w w w . c o m f o r i . c o m

Profile

Before attending this course, students must have:

• Basic knowledge of the Microsoft Windows operating system and its core functionality.

• Working knowledge of Transact-SQL.

• Working knowledge of relational databases.

• Some experience with database design.

In addition, it is recommended, but not required, that students have completed:

• Course 2778: Writing Queries Using Microsoft SQL Server 2005 Transact-SQL.

• Course 2779: Implementing a Microsoft SQL Server 2005 Database.

Course Materials

The student kit includes a Microsoft Press book and other necessary materials for this class.

PREREQUISITES

(3)

Module 1: Installing and Configuring SQL Server 2005 This module explains how to plan for and install SQL Server 2005, how to manage a SQL Server 2005 installation, and how to use the SQL Server 2005 administrative tools.

Lessons

Preparing to Install SQL Server • Installing SQL Server 2005

• Managing a SQL Server 2005 Installation

Module 2: Managing Databases and Files

This module explains how to manage databases and files.

Lessons

• Planning Databases • Creating Databases • Managing Databases

Module 3: Disaster Recovery

This module explains how to plan and implement a backup and restore strategy.

Lessons

• Planning a Backup Strategy • Backing Up User Databases • Restoring User Databases

• Performing Online Restore Operations • Recovering Data from Database Snapshots • System Database and Disaster Recovery

Module 4: Managing Security

This module explains how to manage principals, securables, and permissions, and how to implement cryptography in a SQL Server database.

Lessons

• Overview of SQL Server Security • Protecting the Server Scope • Protecting the Database Scope

• Managing Keys and Certificates in SQL Server

Module 5: Monitoring SQL Server

This module explains how to monitor SQL Server performance and activity.

Lessons

• Viewing Current Activity • Using System Monitor • Using SQL Server Profiler • Using DDL Triggers • Using Event Notifications

Module 6: Transferring Data

This module explains how to transfer and transform data.

Lessons

• Overview of Data Transfer

• Introduction to SQL Server Integration Services • Using SQL Server Integration Services

• Features of SQL Server Integration Services

Module 7: Automating Administrative Tasks

This module explains how to use the SQL Server Agent to automate administrative tasks.

Lessons

• Automating Administrative Tasks in SQL Server 2005 • Configuring the SQL Server Agent

• Creating Jobs and Operators • Creating Alerts

• Managing Multiple Servers

• Managing SQL Server Agent Security

Module 8: Implementing Replication

This module explains the purpose of replication, introduces the concepts underpinning replication, and describes how to implement replication in several common scenarios.

Lessons

• Overview of Replication • Implementing Replication

• Configuring Replication in Some Common Scenarios

Module 9: Maintaining High Availability

This module explains how to implement high availability technologies with SQL Server 2005.

Lessons

• Introduction to High Availability • Implementing Server Clustering • Implementing Database Mirroring • Implementing Log Shipping

• Implementing Peer-to-Peer Replication

(4)

E-LEARNING COURSE OUTLINES

Optimizing SQL Server 2005 Performance

Overview/Description

To identify ways of optimizing the performance of SQL Server 2005

Expected Duration

3.0 hours

Lesson Objectives:

• recognize how to optimize server performance using memory configuration options in a given

scenario.

• recognize how to optimize server performance using I/O configuration options and Windows options

in a given scenario.

• recognize how to troubleshoot database performance in a given scenario.

• troubleshoot the performance of SQL Server 2005 in a given scenario.

• troubleshoot and analyze query performance in a given scenario.

• optimize database indexes in a given scenario.

• recognize how to optimize stored procedures in a given scenario.

• identify considerations when managing concurrent data access in a given database scenario.

• identify and troubleshoot query performance issues in SQL Server 2005.

Why E-Learning ?

• Provide as a supplementary and alternative way of learning.

• Learning is entirely self paced and accessible via online.

• Features include contents from world class content provider, online pre and post assessment,

videos, simulations, audios, forums, chat, tracking duration and scores.

• Course valid for one month.

User Requirements:

Windows XP and above with broadband connection.

w

(5)

WORKSHOP VENUE

WORKSHOP FEE

COMFORI - TH IT RESOURCE CENTRE, SUBANG JAYA W-5-3 Subang Square Business Centre Jalan SS15/4B

47500 Subang Jaya, Selangor. ( t: (603) 5621 3630 f: (603) 5638 8248 )

F o r re s e rv a t io n s, p le a s e m a k e y o u r b o o k in g s d ir e ct ly w it h t h e h o t e l. T o e n j o y s p e c ia l r o o m r a t e s, p le a s e q u o t e C o m f o ri’ s W o r k s h o p o n :

MAINTAINING A MICROSOFT® SQL SERVER™ 2005 DATABASE WORKSHOP H o t e l b ills a r e t o b e s e t t le d b y d e le g a t e s d ire ct ly w it h t h e h o t e l. H o t e l re s e rv a t io n s a n d t r a v e l a r r a n g e m e n t s a r e t h e r e s p o n s ib ilit y o f t h e r e g ist r a n t . P le a s e n o t e t h a t r o o m s a r e a v a ila b le o n a f ir st c o m e , f ir st s e rv e b a s is . NORMAL PRICE 1 – 2 PAX RM 4000 per pax RM 3600 per pax ≥ 3 PAX EARLY BIRD PRICE 1 – 2 PAX

≥ 3 PAX RM 3200 per pax RM 3600 per pax

EARLY BIRD ENDS ON 7 Nov 2008

MODE OF PAYMENT

C h e q u e o r b a n k d r a ft in f a v o u r o f :

COMFORI SDN BHD(5 8 1 1 1 5 -T )

E-02-03, East Wing, Subang Square Business Centre

Jalan SS15/4G, 47500, Subang Jaya, Selangor,Malaysia Tel: +(603) 5621 3630 Fax: +(603) 5638 8248 Website: w w w .co m fo ri.co m 1 0 0 % H R D F / S B L C L A I M A B L E R e g ist rat io n 8 .3 0 a m A ft e rn o o n S e ssio n 1 .30 p m C o u rs e B e g in s 9 .0 0 a m T e a B re a k 3 .3 0 p m M o rn in g B re a k 1 0 .3 0 a m C o u rs e R e s u m e s 3 .4 5 p m L u n c h 1 2 .3 0 p m E n d o f d ay 5 .0 0 p m P le a s e n o t e t h a t p a y m e n t s m u s t b e re c e iv e d w it h i n 7 d a y s u p o n is s u a n c e o f i n v o ic e

TERMS & CONDITIONS

Cancellations & Substitutions. All cancellations must be made in writing at least 14 days in advance, and COMFORI SDN. BHD. reserves the right to charge a RM250 hotel booking fee. Cancellation less than 7 days will be charged the full course fee. Substitutions are welcomed at anytime. However, please inform us at least 1 day before for preparation of necessary documents. Provided total fee has been paid, payment will be credited towards the rescheduled dates or to a future program should there be no substitution. No refunds are available for cancellations or postponements. COMFORI SDN. BHD. reserves the right to cancel or postpone the program due to unforeseen circumstances. Where COMFORI SDN. BHD. reserves the right to modify or alter the advertised topics where necessary

w w w . c o m f o r i . c o m

SALES CONTRACT

*EARLY BIRD PRICE APPLYS ONLY TO CONTRACTS RECEIVED BEFORE EARLY BIRD DATE ENDS & PAYMENT MADE 7 DAYS AFTER RECEIVING

THE INVOICE

PLEASE COMPLETE THIS SALES CONTRACT AND FAX TO US AT 03-5638 8248 (ATTN:DENZEL NYAM)017-9350300 PARTICIPANTS INFORMATION NAME: POSITION: EMAIL: H/P NUMBER:

OFFICE (DIRECT LINE):

VEGETARIAN: ( )YES ( )NO NAME:

POSITION: EMAIL: H/P NUMBER:

VEGETARIAN: ( )YES ( )NO COMPANY’S INFORMATION ORGANIZATION ________________________________________________ APPROVING MANAGER ________________________________________________ ADDRESS ________________________________________________ ________________________________________________ ________________________________________________ ________________________________________________ TEL NUMBER ________________________________________________ FAX NUMBER ________________________________________________ HR CONTACT & E-MAIL

________________________________________________ SIGNATURE/COMPANY STAMP