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 is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

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
Mar 23 - 27, 2009
 Dallas
Mar 23 - 27, 2009
 N. New Jersey
Mar 30 - Apr 3, 2009
 Chicago (Downtown)
Mar 30 - Apr 3, 2009
 Washington, DC (Reston, VA)
Apr 6 - 10, 2009
 Baltimore
Apr 6 - 10, 2009
 New York
Apr 13 - 17, 2009
 San Francisco Bay Area
Apr 20 - 24, 2009
 Toronto

For complete schedule, please visit www.learningtree.com
 
http://www.learningtree.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.learningtree.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,625 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 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 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.learningtree.com/courses/132pf.htm