|
SQL Server DBA
Course Curriculum
Overview of the SQL server
- Architecture of sql server
- The major versions and editions, upgrades
from sql
- Installing SQL server and client
components
- Pre-requisites, system configuration
check
- installing selected components
- High availability using Clustering
SQL server clustering concept
- 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
- Notifications using sql server agent
- Creating, managing, maintaining jobs,
alerts
- Notifications through mails
- Implementing Replication
- Configuring various methods of
replications
- New Features of SQL
- Features that are indulged from old
version SQL
- Resource Governor, Activity Monitor,
Intellisense
- Auditing, Plug-in model for SSMS
- Central Management Servers
- Sql Server Analysis Services (SSAS)
- Creating Measurements, dimension, cubes
- 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
|
|
No comments:
Post a Comment