Oracle Database 12c Advanced PL/SQL 1.0 Training & Placements in Chennai SQL STAR

Oracle Database 12c R2: Advanced PL/SQL Ed 2
(Course materials and Course Completion Certificates are directly delivered from Oracle University to those required for Foreign Opportunity)

(Government of India Approved Education Center)

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 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:

• ApplyPL/SQL designing best practices.
• CreatePL/SQL applications that use collections.
• Work with JSON data in the database.
• Implement a virtual private database with fine-grained access control.
• Writecode to interface with external C and Java applications.
• Writecode to interface with large objects and use SecureFile LOBs.
• Writeand 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.
Prerequisites
Suggested Prerequisite

• BasicKnowledge of SQL, PL/SQL
• Familiarity with programming languages
• Knowledgeof PL/SQL Program Units

Required Prerequisite

• Oracle Database 12c R2: SQL Workshop
• Oracle Database: Develop PL/SQL Program Units Ed 2

Audience

• Technical Consultant
• Application Developers
• Database Administrators
• Database Administrators
• Support Engineer
• Support Engineer

Course Objectives

• DesignPL/SQL packages and program units that execute efficiently
• Writecode to interface with external applications and the operatingsystem
• CreatePL/SQL applications that use collections
• Learnto work with JSON data in relational database
• Writeand tune PL/SQL code effectively to maximize performance
• Implement a virtual private database with fine-grained access control
• Writecode to interface with large objects and use SecureFile LOBs

Course Topics
Introduction

• Listthe PL/SQL development environments Available in this course
• StartSQL Developer and Create a Database Connection
• Course Objectives
• Use the SQL Worksheet
• CourseAgenda
• Reviewthe online Oracle Database 12c SQL and PL/SQL document ation andthe additional available resources
• Identifythe Appendices Used in this Course
• Describe the full Human Resources (HR) Schema

Oracle Database Exadata Express Cloud Service

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

Overview of Collections

• UseNested tables
• UseAssociative arrays
• UseVarrays
• Overview of Collections

Using Collections in PL/SQL

• Enhancementsto PL/SQL Type Binds
• UseCollections effectively
• Binding PL/SQL only datatypes to SQL statements using DBMS_SQL
• WritePL/SQL programs that use collections

Manipulating Large Objects

• Overview of SecureFile LOBs
• Working with LOBs

Working with JSON Data

• PL/SQLobject types for JSON
• Querying JSON columns
• JSONdata columns in tables
• Generationof JSON data with SQL/JSON generation function
• JSONData

Using Advanced Interface Methods

• Benefitsof External Procedures
• Javaadvanced interface methods
• Cadvanced interface methods
• AccessPL/SQL blocks from from Java classes using JDBC
• Understandhow an external routine is called from PL/SQL
• Calling External Procedures from PL/SQL

Performance and Tuning

• Designing Applications for Real World Performance
• Understandand influence the compiler
• Recognizenetwork issues
• Identifyand tune memory issues
• Enableintra unit inlining
• TunePL/SQL code

Improving Performance with Caching

• ReviewPL/SQL function cache considerations
• UsePL/SQL function cache
• Describeresult caching

Analyzing PL/SQL Code

• PL/ScopeConcepts
• PL/SQLEnhancements
• PL/SQLPragma to mark an item deprecated
• Finding Coding Information
• DBMS_METADATAPackage

Profiling and Tracing PL/SQL Code

• Whatis Tracing and Profiling
• Tracing PL/SQL Execution
• Tracing PL/SQL: Steps

Securing application through PL/SQL

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

Safeguarding Your Code Against SQL Injection Attacks

• Filtering Input with DBMS_ASSERT
• SQLInjection Overview
• Reducing the Attack Surface

Security Features implemented through PL/SQL

• Listthe DBMS_RLS procedures
• Briefintroduction to Security implementation
• FineGrained Access Control
• Implement a policy
• Querythe dictionary views holding information on fine-grained access
• Application Context