| 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:
|
| OR5475: Troubleshooting, Debugging and Tuning Oracle PL/SQL Programs |
14.00 |
1.40 |
|
Description: This fast-paced, hands-on course helps the student identify performance issues and problem areas within their PL/SQL code using various techniques and packages. Some of the topics covered include Profiling and Tracing, Debugging, Tuning and Exception Handling. These topics include details on the PL/SQL Optimizer, Subprogram Inlining, Subprogram Invocations, Bulk Binding, Pipelined Table Functions, Helpful Pragmas and Native Compilation and Execution of PL/SQL code. A number of useful Oracle supplied packages are covered including DBMSPROFILER, DBMSTRACE, DBMSHPROF, DBMSWARNING and DBMSPARALLELEXECUTE. Oracle versions 11g and 12c are covered.
# of Days:
Setting:
|
| PHP and MySQL Web Development |
28.00 |
2.80 |
|
Description: MySQL and PHP are two of the most popular open source technologies to emerge during the past decade. PHP (Hypertext Preprocessor) is a powerful, portable, efficient scripting language written for web development. Its functionality far exceeds that of many other programming languages such as ASP or JSP. MySQL is the worlds most popular open source client-server database. Its architecture makes it extremely fast, reliable, and easy to customize. Together, these two technologies provide you with a powerful platform for building database-driven Web applications. This extraordinarily hands-on MySQL and PHP training course covers everything attendees need to successfully build data-driven Web sites using MySQL and PHP.
# of Days:
Setting:
|
| SQ1000: SQL Cross Platform SQL Essentials |
14.00 |
1.40 |
|
Description: Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.
Audience: Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.
# of Days:
Setting:
|
| SQ1010: SQL Cross Platform SQL - Dealing with Complex Queries |
21.00 |
2.10 |
|
Description: Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course.
Audience: Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.
# 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:
|