1-800-THE-TREE (1-800-843-8733)

TRAINING YOU CAN TRUST

SQL Server 2005 Database Administration: Hands-On

Course: 132 Type: Hands-On Training Duration: 5 Days

You Will Learn How To

Administer SQL Server 2005 with SQL Server Management Studio and Transact-SQL
Create and manage databases, transaction logs and database snapshots
Implement login and database security and manage permissions
Develop a backup and recovery strategy
Manage complex multistep jobs with SQL Server Agent
Deploy and manage transactional replication

Course Benefits

Administration of your organization's SQL Server databases is improved by effectively maximizing the scalability, availability and security features of SQL Server 2005. This course offers extensive experience using SQL Server 2005 tools to install SQL Server, create and modify storage structures, back up and recover databases, and manage security.

Who Should Attend

Those interested in SQL Server administration. Course 131, "SQL Server 2005 Comprehensive Introduction," or equivalent experience is assumed. Experienced SQL Server 2000 DBAs should take Course 129, "SQL Server 2005 Administration: Skills Upgrade."

Hands-On Training

Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2005. Exercises include:

Administering SQL Server 2005 with graphical tools and Transact-SQL
Creating databases
Implementing security for logins, databases and objects
Backing up and restoring databases
Recovering the master database
Maintaining a hot standby server with mirroring
Configuring Database Mail
Managing transactional replication

Related Courses

SQL Server Server-Side Programming - Course 133
Relational Database Design - Course 382
Deploying Clusters on Windows Server 2003 - Course 539
SQL Server 2005 Reporting Services - Course 523
Management Skills - Course 290

SQL Server is a trademark of Sybase, Inc.

Upcoming Dates

Nov 24 - 28, 2008
Toronto

Dec 1 - 5, 2008
New York

Dec 15 - 19, 2008
Washington, DC (Rockville, MD)

Jan 5 - 9, 2009
Ottawa

Jan 12 - 16, 2009
New York

Jan 12 - 16, 2009
Washington, DC (Reston, VA)

Jan 26 - 30, 2009
Los Angeles

Feb 2 - 6, 2009
Boston (Waltham)

Feb 2 - 6, 2009
Toronto

Feb 9 - 13, 2009
Washington, DC (Rockville, MD)

Feb 23 - 27, 2009
New York

Feb 23 - 27, 2009
Philadelphia

Mar 2 - 6, 2009
Chicago (Schaumburg)

Mar 9 - 13, 2009
Washington, DC (Alexandria, VA)

Mar 16 - 20, 2009
Atlanta

For complete schedule, please visit www.learningtree.com

http://www.learntree.com/courses/132pf.htm

1-800-THE-TREE (1-800-843-8733)

TRAINING YOU CAN TRUST

SQL Server 2005 Database Administration: Hands-On

Course: 132 Type: Hands-On Training Duration: 5 Days

Course 132 Content

Getting Started with SQL Server 2005

Components

Services
Editions
System and user databases

Essential tools

SQL Server Management Studio
Transact-SQL
Surface Area Configuration
SQL Server Configuration Manager

Installing SQL Server

SQL Server 2005 installation

Choosing installation options
Employing multiple instances
Upgrading from previous versions
Applying a Service Pack

Managing Databases

Disk structures

Examining storage structures
Creating databases and transaction logs

Space management strategies

Handling dynamic database growth
Reclaiming unused space

Moving databases

Detaching and attaching databases
Copying databases with the Copy Database Wizard

Controlling Server and Database Security

Login security

Contrasting Windows and SQL Server authentications
Authorizing logins
Making logins members of server roles
Enforcing password policy

Database security

Designing schemas
Adding users
Defining NEW roles
Delegating privileges with pre-defined roles
Assigning users to roles

Permissions

Granting server, database, schema-scoped and object permissions
Interaction of roles and permissions

Migrating Data

SQL Server Integration Services

Packages
Control flows
Data flows
Connections
Business Intelligence Development Studio

Building simple packages

Importing data from Access
Exporting a table to Excel

Backup and Recovery

Planning for and recovering from disasters

Transaction log architecture
Choosing a recovery model
Performing full, log and differential backups
Recovering system and user databases

Implementing database mirroring

Selecting a mirroring architecture
Configuring the mirror and witness servers
Monitoring database mirroring
Taking a snapshot of the mirror

Automating Tasks with Jobs and Alerts

The SQL Server Agent

Configuring the Agent
Setting up Database Mail

Multistep jobs

Defining jobs to handle routine tasks
Creating alerts and operators
Associating alerts with jobs

Deploying Replication

Replication concepts

Publish/subscribe metaphor
Replication types
Replication agents

Managing transactional replication

Configuring the Publisher and Distributor
Creating publications
Subscribing to publications

Monitoring SQL Server

Identifying problems with Activity Monitor
Querying Dynamic Management Objects
Deploying the Performance Dashboard
Analyzing trends with the SQL Server Health and History tool (SQLH2)

http://www.learntree.com/courses/132pf.htm

1-800-THE-TREE (1-800-843-8733)

TRAINING YOU CAN TRUST

SQL Server 2005 Database Administration: Hands-On Tuition

Course: 132 Type: Hands-On Training Duration: 5 Days

Course Tuition

$ 3,090	Standard Tuition
Tuition with a Savings Plan
$ 2,250	10-Day Pass
$ 1,670	Training Passport
$ 1,700	Premium-Pass
$ 2,200	Voucher 10-Pack
$ 2,785	Alumni Gold Discount
$ 2,744	Government Discount

Your Course Tuition Entitles You To...

Class participation
Team workshops
Use of in-class hands-on equipment
Comprehensive course materials
Morning and afternoon refreshments
Course Completion Certificate awarding Continuing Education Units
FREE participation in Professional Certification
FREE participation in College Credit programs (including related exams)

Tuition Savings Plans

Training Passport	3 courses in 12 months As little as $1,670 per course Savings as much as 40% Only $5,000
Premium Pass	4 courses in 24 months As little as $1,700 per course Save as much as 45%
10-Day Pass	A NEW way to save on training 10 days of training for one person Save as much as $990 per course Only $4,500
Training Vouchers	Save as much as $990 per course Fully transferable As low as $2,200 per course
Alumni Gold Discount	Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.

http://www.learntree.com/courses/132pf.htm