SQL Server Database Management & Programming

Duration: 18 hours

Description: Learn everything you need to be productive with SQL Server 2005. This course gives you hands-on exposure to database design and creation, security, diagramming, backup, recovery, indexes, views, stored procedures, triggers and basics of reporting services. SQL Server 2005 Express Edition is used in this course.

Course Content:

SQL Server Express Overview and Installation

SQL Server Management Studio Express

Database Design & Creation

Security

Defining Tables

Creating Indexes & Database Diagramming

Working with Data

Building a View

Stored Procedures

T-SQL Essentials

Triggers

Reporting Services Basics