SQL SERVER 2008 ADMINISTRATION TRAINING IN CHENNAI

SQL Server 2008 Administration Training Course Content

Overview of Microsoft SQL Server 2008

Database Engine

Business Intelligence

Installing and Configuring SQL Server 2008

Editions of SQL Server 2008

Infrastructure Requirements

Service Accounts

Collation Sequences

Authentication Modes

SQL Server Instances

Upgrading to SQL Server 2008

Installing SQL Server 2008

Using the Tools in SQL Server 2008

SQL Server Documentation

Management Tools in SQL Server 2008

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