|
Provided by: Ahana Systems and Solutions (P) Ltd SQL Server 2005 DBA onlineTrainingMS SQL Server |
 |
Training
Provided by Ahana Systems and Solutions (P) Ltd
SQL Server 2005 installation, administration, management
|
|
||||||||||||
SQL Server 2005 DBA onlineTraining
SQL Server 2005 Database Administration
Module 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Module 2: Programming with T-SQL
Variables
Procedural Flow
Examining SQL Server with Code.
Temporary Tables and Table Variables
Dynamic SQL
Error Handling
Module 3: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Module 4: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Module 5: Managing Security
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Managing Keys and Certificates in SQL Server.
Module 6: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Module 7: Maintaining the Database
DBCC Commands
Managing Database Maintenance
Module 8: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services.
Using SQL Server Integration Services.
Module 9: Introduction to Analysis Services
Understanding Analysis Services
Creating a Unified Dimensional Model
Data Mining
Module 10: Introduction to Reporting Services
Understanding Reporting Services
Configuring Reporting Services
Building a Simple Report
Creating, Publishing, and Viewing Reports
Module 11: 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 12: Maintaining High Availability
Introduction to High Availability.
Introduction to Server Clustering.
Introduction to Database Mirroring.
Introduction to Log Shipping.
Module 13: Introduction to Replication
Overview of Replication.
Replication Scenarios.
Module 1: Installing and Configuring SQL Server 2005
Preparing to install SQL Server.
Installing SQL Server.
Managing a SQL Server 2005 Installation.
Module 2: Programming with T-SQL
Variables
Procedural Flow
Examining SQL Server with Code.
Temporary Tables and Table Variables
Dynamic SQL
Error Handling
Module 3: Managing Databases and Files
Planning databases.
Creating databases.
Managing databases.
Module 4: Disaster Recovery
Planning a Backup Strategy.
Backing Up User Databases.
Restoring User Databases.
Recovering Data from Database Snapshots.
System Database and Disaster Recovery.
Module 5: Managing Security
Overview of SQL Server Security.
Securing the Server Scope.
Securing the Database Scope.
Managing Keys and Certificates in SQL Server.
Module 6: Monitoring SQL Server
Viewing Current Activity.
Using System Monitor.
Using SQL Server Profiler.
Using DDL Triggers.
Using Event Notifications.
Module 7: Maintaining the Database
DBCC Commands
Managing Database Maintenance
Module 8: Transferring Data
Overview of Data Transfer.
Introduction to SQL Server Integration Services.
Using SQL Server Integration Services.
Module 9: Introduction to Analysis Services
Understanding Analysis Services
Creating a Unified Dimensional Model
Data Mining
Module 10: Introduction to Reporting Services
Understanding Reporting Services
Configuring Reporting Services
Building a Simple Report
Creating, Publishing, and Viewing Reports
Module 11: 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 12: Maintaining High Availability
Introduction to High Availability.
Introduction to Server Clustering.
Introduction to Database Mirroring.
Introduction to Log Shipping.
Module 13: Introduction to Replication
Overview of Replication.
Replication Scenarios.
About The Training Provider: Ahana Systems and Solutions (P) Ltd
Ahana Systems and Solutions (P) Ltd - Oracle9i DBA
Oracle 10g DBA
Oracle 10g RAC
Sybase DBA
ASE DBA
Sybase Replication DBA
Oracle DBA
MSSQL DBA
MySQL DBA
Perl scripting
Shell scripting
Clearcase Administration
Linux Administration
VMWare
Windows Administration
Our In-house training is aimed at individuals who want to build their career in IT infrastructure field. Its mainly aimed at studends who are in the verge of...
