1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2008 Database Administration: Hands-On

 
Course: 138   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Administer SQL Server 2008 with SQL Server Management Studio and Transact-SQL
  • Build databases and upgrade from prior versions
  • Secure the server through logins and database permissions management
  • Implement backup and recovery strategies and manage transaction logs
  • Automate administrative activities with SQL Server Agent multistep jobs
  • Perform routine maintenance to correct fragmentation and database corruption

Course Benefits

SQL Server 2008 provides a robust platform that enables organizations to run their most demanding, mission-critical applications. This hands-on course provides you with the knowledge and skills to install SQL Server 2008, create and modify storage structures, manage security and back up and recover databases. Throughout the course, you gain experience in performing administration tasks and techniques.

Who Should Attend

Those responsible for administering SQL Server 2008. A basic understanding of SQL Server 2008 or experience at the level of Course 137, "SQL Server 2008 Comprehensive Introduction." Those with a DBA background in SQL Server 2005 should take Course 136, "SQL Server 2008 Skills Upgrade."

Hands-On Training

Throughout this course, a series of extensive hands-on exercises provides you with practical experience administering SQL Server 2008. Exercises include:
  • Administering SQL Server 2008 with graphical tools and Transact-SQL
  • Creating databases
  • Implementing security for logins, databases and objects
  • Importing and exporting data
  • Backing up and restoring databases
  • Configuring Database Mail
  • Carrying out routine database maintenance
  • Monitoring server health

Related Courses

 
SQL Server 2008 is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Dec 2 - 5, 2008
 Toronto
Jan 13 - 16, 2009
 Los Angeles
Jan 20 - 23, 2009
 Washington, DC (Alexandria, VA)
Feb 10 - 13, 2009
 Washington, DC (Reston, VA)
Mar 17 - 20, 2009
 New York
Mar 24 - 27, 2009
 Ottawa
Mar 31 - Apr 3, 2009
 Toronto
Apr 14 - 17, 2009
 Washington, DC (Rockville, MD)
Apr 21 - 24, 2009
 Chicago (Schaumburg)
Apr 28 - May 1, 2009
 Washington, DC (Alexandria, VA)
May 12 - 15, 2009
 Los Angeles
May 19 - 22, 2009
 Washington, DC (Reston, VA)
Jun 23 - 26, 2009
 New York
Jul 14 - 17, 2009
 Ottawa
Jul 21 - 24, 2009
 Washington, DC (Rockville, MD)

For complete schedule, please visit www.learningtree.com
 
http://www.lerningtree.com/courses/138pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2008 Database Administration: Hands-On

 
Course: 138   Type: Hands-On Training   Duration: 4 Days
 
 
Course 138 Content
 

SQL Server 2008 Installation and Features

Installing SQL Server

  • Choosing installation options
  • Upgrading from previous versions
  • Employing multiple instances

Essential tools

  • SQL Server Management Studio
  • Transact-SQL
  • SQL Server Configuration Manager
  • SQLCMD
  • PowerShell
  • Policy-based management

Creating and Managing Databases

Storage structures

  • Examining disk structures
  • Creating databases, filegroups and transaction logs

Managing database space

  • Permitting automatic database growth
  • Expanding databases by adding files
  • Specifying database options

Moving databases

  • Scripting objects and moving data with Transact-SQL
  • Detaching and attaching databases
  • Copying databases with the Copy Database Wizard

Implementing Server and Database Security

Creating logins

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

Authorizing database access

  • Designing schemas
  • Adding users
  • Delegating privileges with pre-defined roles
  • Defining new roles
  • Assigning users to roles
  • Handling mismapped logins

Granting permissions

  • Allowing server, database, schema and object access
  • Interaction of roles and permissions
  • Overcoming broken ownership chains

Migrating Data

SQL Server Integration Services

  • Packages
  • Control flows
  • Connections
  • Data flows
  • Business Intelligence Development Studio

Building simple packages

  • Importing data from various data sources
  • Exporting data to different data stores

Recovering from Disasters

Backing up databases

  • Choosing a recovery model
  • Transaction log architecture
  • Performing full, log and differential backups
  • Reclaiming transaction log space

Restoring databases

  • Testing recovery scenarios
  • Performing a piecemeal restore
  • Recovering user databases

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

Performing Database Maintenance

Fragmentation and database corruption

  • Identifying and curing fragmentation
  • Finding and repairing database corruption

Database Maintenance Plan Wizard

  • Choosing maintenance tasks
  • Scheduling plan execution

Monitoring SQL Server

Ad hoc monitoring

  • Identifying problems with Activity Monitor
  • Defining performance data collectors
  • Querying the Management Data Warehouse

Introducing the Resource Governor

  • Identifying priority activities
  • Balancing diverse workloads
 
http://www.lerningtree.com/courses/138pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2008 Database Administration: Hands-On Tuition

 
Course: 138   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 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.lerningtree.com/courses/138pf.htm