| Course Name |
Hours |
CEUs |
Content |
| OR5460: Introduction to Oracle PL/SQL Programming |
21.00 |
2.10 |
|
Description: The course provides a comprehensive introduction to PL/SQL, Oracles procedural language extension to SQL. PL/SQL is used to write stored procedures, packages, and database triggers. PL/SQL will be of particular interest to individuals developing applications in a client-server or multi-tier environment.This course can be taught for any Oracle version.
# of Days:
Setting:
|
| OR5470: Oracle Advanced PL/SQL Programming |
14.00 |
1.40 |
|
Description: The course provides attendees with the background to develop stored PL/SQL programs including functions, procedures, packages, and triggers.Commonly used predefined packages provided with the Oracle DBMS are examined. Discussions include how these packages could be used as part of in-house applications. Additional PL/SQL features such as overloading programs, collections (arrays), bulk processing and autonomous transactions are also presented. Workshops provide students with the opportunity to use these features and evaluate their potential role in an application. This course can be taught for any Oracle version.
# of Days:
Setting:
|
| SQL Level 1 for Windows |
7.00 |
0.70 |
|
Description: In this course you will cover how to: connect to the SQL Server database and execute a simple query, include a search condition in a simple query, use various functions to perform calculations on data, organize data, retrieve data by combining information from multiple tables present query results in a report.
# of Days:
Setting:
|
| SQL Level 2 for Windows |
7.00 |
0.70 |
|
Description: In this course you will cover advanced techniques for querying a database including how to: code subqueries to generate query output, manipulate table data by inserting, updating and deleting records in a table, create a simple table, create tables with constraints, modify the table structure, and delete tables, create views, manipulate data through views, modify the view structure and drop views index data.
# of Days:
Setting:
|