Oracle PL/SQL

This Oracle PL/SQL course is designed to give users an understanding of Oracle SQL and Oracle PL/SQL languages using Oracle’s SQL*Plus and iSQL*Plus tools. The course covers SQL commands for DML, DDL, Query, and Transaction Control operations.

Students are also introduced to procedural programming using PL/SQL. The course topics are applicable to all versions of Oracle through Oracle 10g.

Who Should Attend:

Application designers and developers, database administrators and operators, and end users should attend this Oracle PL/SQL course.

You Will Learn, Oracle PL-SQL Examples

Upon completion of this Oracle PL-SQL course, students will be able to:

• Explain the difference between SQL, PL/SQL and SQL*PLUS.
• Write basic SQL queries to retrieve desired data.
• Use DML statements (insert, update, and delete).
• Use DDL statements (create, alter, and drop).
• Use transaction control statements to commit, rollback, and create savepoints.
• Write advanced queries.
• Write scripts to do queries and display SQL*PLUS reports.
• Control access to your database objects.
• Write a PL/SQL block using all elements of block structure.
• Write PL/SQL statements using lexical units, declared variables, and assignment statements.
• Use control structures to loop, branch, and jump.
• Use PL/SQL named exceptions and user-defined exceptions.
• Use explicit cursors.

Course Outline, Oracle PL-SQL Questions

• Database Design
• Oracle Standard Interfaces
• The Sample Database
• Data Definition Language
• Data Manipulation Language
• Transaction Control
• SQL Operators
• SQL FUNCTIONS
• Joining Tables
• Set Operators
• SQL Sub-queries
• Groups
• More Database Objects
• Reports
• Introduction
• Declarations and Data Types
• Language Components
• Cursors
• Exceptions
• Functions and Procedures