Offering : SQL Server 2005 Online, Onsite Training
Posted on November 04, 2009 05:35 am - All Ads by this Poster - Email to friend
Safety Warning
Users are recommended to deal face-to-face and avoid distant users. eClassifieds4U does not offer any payment/transaction services.
Read more about Safety Tips.
Details:
- Price
- (Contact Us)
- Location
- Bangalore, M4B 1B3
View Map - Phone
- 44 20 7993 8018
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.
