SQL Server 2005 offers a robust architecture for enterprise data management, developer productivity and business intelligence. The ability to employ and capitalize on this powerful feature set is essential for an organization in the current competitive market.

This course provides the knowledge and practical skills needed to exploit SQL Server 2005. You gain a solid foundation on which to build essential SQL Server development and administrative skills.

• Creating Databases.
• Creating Filegroups.
• Creating Schemas.
• Creating Database Snapshots.
  
  Creating Data Types and Tables
• Creating Data Types.
• Creating Tables.
• Creating Partitioned Tables.
  
  Using XML
• Retrieving XML by Using FOR XML.
• Shredding XML by Using OPENXML.
• Using the xml Data Type.
  
  Creating and Tuning Indexes
• Planning Indexes.
• Creating Indexes.
• Optimizing Indexes.
• Creating XML Indexes.
  
  Implementing Data Integrity
• Data Integrity Overview.
• Implementing Constraints.
• Implementing Triggers.
• Implementing XML Schemas.
  
  Implementing Views
• Introduction to Views.
• Creating and Managing Views.
• Optimizing Performance by Using Views.
  
  Implementing Stored Procedures and Functions
• Implementing Stored Procedures.
• Creating Parameterized Stored Procedures.
• Creating Functions.
• Handling Errors.
• Controlling Execution Context.
  
  Using Service Broker
• Service Broker Overview.
• Creating Service Broker Objects.
• Sending and Receiving Messages.
  
  Module II [Maintaining]
  
  Disaster Recovery
• Planning a Backup Strategy.
• Backing Up User Databases.
• Restoring User Databases.
• Recovering Data from Database Snapshots.
• System Database and Disaster Recovery.
  
  Managing Security
• Overview of SQL Server Security.
• Securing the Server Scope.
• Securing the Database Scope.
• Managing Keys and Certificates in SQL Server.
  
  Monitoring SQL Server
• Viewing Current Activity.
• Using System Monitor.
• Using SQL Server Profiler.
• Using DDL Triggers.
• Using Event Notifications.
  
  Transferring Data
• Overview of Data Transfer.
  
  Integration Services
• Using SQL Server Integration Services.
  
  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.
  
  Maintaining High Availability
• Introduction to High Availability.
• Implementing Server Clustering.
• Implementing Database Mirroring.
• Implementing Log Shipping.
  
  Introduction to Replication
• Overview of Replication.
• Replication Scenarios.
  
  Certifications
  
  After Completing this module participants will be able to take following exam
  
  Microsoft SQL Server 2005-Implementation and Maintaining Exam 70-431
  
  Course Duration: 3 months
  
  Classes on Sundays Only
  
  Fee
  
  Registration fee is Rs.100/=
  
  Course Fee: Rs. 3,000/=