Oracle PL/SQL Training and Seminars

Oracle SQL and PL/SQL: Basic Concepts The Oracle SQL and PL/SQL: Basic Concepts WBT is the first course in this curriculum. This course will explain basic concepts regarding a DBMS, RDBMS, and ORDBMS and give an Oracle implementation of these. It will also provide users with the basic functionality of PL/SQL for creating, viewing, maintaining, and altering data in Oracle.  more...

Basic PL/SQL Programming The Basic PL/SQL Programming WBT is the second course in this curriculum. This course will enable users to create views, sequences, synonyms, records, tables, functions, and procedures. Additionally, it will enable users to create different kinds of PL/SQL blocks.  more...

Advanced PL/SQL Programming Advanced PL/SQL Programming  more...

Oracle SQL Specifics: Retrieving and Formatting Data This course is the first in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Students will be introduced to the Oracle implementation of the relational database management system (RDBMS) and the object-relational database management system (ORDBMS). Users will learn how SQL  more...

Oracle SQL Specifics: Creating and Managing Database Objects This course is the second in a two-part series on Oracle SQL Specifics that will teach participants how to use commands functions and operators supported by Oracle as extensions to standard SQL. Users will learn how to create and manage tables build integrity constraints and use the COMMIT and ROLLBACK statements to control transactions. Learners will create and maintain views sequences indexes  more...

Oracle SQL and SQL*Plus: Advanced SELECT Statements This course is the first course in a two-part series which covers advanced SQL and SQL*Plus. This course introduces the learner to the advanced SELECT statements and the use of subqueries in Oracle Statements. In addition this course explores the functions used in Oracle and covers the use of set operators to combine two or more queries.  more...

Oracle SQL Tuning: Diagnostics and Tuning the Schema This course is the first in a two-part series on SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths such as partitioned views B-tree indexes bitmapped indexes index clusters and hash clusters. Participants will  more...

Oracle SQL for End Users Part 1 Oracle SQL and SQL*Plus are powerful components of Oracle's relational and object relational database management systems. This course is designed for end users who want to learn how to write SQL SELECT statements to retrieve data from a database. This course identifies relational database properties introduces the Oracle server and indicates how SQL and SQL*Plus are used in the Oracle product  more...

Oracle SQL for End Users Part 2 This course is the second in a two-part SQL for End Users series that is based on Introduction to Oracle: SQL and PL/SQL. In this course the learner displays data from multiple tables by using equijoins non-equijoins and self joins. In addition this course introduces the use of group functions in a SQL statement to display information about groups of rows in the database. This course also covers  more...

Oracle SQL: Basic SELECT Statements This course is the first in a three-part Oracle SQL series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course introduces the learner to Oracle relational database concepts and the use of SQL for storing retrieving and manipulating data in a relational database. This course covers relational database principles and Oracle concepts; writing basic SQL statements;  more...

Oracle SQL: Data Retrieval Techniques This course is the second in a three-part Oracle series that is based on the ILT course Introduction to Oracle: SQL and PL/SQL. This course describes how to access data from more than one table using joins and aggregating data using group functions. This course also describes how to embed a SQL statement in a clause of another SQL statement to enhance the power of SQL queries. In addition how to  more...

Oracle SQL: DML and DDL This course is the third in a three-part Oracle SQL series that is based on the Oracle ILT course Introduction to Oracle: SQL and PL/SQL. Using the Oracle SQL*Plus environment this computer-based training course uses Structured Query Language (SQL) to create and populate Oracle database tables. Learners create tables and other database objects and learn to maintain and modify these data objects.  more...

Oracle PL/SQL: Basics This course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming. Numerous  more...

Oracle PL/SQL: Procedures, Functions and Packages This is the first course in a two part series. It introduces the learner to the basics of PL/SQL subprograms. This course covers the building and invoking of procedures and functions. Additionally this course introduces the basics of creating and using packages.  more...

Oracle PL/SQL: Database Programming This is the second course in a two part series that discusses the features of stored subprograms and packages. This course explains how to create and execute stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. This course covers how to manage stored subprograms and  more...

Advanced Oracle PL/SQL: Design Considerations and Object Types This course introduces students to subtypes subprograms cursor variables and the NOCOPY parameter used in advanced function definitions and packages. Students also learn about object types data dictionary views and collections.  more...

Advanced Oracle PL/SQL: Implementation and Advanced Features This course introduces students to advanced interface methods practices and techniques that improve the efficiency and performance of PL/SQL operations. Students also learn about essential Oracle supplied packages that are commonly used in developing applications.  more...

Oracle9i PL/SQL: Basics The Oracle9i PL/SQL: Basics course introduces the learner to the basics of PL/SQL. The course builds the necessary skills for using Oracle PL/SQL. It will help the learner acquire the expertise to design develop and implement Oracle Server applications by using Oracle Structured Query Language (SQL) and PL/SQL. The learner is guided step-by-step through the various aspects of PL/SQL programming.  more...

Oracle9i PL/SQL: Procedures Functions and Packages This course introduces users to the basics of PL/SQL subprograms. Users will learn how to build and invoke procedures and functions. This course also covers debugging PL/SQL subprograms using Procedure Builder. Additionally users will learn how to trap and handle errors in a PL/SQL block. This course also covers the basics of packages and how to create and use them.  more...

Oracle9i PL/SQL: Database Programming This course discusses the features of stored subprograms and packages. Participants will learn how to create and invoke stored procedures and functions as well as how to create stored packages. This course also discusses built-in server-side packages and their use in debugging stored subprograms. Participants will learn how to manage stored subprograms and packages. This course also introduces  more...

Oracle Application Server: Getting Started with PL/SQL Web Applications This course introduces PL/SQL programmers to the essential concepts and techniques needed to build and deploy applications on Oracle Application Server. You will learn how to create PL/SQL packages that output interactive Web pages with database content including HTML tables and forms.  more...

Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses such as WHERE ORDER BY and DISTINCT. You  more...

Oracle 8i PL/SQL - Functions, Tables, and Groups This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions number functions and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from more than one table by using  more...

Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary In this course you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. Furthermore the course discusses the SQL *Plus format commands and script files. The concept of data dictionary tables and views is also covered in the course. Related Exam: Oracle Exam #1Z0-001:  more...

Oracle 8i PL/SQL - DML and DDL Statements This course introduces the DDL and DML statements. It explains the concept of creation of tables and views. It also covers the various commands for manipulating a database. In addition the course explains the transaction processing features. It highlights the concept of altering a table definition in a database dropping a table adding comments to a table and renaming a table. It describes the  more...

Oracle 8i PL/SQL - Database Objects and Security This course is aimed at familiarizing the learner with the inbuilt objects and security options in Oracle. The course includes creating and managing sequences indexes and users. It also includes PL/SQL block PL/SQL records and tables PL/SQL variables and datatypes. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.  more...

Oracle 8i PL/SQL - Oracle PL/SQL Basic Operations The course is aimed at familiarizing the learner with the basic concepts of PL/SQL. It describes the different datatypes and variables available with PL/SQL. The course provides an overview of PL/SQL records and tables and explains how to access a database from PL/SQL. It also describes the steps to write conditional constructs and controlling structures in PL/SQL along with different types of  more...