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