SQL DBA ONLINE TRAINING

 MS SQL 2008 DBA

   Introduction to SQL server 2008 - 02 Hrs

• The basic architecture of sql server, the major versions and editions, upgrades from sql 2000 and2005

• Installing SQL server and client components 
• Pre-requisites, system configuration check, installing selected components
• High availability using Clustering 

   SQL server clustering concepts

• Security / User role management 
• Authentication modes, user and roles management

• Object management 
• Creating, managing and maintaining databases / tables / indexes / views / stored procedures / user

          defined functions

• Monitoring activity 
• Monitoring the tasks, audits, sql profiler

• Backup and restore 
• Taking different types of backups and restoring.

• Backup and restore compression.

• Implementing Disaster recovery 

• Configuring log shipping
• Automation of tasks, alerts and notifications using sql server agent

• Creating, managing, maintaining jobs, alerts and notifications through mails etc

• Implementing Replication 

• Configuring various methods of replications

• New Features of SQL 2008 

• Features that are indulged from SQL 2008 like Resource Governor, Activity Monitor, Intellisense,

         Auditing, Plug-in model for SSMS, Central Management Servers etc

• Sql Server Analysis Services (SSAS) 
• Creating Measurements, dimension, cubes in BIDS or MSVS.
• Importing the cubes in SSAS, processing cubes, editing cubes, managing cubes
• Sql Server Reporting Services (SSRS) 
• Installing, Configuring and maintaining SSRS

• Sql Server integration Services (SSIS) 
• Exporting and importing SSIS packages

• Clarifications and discussions.