Training Classes | Learning and Development Resources | Training Directory | New Training Programs | New Training Providers | Site Map | Promote Training | Training Keywords | Training Programs | Training Providers | Regions | Training Search | Advertise Training Programs | Login
Provided by: Serebra Learning Corporation

SQL Advanced Skills

Click here for more information or to take this course
Serebra Learning Corporation


  home  : Computer  : Databases and SQL  : SQL

Get More Information
Search for Training
Find Your Genius!
What do you want to learn about?

Training Provided by Serebra Learning Corporation

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.

Training Avaliability and Delivery

This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Contact Serebra Learning Corporation for more information
Schedule:3 hours
Training Presented in:English

Related Keywords:  tables   sql   sql   advanced   skills 

Training Program Details


Course Outline - IP1050 - SQL Advanced Skills

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


click to enlarge

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

Serebra Learning Corporation, 600 - 1188 West Georgia, Vancouver, BC    V6E 4A2 Canada
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com

About Serebra Learning Corporation - Training Provider

Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...

More Training from Serebra Learning Corporation

Click here for more information or to take this course

Training Directory | New Training Programs | New Training Providers | Search | Site Map | Promote Training | Login | Links


Connecting people who want to learn with people who love to teach
 Are you a Tables training provider?
You could be on this page today - for FREE!