SQL Server DBA

Trendz Information Technologies Ltd.
Hyderabad, AP, INDIA

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Teacher/Instructor: ILIYAS
Term: 2 Days
Seats: 10
Fee: 15000

Course Description:

'' MS SQL Server 2005 DBA

INSTALLING AND CONFIGURING SQL SERVER 2005

�?Preparing to Install SQL Server
�?Installing SQL Server 2005
�?SQL Server Editions
�?Managing a SQL Server 2005 Installation

MANAGING DATABASES AND FILES
�?Planning Databases
�?Creating Databases
�?Monitoring and Managing Filegroup Usage
�?Viewing Database Metadata

DISASTER RECOVERY
�?Planning a Backup Strategy
�?Backing Up User Databases
�?Restoring User Databases
�?Recovering Data from Database Snapshots

MANAGING SECURITY
�?Overview of SQL Server Security
�?Protecting the Server Scope
�?Protecting the Database Scope
�?Managing Keys and Certificates in SQL Server
�?Creating Logins and Assigning Server-Scope Permissions
�?Creating and Managing Users
�?Using a Certificate to Protect Data

MONITORING SQL SERVER
�?Viewing Current Activity
�?Using System Monitor
�?Monitoring SQL Server Performance
�?Need of SQL Profiler
�?Using SQL Server Profiler
�?Need of User defined Template in Profiler
�?Using DDL Triggers

TRANSFERRING DATA
�?Overview of Data Transfer
�?Introduction to SQL Server Integration Services
�?Introduction to BIDS
�?Using SQL Server Integration Services
�?Creating an SSIS Package
�?Features of SQL Server Integration Services
�?Using SSIS to Extract Data, , Sort, and Split Data
�?Using Different Control Flow tasks
�?Using Different Data Flow Items
�?Using Different Transformations
�?Using Different Containers
�?Deploying an SSIS Package

AUTOMATING ADMINISTRATIVE TASKS
�?Automating Administrative Tasks in SQL Server 2005
�?Configuring the SQL Server Agent
�?Configuring DB Mail Server
�?Creating Operators
�?Creating Jobs
�?Creating Alerts
�?Scheduling jobs

IMPLEMENTING REPLICATION
�?Overview of Replication
�?Implementing Replication
�?Configuring Replication in Some Common Scenarios
�?Creating a Publication
�?Creating a Subscription
�?Creating Snapshot Replication
�?Creating Transactional Replication
�?Creating Merge Replication

MAINTAINING HIGH AVAILABILITY
�?Introduction to High Availability
�?Introduction to Log Shipping
�?Introduction to Mirroring
�?Introduction to Clustering
...''

Elements of this syllabus are subject to change.

Phone:9246105453

School Address:

Trendz Information Technologies Ltd.
Image Hospital Lane,
Madhapur, Hitech city,
Hyderabad

Jobs & Resumes: Hyderabad
Houses & Roommates: Hyderabad
Travel Agencies: Hyderabad

Search other schools for SQL Server DBA training resources.

SSIS SSRS SSAS

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.