King Training Resources provides complete coverage of application development with Oracle's database and tools. From introductory-level SQL and concepts through advanced training, our instructors can meet your needs.

Our courses cover the latest releases of Oracle's database and tools including Oracle 12c Release 2.
(and we'll be among the first with Oracle 18 when it is available)

Most courses can be adjusted to cover older versions of Oracle and/or Oracle's development tools. (Oracle 11g, Oracle 10g, Oracle9i, Oracle8i, Oracle8, Oracle 7, Developer 6i, Developer 6.0, Developer 2000, etc...) 

Oracle's products are available to run on a variety of platforms and so are our courses. From PC's running Oracle for Windows through large systems, our classroom labs use any hardware and software mix that supports the products to be covered.

Roadmap to Success

Oracle Course Map

 

Oracle Courses

Oracle 12c New Features for Developers (1-2 Days)
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 12c and its features.
Oracle for Developers with PL/SQL (5 Days)
This course introduces developers to Oracle 12c or 11g, SQL, SQL*Plus, and PL/SQL. (Suitable for Oracle 10g (Oracle9i, or Oracle8i
Oracle SQL and SQL*Plus (3 Days)
This course introduces developers to Oracle 12c or 11g, SQL, and SQL*Plus. This course is a subset of Oracle for Developers. (Suitable for Oracle 10g (Oracle9i, or Oracle8i)
PL/SQL for Developers (2 Days)
Provides skills and practice using PL/SQL to create procedures, functions, packages, triggers stored in the Oracle 12c or 11g database or used in development tools. (Suitable for Oracle 10g, Oracle9i, Oracle8i, or earlier versions)
Advanced PL/SQL (2 Days)
PL/SQL developers will learn to use advanced features enabling improved programming and enhanced performance.
REST Enable Oracle (Tables & PL/SQL) using ORDS (2 Days)
Learn to REST enable Oracle database objects (tables, views, PL/SQL) using ORDS (Oracle REST Data Services).
Oracle Programming with Pro*C/C++ or Pro*COBOL (2 Days)
Covers embedded SQL, error handling, nulls, data matching, arrays, PL/SQL, cursors, and exits.
Oracle SQL Statement Tuning (2 Days)
Students tune SQL statements using DBMS_STATS (ANALYSE ih older releases), AUTOTRACE, EXPLAIN, and TKPROF.
Advanced Topics in Oracle (2-3 days)
Students create and tune complex SQL statements using AUTOTRACE, EXPLAIN, TKPROF and DBMS_XPLAN,understand Oracle data structures, use data dictionary views, backup up and recover data, and use SQL*Loader.
Introduction to Oracle APEX (4 days)
Participants create Oracle Application Express (APEX) web applications and mobile applications.
Oracle DBA Fundamentals (5 days)
Participants learn DBA tasks and skills. Course includes configuration, maintenance, backup & recovery, storage management, performance, security, and more.
Oracle SQL and PL/SQL Update (2-3 days)
Participants improve SQL and other Oracle-related skills so that they may more efficiently and easily satisfy user needs. Latest releases of Oracle products arte explored.
Oracle ADF Java using JDeveloper (5 Days)
Students learn to use Oracle JDeveloper to build Java applications using Oracle Application Development Framework (ADF). Students will use ADF Business Components (ADF BC) to map data via the ADF Model layer’s data binding and then use ADF Faces to build dynamic user interfaces.
Java Web Services using Oracle JDeveloper (2-3 days)
Experienced Java developers learn how to create and use Web Services using the Oracle JDeveloper tool.
 
Oracle Technical Overview (1 Day)
An overview of Oracle's database and tools for business managers, technical managers, and technical personnel.
Oracle for Experienced SQL Developers (3-4 Days)
Introduces experienced SQL Developers and Programmers to Oracle, Oracle SQL, SQL*Plus, PL/SQL, and Oracle's data dictionary. Targeted to those with programming experience using DB2, Sybase, Informix, MS SQL Server, etc.
Oracle SQL Developer (1-2 Days)
Provide hands-on introduction to Oracle's SQL Developer tool for SQL and PL/SQL development.
Oracle SQL and SQL*Plus for End Users (3 Days)
Introduces non-technical personnel to Oracle, SQL, and SQL*Plus.
Oracle 11g Forms (5 Days)
A thorough introduction with hands-on exercises using Oracle 11g Forms, Web deployment, graphical user interface (GUI) controls, PL/SQL, trigger processing, Pluggable Java Components (PJCs) and object support.
Oracle 11g Forms for Client-Server Developers (3 Days)
A course specifically geared to developing Web Forms for those with Oracle Client-Server (10g, 9i, 6i or earlier) Forms.
Developer 10g/9i Reports
Provides a thorough introduction to the Developer 9i Reports product. Students will learn how to create simple and complex reports, use PL/SQL triggers, mailing labels, cross-matrix reports, and how to deploy to the web and other deployment options. 
JDeveloper (2 days)
Experienced Java programmers learn to use Oracle's JDeveloper to develop, integrate, and deploy Java code.
Using JDBC (2 days)
Java programmers learn to use JDBC to work with relational database data in Java programs.
Using SQLJ (2 days)
Java programmers learn to use SQLJ to work with SQL database data (principally DB2 and Oracle) in Java programs.
Oracle and XML (3 days)
Attendees will learn to use XML with the Oracle database. Students will learn how XML DB is used to store and retrieve XML data inside the Oracle database.
Oracle 11g Differences for Developers (1-2 Days)
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 11g and its features.
Oracle 11g/10g Differences for Developers (2 Days)
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 11g and its features along with important features from Oracle 10g.
Oracle 10g Differences for Developers (1-3 Days)
Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle 10g and its features. Expanded coverage of object features will take an additional (third) day.
Developer 10g/9i Forms (5 Days)
A thorough introduction with hands-on exercises using Developer 10g/9i Forms, Web deployment, graphical user interface (GUI) controls, PL/SQL, trigger processing, Pluggable Java Components (PJCs) and object support.
10g/9i Web Forms for Client-Server Forms Developers (3 Days)
A course specifically geared to developing Web Forms for those with Oracle Client-Server (6i or earlier) Forms.
Advanced Developer 10g/9i Forms
Students learn to improve performance, use code libraries, partition logic, use Java API, XML, and create menus.
Developer 6i/6.0 Forms
A thorough introduction with hands-on exercises using Oracle Forms, graphical user interface (GUI) controls, PL/SQL, pop-ups, trigger processing, and object support. Students working with MS-Windows will be introduced to OLE and OCX controls.
(Oracle Forms Version 5.0  available)
Developer 6i/6.0 Reports
Provides a thorough introduction to the Oracle Reports product. Students will learn how to create simple and complex reports, use PL/SQL triggers, mailing labels, and cross-matrix reports.
(Oracle Reports Version 3.0 available)
Advanced Developer 6i/6.0 Forms
Students learn to improve performance, use code libraries, partition logic, use graphics, and create menus.                                       (Advanced Oracle Forms Version 5.0 available)