Microsoft SQL Server 2008: Essential Administration

Course Overview

This course is at aimed anyone charged with administering a SQL Server 2008 database system. It focuses on only the core administration responsibilities enabling new SQL Server 2008 database administrators to build the skills necessary to install, configure and support a simple SQL Server deployment. The objective is to provide the essential skills for managing a single instance system, enabling administrators to get up and running to a basic level fairly quickly, but also to provide an awareness of some of the more advanced services available. This course can be followed by a number of additional courses focussing on different specialisations and services available for SQL Server deployments.

CourseMonster specialises in offering Microsoft training to corporations and individuals alike, we are happy to help with any of your Microsoft training requirements.

Related Courses

• Microsoft SQL Server 2008 New Features: Hands-On
• Microsoft SQL Server 2008 Comprehensive Introduction: Hands-On
• Microsoft SQL Server 2008: Database Administration
• Microsoft SQL Server 2008 Training Course UK: Comprehensive DBA & Programming Upgrade
• Microsoft SQL Server 2008 Analysis & Integration Services (SSAS & SSIS) - (Business Intelligence, BI, Data Warehouse, Mining)
• Microsoft SQL Server 2008 Reporting Services (SSRS) - (Business Intelligence, BI)
• Microsoft SQL Server 2008: Business Intelligence with SQL Server 2008 - (Microsoft, BI, SSRS, SSAS, SSIS, Data Warehouse, Mining)
• Microsoft SQL Server 2008: Maintaining a Microsoft SQL Server 2008 Database
• Microsoft SQL Server 2008 Reporting Services: Hands-On
• Microsoft SQL Server 2008: Implementing and Maintaining Microsoft SQL Server 2008 Reporting Services

Audience

Anyone charged with administering a SQL Server 2008 database system

Prerequisites

Delegates attending this course should have as a minimum a basic understanding of relational databases and the SQL language, up to the level provided by the "SQL for SQL Server Course" but would benefit from having attended the "Introduction to Transact SQL Course" as well.

Course Outline

Installing and Configuring SQL Server

• Preparing to Install SQL Server
• Installing SQL Server
• Configuring a SQL Server Installation
• • Configuration Manager
  • Management Studio Server Properties
  • sp_configure

Managing Databases and Files

• Planning Databases
• Creating Databases
• • File groups and Data Files
  • Transaction Log Files
  • Managing Databases
  • Options
  • Attaching and detaching

Disaster Recovery

• Planning a Backup Strategy
• Backing Up User & System Databases
• Restoring User Databases
• Performing Online Restore Operations
• Recovering Data from Database Snapshots
• System Databases and Disaster Recovery

Managing Security

• Overview of SQL Server Security
• Protecting the Server Scope
• Protecting the Database Scope
• Protecting the Server Scope
• Auditing Security

Establishing Client Connectivity

• Network Libraries
• ODBC & OLE-DB connections
• SQL Native Client
• Configuring Server Connectivity Settings

Automating Administrative Tasks

• Automating Administrative Tasks in SQL Server
• Using SQL Server Agent
• Creating Maintenance Plans
• Implementing Alerts
• Managing Multiple Servers
• Managing SQL Server Agent security

Monitoring SQL Server

• Viewing Current Activity
• Using SQL Server Profiler

An Introduction To Troubleshooting and Performance Tuning

• Troubleshooting SQL Server
• Performance Tuning in SQL Server

An Overview of Other Services

• An Overview of Replication Service
• An Overview of High Availability Services
• An Overview of Integration Services
• An Overview of Service Broker
• An Overview of Common Language Runtime