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 Oracle10g, JDeveloper 10g, and Developer 10g.

Most courses can be adjusted to cover older versions of Oracle and/or Oracle's development tools. (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 Courses

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.
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 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.
Oracle9i Differences for Developers (1-3 Days): Students familiar with earlier versions of Oracle's RDBMS are introduced to Oracle9i and its features. Object Features normally comprise most of the third day, they can be expanded upon or deleted as requested. Course may include Oracle8i issues too.
Oracle for Developers with PL/SQL (5 Days): This course introduces developers to Oracle 10g, SQL, SQL*Plus, and PL/SQL. (Suitable for Oracle9i, or Oracle8i; (Oracle 7 version available)
Oracle SQL and SQL*Plus (3 Days): This course introduces developers to Oracle 10g, SQL, and SQL*Plus. This course is a subset of Oracle for Developers. (Suitable for Oracle9i, or Oracle8i; Oracle 7 version available)
PL/SQL for Developers (2 Days): Provides skills and practice using PL/SQL to create procedures, functions, packages, triggers stored in the Oracle 11g and/or 10g database or used in development tools. (Suitable for 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.
Oracle Programming with Pro*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 and TKPROF,understand Oracle data structures, use data dictionary views, backup up and recover data, and use SQL*Loader.
Oracle Technical Overview (1 Day): An overview of Oracle's database and tools for business managers, technical managers, and technical personnel. (Oracle8i, Oracle8 and Oracle 7 versions available)
Oracle for Experienced SQL Developers (3 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 and SQL*Plus for End Users (3 Days): Introduces non-technical personnel to Oracle, SQL, and SQL*Plus.
Developer 10g/9i Forms: 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: A course specifically geared to developing Web Forms for those with Oracle Client-Server (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.
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)
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.