Register for Waitlist
,
This class if full now. You can register on the wait list to be notified when a seat becomes available.
Oracle Database 12c R2: Advanced PL/SQL Ed 2 Training
Live Online & Classroom Enterprise Certification Training
Powered By
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.
Powered By
Looking for a private batch ?
REQUEST A CALLBACKNeed help finding the right training?
-
Certified Trainer
-
Authorized Courseware
-
Completion Certificate from ATP
-
Enterprise Reporting
-
Lifetime Access
-
CloudLabs
-
24x7 Support
-
Real-time code analysis and feedback
What is 12c R2: Advanced PL/SQL Ed 2 Certification Training about?
What are the objectives of 12c R2: Advanced PL/SQL Ed 2 Certification Training ?
Who is 12c R2: Advanced PL/SQL Ed 2 Certification Training for?
What are the prerequisites for 12c R2: Advanced PL/SQL Ed 2 Certification Training?
Available Training Modes
Live Online Training
24 HoursClassroom Training
3 DaysCourse Outline Expand All
Expand All
- List the PL/SQL development environments Available in this course
- Start SQL Developer and Create a Database Connection
- Course Objectives
- Use the SQL Worksheet
- Course Agenda
- Review the online Oracle Database 12c SQL and PL/SQL documentation and the additional available resources
- Identify the Appendices Used in this Course
- Describe the full Human Resources (HR) Schema
- 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
- Use Nested tables
- Use Associative arrays
- Use Varrays
- Overview of Collections
- Enhancements to PL/SQL Type Binds
- Use Collections effectively
- Binding PL/SQL only datatypes to SQL statements using DBMS_SQL
- Write PL/SQL programs that use collections
- Overview of SecureFile LOBs
- Working with LOBs
- PL/SQL object types for JSON
- Querying JSON columns
- JSON data columns in tables
- Generation of JSON data with SQL/JSON generation function
- JSON Data
- Benefits of External Procedures
- Java advanced interface methods
- C advanced interface methods
- Access PL/SQL blocks from from Java classes using JDBC
- Understand how an external routine is called from PL/SQL
- Calling External Procedures from PL/SQL
- Designing Applications for Real World Performance
- Understand and influence the compiler
- Recognize network issues
- Identify and tune memory issues
- Enable intra unit inlining
- Tune PL/SQL code
- Review PL/SQL function cache considerations
- Use PL/SQL function cache
- Describe result caching
- PL/Scope Concepts
- PL/SQL Enhancements
- PL/SQL Pragma to mark an item deprecated
- Finding Coding Information
- DBMS_METADATA Package
- What is Tracing and Profiling
- Tracing PL/SQL Execution
- Tracing PL/SQL: Steps
- Managing Access to data using PL/SQL
- Creating Secure Application roles to control access to applications
- Controlling Access to Program Units
- Filtering Input with DBMS_ASSERT
- SQL Injection Overview
- Reducing the Attack Surface
- List the DBMS_RLS procedures
- Brief introduction to Security implementation
- Fine Grained Access Control
- Implement a policy
- Query the dictionary views holding information on fine-grained access
- Application Context
Who is the instructor for this training?
The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.
12c R2: Advanced PL/SQL Ed 2 Certification Training - Certification & Exam
- SpringPeople is the Authorized Training Partner of Oracle.
- The training fees is exclusive of exam cost.
- For any queries; feel free to reach us at oracle@springpeople.com
Reviews
Previous
Next
My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!
Shweta Priya
Sony
I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.
Swati Singh
GE
I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.
Nikhil Kohli
Stryker
I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!
Heena Rajan
Mindtree
