Training
Oracle
Oracle Database
Oracle Database 12c R2: Advanced PL/SQL Ed 2

7877 Reviews star_rate star_rate star_rate star_rate star_half

Oracle Database 12c R2: Advanced PL/SQL Ed 2

By Request

$3,600 USD

Course Code D80345GC20

Duration 3 days

Available Formats Classroom

Enter your Email to Download Full Course Details

In the Oracle Database 12c R2: Advanced PL/SQL course, students learn how to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and integrate with the other applications in the most efficient manner. They learn to write powerful PL/SQL programs using external C/Java routines, fine-grained access packages, cursors, extended interfaces and collections.

Learn To:

Apply PL/SQL designing best practices.
Create PL/SQL applications that use collections.
Work with JSON data in the database.
Implement a virtual private database with fine-grained access control.
Write code to interface with external C and Java applications.
Write code to interface with large objects and use SecureFile LOBs.
Write and tune PL/SQL code effectively to maximize performance.

Benefits To You

Students will benefit from using advanced features of program design, packages, cursors, extended interface methods, and collections and students learn how to write powerful PL/SQL programs.

Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered. Students learn how to write PL/SQL routines that analyze the PL/SQL applications and caching techniques that can improve performance.

Students are introduced to the Virtual Private Database (VPD) to implement security policies and they learn techniques and tools to strengthen their applications against SQL injection attacks.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Skills Gained

Design PL/SQL packages and program units that execute efficiently
Write code to interface with external applications and the operating system
Create PL/SQL applications that use collections
Write and tune PL/SQL code effectively to maximize performance
Implement a virtual private database with fine-grained access control
Write code to interface with large objects and use SecureFile LOBs
Gain an understanding of the Oracle Database Exadata Express Cloud Service

Prerequisites

Basic Knowledge of SQL, PL/SQL
Knowledge of PL/SQL Program Units
Familiarity with programming languages

Course Details

Introduction

Course Objectives
Course Agenda
Describe the full Human Resources (HR) Schema
Identify the Appendices Used in this Course
Review the online Oracle Database 12c SQL and PL/SQL documentation and the additional available resources
List the PL/SQL development environments Available in this course
Start SQL Developer and Create a Database Connection
Use the SQL Worksheet

Oracle Database Exadata Express Cloud Service

Overview of Oracle Database Exadata Express Cloud Service
Accessing Cloud Database using SQL Workshop
Connecting to Exadata Express Database using Database Clients
Using SQL Developer to work with Exadata Express Database

Overview of Collections

Overview of Collections
Use Associative arrays
Use Nested tables
Use Varrays

Using Collections in PL/SQL

Write PL/SQL programs that use collections
Use Collections effectively
Enhancements to PL/SQL Type Binds
Binding PL/SQL only datatypes to SQL statements using DBMS_SQL

Manipulating Large Objects

Working with LOBs
Overview of SecureFile LOBs

Working with JSON Data

JSON Data
JSON data columns in tables
Generation of JSON data with SQL/JSON generation function
Querying JSON columns
PL/SQL object types for JSON

Using Advanced Interface Methods

Calling External Procedures from PL/SQL
Benefits of External Procedures
Understand how an external routine is called from PL/SQL
C advanced interface methods
Java advanced interface methods
Access PL/SQL blocks from from Java classes using JDBC

Performance and Tuning

Understand and influence the compiler
Tune PL/SQL code
Enable intra unit inlining
Identify and tune memory issues
Recognize network issues
Designing Applications for Real World Performance

Improving Performance with Caching

Describe result caching
Use PL/SQL function cache
Review PL/SQL function cache considerations

Analyzing PL/SQL Code

Finding Coding Information
PL/Scope Concepts
DBMS_METADATA Package
PL/SQL Enhancements
PL/SQL Pragma to mark an item deprecated

Profiling and Tracing PL/SQL Code

What is Tracing and Profiling
Tracing PL/SQL Execution
Tracing PL/SQL: Steps

Securing application through PL/SQL

Controlling Access to Program Units
Managing Access to data using PL/SQL
Creating Secure Application roles to control access to applications

