|
|
|
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
|
 |
|
