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

SQL Server 2005 Database Administration: Hands-On

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

Quick Enroll    

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

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)

Related Courses
SQL Server is a trademark of Sybase, Inc.
  
 
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 40% per course on the Training Passport!

SQL Server 2005 Database Administration: Hands-On
Upcoming Dates
Oct 20 - 24, 2008
 New York
Oct 27 - 31, 2008
 Washington, DC (Rockville, MD)
Nov 3 - 7, 2008
 Chicago (Schaumburg)
Nov 17 - 21, 2008
 Atlanta
Nov 17 - 21, 2008
 Washington, DC (Reston, VA)
Nov 24 - 28, 2008
 Toronto
Dec 1 - 5, 2008
 New York
Dec 8 - 12, 2008
 Baltimore
Dec 8 - 12, 2008
 Irvine, CA
Dec 15 - 19, 2008
 Washington, DC (Rockville, MD)

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

About the Course Author
Sharon Dooley

"You start this course as if it were your first day as the DBA of a hypothetical company,with your first task being to identify the problems. Then, throughout the week..."
more »

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
 

 

SQL Server 2005 Database Administration: Hands-On
SQL Server 2005 Database Administration: Hands-On
Participants installing SQL Server 2005.
The most recent 100 evaluations scored this course at:

  (3.79/4.00)


SQL Server 2005 for the Enterprise


Certification Core Course CPE 29 Credits Vendor Cert - Microsoft 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733