Safeguarding Your Code Against SQL Injection Attacks

SQL Injection Overview
Reducing the Attack Surface
Filtering Input with DBMS_ASSERT

Security Features implemented through PL/SQL

Brief introduction to Security implementation
Fine Grained Access Control
Application Context
List the DBMS_RLS procedures
Implement a policy
Query the dictionary views holding information on fine-grained access

Read Less

0 options available

There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links above. We can also contact you when the course is scheduled in your area.

Request Other Date Request On-site Course

When does class start/end?

Classes begin promptly at 9:00 am, and typically end at 5:00 pm.

Does the course schedule include a Lunchbreak?

Lunch is normally an hour long and begins at noon. Coffee, tea, hot chocolate and juice are available all day in the kitchen. Fruit, muffins and bagels are served each morning. There are numerous restaurants near each of our centers, and some popular ones are indicated on the Area Map in the Student Welcome Handbooks - these can be picked up in the lobby or requested from one of our ExitCertified staff.

How can someone reach me during class?

If someone should need to contact you while you are in class, please have them call the center telephone number and leave a message with the receptionist.

What languages are used to deliver training?

Most courses are conducted in English, unless otherwise specified. Some courses will have the word "FRENCH" marked in red beside the scheduled date(s) indicating the language of instruction.

What does GTR stand for?

GTR stands for Guaranteed to Run; if you see a course with this status, it means this event is confirmed to run. View our GTR page to see our full list of Guaranteed to Run courses.

How do I find an ExitCertified training location?

We have training locations across the United States and Canada. View a full list of classroom training locations.

Which delivery formats are available?

At ExitCertified we offer training that is Instructor-Led, Online, Virtual and Self-Paced.

Does ExitCertified deliver group training?

Yes, we provide training for groups, individuals and private on sites. View our group training page for more information.

What does vendor-authorized training mean?

As a vendor-authorized training partner, we offer a curriculum that our partners have vetted. We use the same course materials and facilitate the same labs as our vendor-delivered training. These courses are considered the gold standard and, as such, are priced accordingly.

Is the training too basic, or will you go deep into technology?

It depends on your requirements, your role in your company, and your depth of knowledge. The good news about many of our learning paths, you can start from the fundamentals to highly specialized training.

How up-to-date are your courses and support materials?

We continuously work with our vendors to evaluate and refresh course material to reflect the latest training courses and best practices.

Are your instructors seasoned trainers who have deep knowledge of the training topic?

ExitCertified instructors have an average of 27 years of practical IT experience. They have also served as consultants for an average of 15 years. To stay up to date, instructors will at least spend 25 percent of their time learning new emerging technologies and courses.

Do you provide hands-on training and exercises in an actual lab environment?

Lab access is dependent on the vendor and the type of training you sign up for. However, many of our top vendors will provide lab access to students to test and practice. The course description will specify lab access.

Will you customize the training for our company’s specific needs and goals?

We will work with you to identify training needs and areas of growth. We offer a variety of training methods, such as private group training, on-site of your choice, and virtually. We provide courses and certifications that are aligned with your business goals.

How do I get started with certification?

Getting started on a certification pathway depends on your goals and the vendor you choose to get certified in. Many vendors offer entry-level IT certification to advanced IT certification that can boost your career. To get access to certification vouchers and discounts, please contact customerexp@exitcertified.com.

Will I get access to content after I complete a course?

You will get access to the PDF of course books and guides, but access to the recording and slides will depend on the vendor and type of training you receive.

How to request a W9 for ExitCertified LLC?

View our filing status and how to request a W9.

Brandon was a great instructor. The virtual course materials and labs provided were very informative.

ExitCertified Student

ExitCertified

Class was easy to sign up for and ExitCertified provided very good communication

James S

ExitCertified

ExitCertified provided great learning material and the instructor was great.

ExitCertified Student

ExitCertified

ExitCertified provided a very organized way to learn and provided materials to follow along.

ExitCertified Student

ExitCertified

The training was very good to understand the concepts and how to set up things .

ExitCertified Student

ExitCertified