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
  • 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. It is essential that database administrators know how to manage this complex platform correctly. This hands-on course provides you with the knowledge and skills you need to install SQL Server, create and modify storage structures, manage security and back up and recover databases.

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."

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

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
  • Configuration Servers
  • Policy-Based Management Framework
Creating and Managing Databases
Storage structures
  • Examining disk structures
  • Creating databases and transaction logs
Managing database space
  • Permitting automatic database growth
  • Adding database files to expand databases
  • 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
  • Defining new roles
  • Delegating privileges with pre-defined roles
  • Assigning users to roles
  • Handling mismapped logins
Granting permissions
  • Allowing server, database, schema and object access
  • Interaction of roles and permissions
  • Securing Common Language Runtime (CLR) objects
  • Overcoming broken ownership chains
Migrating Data
SQL Server Integration Services
  • Packages
  • Control flows
  • Connections
  • Data flows
  • Business Intelligence Development Studio
Building simple packages
  • Importing and exporting data from and to other sources
  • Dealing with SQL Server 2000 DTS packages
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
  • Recovering user databases
  • Testing recovery scenarios
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
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
  • Querying Dynamic Management Objects
  • Checking server status with Performance Studio
Introducing the Resource Governor
  • Identifying priority workloads
  • Balancing diverse workloads

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 an EXTRA $200 on a 10-Day Training Pass!

SQL Server 2008 Database Administration: Hands-On
Upcoming Dates
Nov 4 - 7, 2008
 Washington, DC (Reston, VA)
Nov 25 - 28, 2008
 Ottawa
Dec 2 - 5, 2008
 Toronto
Dec 9 - 12, 2008
 New York
Dec 16 - 19, 2008
 Chicago (Schaumburg)
Jan 6 - 9, 2009
 Washington, DC (Rockville, MD)
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

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

Course Tuition
$ 2,650 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,385 Alumni Gold Discount
$ 2,360 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