Home Technical Education Mentoring & Consulting Courseware Enrollment Contact Info
 

 

 

 

SQL Programming

Course Description

This course gives students a basic knowledge of relational databases and how to access them through SQL. This training covers topics that are necessary to the development and administration of a database.

Who Should Attend

Application designers, developers, database administrators.

Prerequisites

An understanding of relational database design concepts.

What you will learn:

  • To converse in relational database terminology
  • Structures Query Language basics
  • WHERE Clause
  • Data Types
  • Functions
  • Data Manipulation
  • Ordering & Grouping
  • Indexing
  • Joining Tables
  • Transactions (Commit & Rollback)
  • Subqueries
  • Importing and Exporting
  • Insert, update & delete information in database tables
  • Create and drop tables, views, synonyms and indexes

 

DB2 SQL Programming

Course Description

This course covers the DB2 7 SQL programming language. Students will control data sharing and locking, develop an understanding of multi-user and concurrent transactions, and develop database triggers, stored procedures and functions.

Who Should Attend

Application designers, developers, database administrators and users who need a fundamental understanding of DB2 7 or the SQL language.

Prerequisites

Student should have a basic knowledge about SQL.

What you will learn:

  • The DB2 SQL Environment
  • Update, Insert and Delete Statements
  • Variable Scope Rules
  • Error Report Functions
  • Debugging Procedures
  • Logical Comparisons
  • Define and Execute Procedures
  • Define Functions

 

Oracle PL/SQL Programming

Course Description

This course covers the Oracle 8i PL/SQL programming language. Students will control data sharing and locking, develop an understanding of multi-user and concurrent transactions, and develop database triggers, stored procedures and functions.

Who Should Attend

Application designers, developers, database administrators and Oracle7 users who need a fundamental understanding of Oracle 8i, PL/SQL or the SQL language.

Prerequisites

Student should have a basic knowledge about SQL.

What you will learn:

  • The PL/SQL Environment
  • PL/SQL Program Structure
  • Update, Insert and Delete Statements
  • Variable Scope Rules
  • Error Report Functions
  • Debugging Procedures
  • Logical Comparisons
  • Define and Execute Procedures
  • Define Functions