Course not currently available

SQL Server 2008 Administration Training Course

Course

In Swansea ()

£ 4,150 VAT inc.

Description

  • Type

    Course

This SQL Server Administration training course teaches students how to administer a SQL Server 2008.
Objectives
Install and configure Microsoft SQL Server
Create databases and tables
Implement indexes and partitions
Take database snapshots
Implement service broker for asynchronous processing of database requests
Create and use full-text indexes
Secure SQL Server and implement policy-based management
Recover data
Automate administrative tasks with the SQL Server Agent
Use Dynamic Management Views to monitor the database and troubleshoot problems
Configure a SQL Server for high availability using failover clustering, database mirroring, log shipping, and replication

About this course

None

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Performance Management
  • Compliance
  • XML
  • Server
  • Database
  • SQL
  • Database training
  • Shipping
  • Business Intelligence
  • Install

Course programme

Overview of Microsoft SQL Server 2008
  • Database Engine
  • Business Intelligence
Installing and Configuring SQL Server 2008
  • Editions of SQL Server
  • Infrastructure Requirements
  • Service Accounts
  • Collation Sequences
  • Authentication Modes
  • SQL Server Instances
  • Upgrading to SQL Server
  • Installing SQL Server
Using the Tools in SQL Server 2008
  • SQL Server Documentation
  • Management Tools in SQL Server
  • Performance Management Tools
  • Business Intelligence Tools
Creating Databases
  • SQL Server System Databases
  • SQL Server Database Structure
  • Creating a Database
  • Moving Databases
Designing Tables
  • Naming Objects
  • Schemas
  • Data Types
  • Column Properties
  • Creating Tables
  • Computed Columns
  • Sparse Columns
  • Constraints
  • Database Diagrams
Indexes
  • Index Structure
  • Clustered Indexes
  • Nonclustered Indexes
  • Included Columns
  • Filtered Indexes
  • Online Index Creation
  • Index Management and Maintenance
  • XML Indexes
  • Spatial Indexes
Partitioning
  • Partition Functions
  • Partition Schemes
  • Partitioning Tables and Indexes
  • Managing Partitions
Database Snapshots
  • Creating a Database Snapshot
  • Reverting Data Using a Database Snapshot
Service Broker
  • Service Broker Architecture
  • Message Types and Contracts
  • Queues and Services
  • Conversations
  • Sending and Receiving Messages
  • Queue Activation
  • Prioritization
Full-Text Indexing
  • Full-Text Catalogs
  • Full-Text Indexes
  • Querying Full-Text Data
Security
  • Configuring the Attack Surface
  • Endpoints
  • Principals, Securables, and Permissions
  • CLR Security
  • Data Encryption
Policy-Based Management
  • Overview of Policy-Based Management
  • Facets
  • Conditions
  • Policy Targets
  • Policies
  • Policy Categories
  • Policy Compliance
Data Recovery
  • Database Backups
  • Recovery Models
  • Database Restores
SQL Server Agent
  • Creating Jobs
  • Creating Maintenance Plans
  • Creating Alerts
Dynamic Management Views
  • Overview of DMVs
  • Retrieving Object Metadata
  • Database Diagnostics
High Availability
  • Failover Clustering
  • Database Mirroring
  • Log Shipping
  • Replication

Additional information

28 hours (usually 4 days including breaks)

SQL Server 2008 Administration Training Course

£ 4,150 VAT inc.