Course Name |
Hours |
List Price |
Content |
Advanced Python 3 Programming |
21.00 |
$1,895.00 |
|
Description: In this Python training course, students already familiar with Python programming will learn advanced Python techniques such as Jupyter Notebook, the Collections module, mapping and filtering, lamba functions, advanced sorting, working with regular expressions in Python, working with databases, CSV files, JSON and XM, writing object-oriented code, testing and debugging and learning about Unicode and text encoding. This advanced Python course is taught using Python 3, however, differences between Python 2 and Python 3 are noted.
# of Days:
Setting:
|
OR5460: Introduction to Oracle PL/SQL Programming |
21.00 |
$1,800.00 |
|
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,195.00 |
|
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,195.00 |
|
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:
|