MCTS Maintaining SQL Server 2008 Database
Start Date: November 9 2009
End Date: November 30 2009
Time: 6:00pm - 10:00pm
Fee:
Venue:
McKimmon Conference and Training Center
1101 Gorman Street
Raleigh, NC  27695
919.515.2277
Course Overview:

MCTS Maintaining a SQL Server 2008 Database

Why you should attend: This course will help you to specialize your technological knowledge for Microsoft® SQL Server 2008. It will prepare you to take the Microsoft Certified Technology Specialist certification exam that will demonstrate an IT professional's in-depth, current skills in SQL Server 2008. The course will cover maintaining databases using specific instructions and specifications. You will gain thorough knowledge of the product, understand how to use the tools and Transact-SQL language, and how to explore the user interface.

Suggested Prerequisites:   MCTS Implementing SQL 2008 Server or experience equivalent
Querying and processing SQL Server Data with SQL Statements.

Attend and You Will Learn

Lesson 1: Review Managing Databases   

  • Configure log and data files
  • Specifying a recovery model

Lesson 2: Backing Up, Restoring, and Moving a Database

  • Backing up a database
  • Restoring a database
  • Moving a database

Lesson 3: Managing Database Snapshots 

  • Creating a database snapshot
  • Reverting a Database from a database snapshot

Lesson 4: Automating Administrative Tasks

  • Create a SQL server agent job
  • Creating a maintenance plan
  • Using DTUTIL
  • Configuring operators
  • Configuring alerts
  • Configuring database mail

Lesson 5: Managing SQL Server Security

  • Using the surface area configuration tool and SAC
  • Configuring server security principals
  • Configuring database securables
  • Configuring encryption
  • Configuring linked servers

Lesson 6:  SQL Server High Availability Technologies: Clustering

  • Introduction to clustering
  • Introduction to clustering
  • Clustering requirements
  • Clustering features
  • Clustering limitations
  • GEO clusters

Lesson 7:  SQL Server High Availability Technologies: Database Mirroring  

  • Understanding database mirroring roles
  • Preparing databases for database mirroring
  • Establishing endpoints
  • Understanding operating modes
  • Failing over a database mirror
  • Removing database mirroring

Lesson 8:  SQL Server High Availability Technologies: Log Shipping

  • Preparing to log ship
  • Configuring log shipping options
  • Configuring log shipping mode
  • Configuring monitoring

Lesson 9:  SQL Server High Availability Technologies: Replication 

  • Understanding replication types
  • Setting up replication
  • Configuring replication security
  • Configuring conflict detection for merge replication
  • Monitoring replication

Lesson 10:  Monitoring SQL Server  

  • Working with SQL profiler
  • Working with system monitor
  • Using DTA
  • Using dynamic management views and monitoring data
  • Correlating Performance and monitoring data
  • Resolving blocking and deadlocks
  • Resolving database errors
  • Using DAC

Lesson 11:  Transferring Data  

  • Preparing to work with flat files
  • Running BCP
  • Performing a bulk insert task
  • Importing bulk XML data
  • Introduction to SSIS
  • Using the SSIS import and export Wizard

Lesson 12:  Creating Full-Text Catalogs

  • Cresting a full-text catalog
  • Creating a full-text index
  • Populating a full-text index
Schedule: