Training Course:SQL Server 2005School/Trainer:Ahana Systems and 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:
'' 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:91 80-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 training resources.
Other training courses offered by Ahana Systems and Solutions Pvt Ltd:
oracle 10g database administration
oracle 10g rac
Oracle DataGaurd
Oracle 11i Application DBA
sql server 2005 - performance tuning and optimisation
SQL Server 2005: Analysis Services
SQL Server 2005: Integration Services
sql server 2005: reporting services
sql server 2005: developer
Perl Programming
BASH Shell Scripting and UNIX utilities
VMWARE ESX Administration
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.
Facts:
We serve the schools and students around the world. Major visitors come from India, United States, United Kingdom, Canada, Australia, Philippines, Malaysia, Singapore and South Africa. |
|
|
