Oracle 18c PL/SQL

Catalog Home Databases, Business Intelligence & Data Science Oracle Programming

This course provides a complete, hands-on, comprehensive introduction to PL/SQL including the use of both SQL Developer and SQL*Plus. This coverage is appropriate for both Oracle11g and higher.

Before taking this course, Oracle12c SQL or higher or equivalent experience is required.

5 Days/Lecture & Lab

This course is appropriate for anyone needing to understand Oracle’s proprietary programming language. That would include end users, business analysts, application developers, and database administrators.

  • PL/SQL Program Structure
  • PL/SQL Flow Control
  • SQL Developer and PL/SQL
  • SELECT INTO
  • The PL/SQL Cursor
  • Optimization
  • PL/SQL Exception Handling
  • Stored Procedures
  • Creating Functions in PL/SQL
  • Packages
  • Creating DML Triggers
  • Advanced Concepts
  • File Operations
  • Communications
  • Security
  • Scheduling
  • Miscellaneous Packages
  • Database Triggers
  • Collections
  • Bulk Operations
  • Cursor Variables
  • Dynamic SQL
  • Large Objects
  • Object-Oriented Programming
  • Java and Other Languages




< >

Recently Viewed Courses:

Copyright © 2019 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media