SQL Training in Bangalore

 

 

 

MS SQL Server DBA

Duration: 45Hours

Pre Requisite: Basic Knowledge RDBMS

Training Type: In-Class / Online

 

 

 

 

 

SQL Server 2008 Overview		Monitoring the Database Server
•	Availability and Scalability Features	•	Managing Metadata Views
•	Security Features	•	Metadata Storage
•	Data Management Features	•	System Views
•Administration and Maintenance Features		•	Information Schema
•	Development Features	•	Catalog Views
•	To enable SQLiMail	•	Sys All
•	Testing mail delivery	•	Dynamic Management Views
		•	System Stored Procedures

Installing SQL Server 2008

Upgrading to SQL Server Management Studio

• Management Studio Windows

• Registered Servers

• Object Explorer

• Review Database Objects

• Modify Database Properties

• Create Database Scripts

• Upgrading to SQL Server Computer Manager

• SQL Server 2008 Network Configuration node

• Configuration node

Database and Index Maintenance

• Index Management

• New Index Features

• Creating Indexes

• Partitioned Tables and Indexes

• XML Index Support

• Altering an Index

• Rebuilding an Index

• Reorganizing an Index

• Disabling an Index

• Dropping an Index

• Index Fragmentation

 

MS SQL Server DBA

 

Duration: 45Hours

Pre Requisite: RDBMS

Training Type: In-Class / Onlin

Securing SQL Server 2008

• Implementing Securables

• New Security Features

• Permission Types

• Managing Logins

• Managing Users

• Managing Schemas

• Managing Execution Context

• Managing Permissions

• Manage Server Permissions

• Manage Server-Scope Securable Permissions

• Manage Database Permissions

 

SQL Server Disaster Recovery

 

• SQL 2008 Disaster Recovery Feature Enhanced Features

• Database Snapshots

• Common Snapshot Applications

• Recovering a dropped object

• Backup and Restore

• Backup Changes

• Restore Changes

• Recovering the MASTER Database

• Create a mirrored backup

 

Database Availability

 

• SQL Server 2008 Data Availability

• Database Mirroring

• Configuring Database Mirroring

• High Availability Operating Mode

• High Protection Operating Mode

• High Performance Operating Mode
• Mirroring Security
• Monitoring Mirroring

Replicating Information

• Replication Enhancements

• Stand-alone Replication Monitor

• Support for Oracle Publishing

• HTTP Synchronization for Merge

• Replication

• Subscriber Initialization

• Replicating DDL Statements

• Modified User Interface

• Replication Management Objects

 

SQL Server 2008 Integration Services

 

• Creating the Database Objects

• Creating a Package Using Business

• Intelligence Studio

• Integration Services Project Template

• OLE DB Command object

• Column Mappings

• Adding a Data Viewer

 

Monitoring and Performance

 

• SQL Server Profiler

• Optimal Data Storage

• Diagnostic Tools

• Query Analyzer

• Database Engine Tuning Advisor

• Index Optimization

• Federated Database Servers

• Partitioned Indexes

• Lock optimization