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

SQL Server 2008 Database Administration: Hands-On

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

Quick Enroll    

You Will Learn How To
  • Administer SQL Server 2008 with SQL Server Management Studio and Transact-SQL
  • Build databases and upgrade from prior versions
  • Implement login security and authorize database access
  • Manage complex access requirements with permissions and roles
  • Develop backup strategies to recover from disasters
  • Import and export data with SQL Server Integration Services

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 skills you need 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.

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," is assumed. Experienced SQL Server 2005 DBAs 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
  • Upgrading databases from prior versions of SQL Server
  • Implementing login security and permitting database access
  • Granting database and object permissions
  • Managing transaction logs
  • Backing up databases
  • Recovering from a server crash

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
  • Intellisense
  • SQL Server Configuration Manager
  • SQLCMD
  • PowerShell
  • Books Online
Creating and Managing Databases
Storage structures
  • Examining disk structures
  • Creating databases and transaction logs
  • Defining file groups
  • Controlling file placement
  • Shrinking databases
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
  • Migrating data with Transact-SQL
  • Detaching and attaching databases
Implementing Server and Database Security
Creating logins
  • Contrasting Windows and SQL Server authentication
  • Allowing server access
  • Investigating fixed server roles
  • Making logins members of server roles
  • Enforcing password policy
Authorizing database access
  • Adding users
  • Delegating privileges with pre-defined roles
  • Defining new roles
  • Assigning users to roles
  • Handling mismapped logins
Managing Permissions
Granting database-scoped privileges
  • Permitting object creation
  • Granting blanket permissions
Schemas
  • Designing schemas
  • Assigning a default schema
Handling object-level permissions
  • Limiting object access
  • Meeting complex permission requirements with roles
  • Examining permission hierarchies
Recovering from Disasters
SQL Server Backup Fundamentals
  • Selecting a recovery model
  • Studying available backup types
  • Exploring transaction log architecture
  • Reclaiming transaction log space
  • Managing backup file retention
Backing up databases
  • Performing full, log and differential backups
  • Making file group backups
  • Backing up system databases
Restoring databases
  • Recovering user databases
  • Restoring a damaged master database
  • Performing a piece-meal restore
  • Diagnosing the problem
Migrating Data
SQL Server Integration Services
  • Packages
  • Control flows
  • Connections
  • Data flows
  • Business Intelligence Development Studio
  • Solutions
  • Projects
Building simple packages
  • Importing data from various data sources
  • Exporting data to different data stores
  • Opening Integration Services connections
  • Storing SSIS packages in msdb

Related Courses
SQL Server 2008 is a registered trademark of Microsoft Corporation.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save Up to 45% per course on the standard tuition!

SQL Server 2008 Database Administration: Hands-On
Upcoming Dates
Jan 13 - 16, 2009
 Los Angeles
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)

SQL Server 2008 Database Administration: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

SQL Server 2008 Database Administration: Hands-On
SQL Server 2008 Database Administration: Hands-On
Participants recovering the master database.


CPE 23 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733