SQL Advanced Skills

SQL

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.
This is primarily online training
on-line e-learning cbt (computer based)This is an online eLearning or CBT training program
Duration:3 hours
Training Presented in:English
Training Provided by Serebra Learning Corporation
  • S asked: Kindly let me know the cost for this course
  • B asked: I would like to get started with oracle sql dbms or even get started with advanced classes too. is this online ir how does this work. please let me know ASAP. Thank you
SQL Advanced Skills
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, 1660 - 999 W Hastings St, Vancouver, BC, Canada   V6C 2W2
Tel: (604) 676-5480 or 1-800-567-7766 - Fax: (604) 676-5490
E-Mail: sales@serebra.com - Web Site: www.serebra.com
About The Training Provider: Serebra Learning Corporation
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...
Do you offer advanced training?
Custom Search
tcw11-v473M-08/23/11-16:05:38-()[B]-[B]-[B] -00:04:11