SQL Basic Skills

SQL

Serebra Learning Corporation
This course will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students willl be able to query and update tables using SQL statements.
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
  • J asked: I have some MS Access Background and now need to upgrade my skills to include SQL through at least an Intermediate Level. Willing to travel for cleasses or take on line provided the price is competative.
SQL Basic Skills
Course Outline - IP1040 - SQL Basic Skills

SQL Basic Skills

Course Code IP1040

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 will provide the student with an overview of database objects, such as tables, indexes, views and triggers. Additionally, the students will be able to query and update tables using SQL statements.

Audience

End Users

Prerequisites

A familiarity with the fundamentals of relational databases, and any programming. language.

Objective

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

  • create and maintain tables
  • query and update databases using SQL statements
  • decide when, where, and how to use SQL statements

Topics Include

Getting Started

  • Overview of Relational Databases
  • An Introduction to SQL
  • Sample Database Design
  • Quiz

Making Basic Queries

  • Building Queries
  • Restricting Query Results
  • Manipulating Query Results
  • Quiz

Making Complex Queries

  • Formatting Query Results
  • Querying Multiple Tables
  • Making Nested Queries
  • Quiz

Manipulating Data

  • Adding Data
  • Modifying Existing Data
  • Deleting Data
  • Quiz

Organizing Data

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

Using Advanced Features

  • Working with Cursors
  • Using Stored 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 basic training?
Custom Search
tcw11-v473M-08/23/11-20:37:21-()[B]-[A]-[A] -18:33:54