SQL Server 2005: Database Administration

Ahana Systems & Solutions Pvt. Ltd
Bangalore, India

Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: Chidanandamurthy

Course Description:

'' Module 1: Installing and Configuring SQL Server 2005

Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Module 2: Managing Databases and Files

Planning databases.
Creating databases.
Managing databases.
Module 3: Disaster Recovery

Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Module 4: Managing Security

Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Managing Keys and Certificates in SQL Server.
Module 5: Monitoring SQL Server

Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Module 6: Maintaining the Database

DBCC Commands
Managing Database Maintenance
Module 7: Transferring Data

Overview of Data Transfer.
Introduction to SQL Server Integration Services.
Using SQL Server Integration Services.
Module 8: Introduction to Analysis Services

Understanding Analysis Services
Creating a Unified Dimensional Model
Module 9: Introduction to Reporting Services

Understanding Reporting Services
Configuring Reporting Services
Building a Simple Report
Creating, Publishing, and Viewing Reports
Module 10: Automating Administrative Tasks

Automating Administrative Tasks in SQL Server 2005.
Configuring the SQL Server Agent.
Creating Jobs and Operators.
Creating Alerts.
Managing Multiple Servers.
Managing SQL Server Agent Security.
Module 11: Maintaining High Availability

Introduction to High Availability.
Introduction to Server Clustering.
Introduction to Database Mirroring.
Introduction to Log Shipping.
Module 12: Introduction to Replication

Overview of Replication.
Replication Scenarios.
...''

Elements of this syllabus are subject to change.

Phone:080-26675891

School Address/Venue(s):

105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore �560050



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

Search other schools for SQL Server 2005: Database Administration training resources.

oracle 10g database administration
tutor led online - oracle 10g database administration
oracle 10g rac
installing and configuring sql server 2005
SQL Server 2005: Implementing and Maintaining Analysis Services (SSAS)
sql server 2005: implementing and maintaining reporting services (ssrs)
sql server 2005: developer

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: ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges.