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

 

 

Testimonials

"The Oracle PL-SQL training was nice, helped me a lot thanks for your support and training." – Swathi (Oracle PL-SQL)