California IT Courses

Microsoft SQL Server 2008 Administration

Length: 5 Days | Price: Please contact us for pricing information.

This training course consists of five days of hands-on training that focus on the fundamentals of administering the SQL Server 2008 database engine. Participants in this course will come away with the knowledge and experience required to administer SQL Server 2008. The course focuses on performing common administrative tasks, understanding how SQL Server works under the covers, and optimizing SQL Server performance as well as assuring high data availability. Attendees will learn how to install, configure, manage, secure, automate, monitor, and optimize SQL Server 2008. You will also learn how to create, manage, back up, and restore individual databases, transfer and replicate data, configure for high availability, and plan disaster recovery.

Emphasis is placed on how SQL Server 2008 is architected, so that you will be able to make the proper decisions in configuring and managing your SQL Server instances. The hands-on labs provide comprehensive practice performing common administrative tasks.

Course Prerequisites: Familiarity with database concepts, Windows desktop navigation and software installation techniques. Attendance at theSQL Programming course is highly recommended although not required.

Microsoft SQL Server 2008 Administration Course Overview
  • SQL Server 2008 Features and Functionality
  • Installing SQL Server 2008
  • Using the SQL Server Configuration Manager
  • SQL Server Management Studio Component
  • Using the Object Explorer and Setting Properties
  • Using the Query Editor
  • Policy Based Management
  • Books Online Overview
  • SQL Server Database Architecture
  • Transaction Log Architecture
  • Creating Databases
  • Creating and Modifying Tables
  • File Placement for Optimum Performance
  • Securing SQL Server
  • Creating Logins, Users and Roles
  • Assigning Permissions
  • Certificates in SQL Server 2008
  • Execution Context
  • Encryption
  • Transferring and Storing Data
  • FILESTREAM Data Storage
  • Ensuring Data Integrity
  • Enabling and Disabling Constraints
  • DML Triggers
  • Database Backup Overview
  • Restoring Databases
  • Copying/Moving User Databases
  • Automating Administrative Tasks
  • Setting Up Database Mail
  • Configuring the SQL Server Agent
  • Jobs, Schedules and Proxies
  • Creating Alerts
  • Configuring Full-Text Search
  • Full-Text Search Queries
  • Replicating Data
  • Sharing Data
  • SQL Server 2008 Monitoring Events and Data Change
  • SQL Server Audit and Extended Events
  • Change Data Capture
  • Creating a Central Management Server
  • Policy-Based Management
  • Monitoring Server Performance
  • Using SQL Server Profiler
  • Optimizing Server Performance
  • Implementing High Availability
  • Enabling Database Mirroring
Copyright© California IT Courses