Our Course just doesn't prepare you for the interview; it prepares you for the Job!



The content of this course is designed, explained and demonstrated with examples by SQL professionals who all have come together for a single purpose; to share their experience and to help you become an SQL expert.
For each section you will be presented with text tutorial where you will be learning concepts by reading through the content. There are videos for each section, which will reinforce your concepts with an example and its explanation. You will be given requirements based on real life SQL projects using which you will be required to develop project modules for the same. A combination of all this would certainly take you places you have never been before.
Chapter 1: SQL Server 2005 Overview
  • New Features for Administrators
  • Availability and Scalability Features
  • Security Features
  • WHAT IS SAS?
  • Security Features
  • Administration and Maintenance Features
  • Development Features
Chapter 2: Installing SQL Server 2005
  • SQL Server 2005
  • Installing Microsoft SQL Server
  • System Requirements
  • Preparing for a SQL 2005 Installation
  • Installation Checklist
  • Setup Features
  • Using the System Consistency Checker
  • Component Install
  • Unattended Installation
  • Installation Sequence
  • Installation Maintenance
  • Upgrading from previous versions of SQL Server
  • Retaining SQL 2000
  • To verify the Installation
Chapter 3: Administrative Tools
  • Upgrading to SQL Server Management Studio
  • Management Studio Windows
  • Registered Servers
  • Object Explorer
  • Review Database Objects
  • Modify Database Properties
  • Create Database Scripts
  • The Maintenance Plans Node
  • Solution Explorer
  • Query Editor
  • Template Explorer
  • Dynamic Help
  • SQL Server 2005 Services node
  • SQL Server 2005 Network Configuration node
  • SQL Server 2005 Native Client Configuration node
  • The SQLCMD Management Utility
  • SQLCMD Syntax
  • Dedicated Administrative Connection
Chapter 4: Monitoring the Database Server
  • Viewing Current Activity
  • Using System Monitor
  • Monitoring with SQL Profiler
  • DDL Triggers
  • Using DDL Triggers
  • Managing DDL Triggers
  • Managing DDL Triggers from TSQL
  • Managing DDL Triggers from Management Studio
  • Managing Metadata Views
  • Metadata Storage
  • System Views
  • Dynamic Management Views
Chapter 5: Database and Index Maintenance
  • Index Management
  • New Index Features
  • Creating Indexes
  • Online Index Maintenance
  • Lock Options
  • Included Columns in Indexes
  • Partitioned Tables and Indexes
  • XML Index Support
  • Altering an Index
  • Rebuilding an Index
  • Reorganizing an Index
  • Disabling an Index
  • Dropping an Index
  • Index Fragmentation
  • Using the Database Tuning Advisor
Chapter 6: Securing SQL Server 2005 / SQL Server 2008
  • Implementing Securable
  • New Security Features
  • Principals
  • Securable
  • Permissions
  • Permission Types
  • Managing Logins
  • Managing Users
  • Managing Schemas
  • Schema Definition
  • Using Schemas
  • Manage Server Permissions
  • Manage Database Permissions
Chapter 7: Automating Administrative Tasks
  • Configuring the SQL Server Agent
  • Creating Jobs and Operators
  • Creating Alerts
  • Managing Multiple Servers
  • Managing SQL Server Agent Security
Chapter 8: SQL Server Disaster Recovery
  • Disaster Recovery
  • SQL 2005 Disaster Recovery Feature
  • Enhanced Features
  • Database Snapshots
  • Creating a Snapshot
  • Common Snapshot Applications
  • Undeleting table rows
  • Undoing a table update
  • Recovering a dropped object
  • Backup and Restore
  • Backup Changes
  • Restore Changes
  • Recovering the MASTER Database
Chapter 9: Enhancing Database Availability
  • SQL 2005 Data Availability
  • Database Mirroring
  • The Witness Server and Automatic Failover
  • Configuring Database Mirroring
  • High Availability Operating Mode
  • High Protection Operating Mode
  • High Performance Operating Mode
  • Mirroring Security
  • Monitoring Mirroring
  • Database States for Database Mirroring
  • Prepare the Servers
  • Configure Mirroring
  • Verify Principal and Mirror Access
  • Execute the Mirror Failover
  • Verify Mirror and Witness Status
  • Terminating the Mirror Session
Chapter 10: Replicating Information
  • Replication Enhancements
  • Stand-alone Replication Monitor
  • Subscriber Initialization
  • Configuring Peer-to-Peer Replication
  • Create a Publication

Got any queries? Talk to the counselor

Ph: +91-9886096424 / 080-46441086
Email: university@siliconindia.com
Join a Course Now

Contact counselors

Call us now:
+91-9886096424
080-46441086

Email us:

university@siliconindia.com