SQL Advanced Skills

Course Code IP1050

Contents

1. Contents
2. Description
3. Audience
4. Prerequisites
5. Objectives
6. Topics Include
7. Duration
8. Minimum Requirements
9. Media

Screenshot

Description

This course is the second course in the SQL Programming curriculum that consists of two courses. The course describes the statements used to manipulate data and to work with tables, indexes, and views. The students will also be able to describe the functioning of cursors, stored procedures, triggers, and transactions.

Audience

Application developers who want to implement a database solution with MS SQL Server client/server database management system.

Prerequisites

Before taking this course, the user should be familiar with the concepts and features of the database systems, particularly those of a relational database system, and should be able to perform queries on databases.

Objective

Upon completion of this course, the student will be able to:

• define a relational database
• insert new records in an existing table
• insert records from another table
• update data in a table
• delete data from a table
• create tables
• modify tables
• create indexes
• manipulate indexes
• create views
• create cursors
• create stored procedures
• create and implement triggers
• perform transactions

Topics Include

Working with Existing Tables

• Adding Data to a Table
• Modifying Existing Data
• Quiz

Creating and Modifying Tables

• Creating Tables
• Working with Indexes
• Working with Views
• Quiz

Using Advanced Features of SQL

• Working with Cursors
• Using Store Procedures
• Using Triggers
• Managing Transactions
• Quiz

Duration

4 hrs

Minimum Requirements

Netscape or Internet Explorer (versions 4.0 or higher). Browsers should be capable of accepting cookies; SVGA Hi-color mode 800x600 resolution display. Macromedia Shockwave 6.02 or higher.

Media

Web Based Training