Training Course:SQL Server 2005School/Trainer:Ahana Systems & Solutions (P) Ltd.
Banglore, Karnataka, India
Course Format: Classroom | E-learning | Virtual Class | Online/Live | On-site/In-house | Blended | Self-paced
Teacher/Instructor: Chidanandamurthy
Course Description:
'' MSSQL Server 2005 Database Administration
SQL Server 2005
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.
Please go to the school's official website for training price and schedule:
http://www.ahana.co.in
http://www.ahana.co.in
Phone:080-26675891
School Address/Venue(s):
Ahana Systems & Solutions (P) Ltd.
105/22, Ist floor, 50 Feet Road
Hanumanth Nagar, Near Nirmala Store Bus Stop
Banashankari, Bangalore ��?560050
Jobs & Resumes: Banglore
Houses & Roommates: Banglore
Search other schools for SQL Server 2005 training resources.
Other training courses offered by Ahana Systems & Solutions (P) Ltd.:
Oracle DataGaurd
Oracle 11i Application DBA
Sybase Database Administration
sql server 2005 - performance tuning and optimisation
SQL Server 2005: Analysis Services
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:
Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent. |
|
| 
