Advanced PL/SQL Tips and Techniques

Catalog Home Databases, Business Intelligence & Data Science Oracle Programming

There are no scheduled dates for this course.

  Available by Request

Give your IT staff the knowledge of using advanced features of Oracle's procedural language: PL/SQL. The focus of this course is to advance attendee knowledge of the PL/SQL programming language. This is an excellent course for those people that need a better knowledge of the PL/SQL language. This course covers all the latest features of PL/SQL using databases Oracle10g, Oracle11g and Oracle12c.The attendees have the opportunity to learn how to find the poorly-performing components of PL/SQL routines, use Oracle's newer DEBUG routines to find problems in PL/SQL logic and how to use the latest features of the PL/SQL language such as the new optimizing compiler and collections. The course contains additional white papers on Java and PL/SQL and executing external procedures.The course utilizes a variety of current tools. Students will have the opportunity to learn more about TOAD, SQL Developer, as well as the Oracle tools like SQL*Plus.

A working knowledge of SQL and PL/SQL is required.

3 Days/Lecture & Lab

Attendees receive a hands-on opportunity to learn more about Oracle, TOAD, and SQL Developer.

  • Advanced Oracle PL/SQL Overview/Review
  • Working with Cursors, Collections, and Oracle Provided Packages
  • DBMS_SQL & Dynamic SQL




< >

Recently Viewed Courses:

Copyright © 2018 ProTech. All Rights Reserved.

Sign In Create Account

Navigation

Social Media