Oracle Database 12c R2- Advanced PL/SQL

Course Description

This Oracle Database 12c- Advanced PL/SQL training teaches you how to utilize the advanced features of PL/SQL to design & tune PL/SQL to interface with the database & other applications. Expert Oracle University instructors will assist you in exploring advanced features of program design, cursors, packages, extended interface methods, and collections. You'll be introduced to Oracle Database Exadata Express Cloud Service in this course.

Prerequisites

Oracle Database 12c R2- introduction to PL/SQL is needed for this course 

Target Audience

This course is suitable for Database Administrators, Database Developer

Learning Objectives

  • Write robust PL/SQL programs.
  • Explore programming efficiency.
  • Use external C & Java routines.
  • Apply PL/SQL designing ideal practices.
  • Develop PL/SQL applications that use collections.
  • Apply a virtual private database with fine-grained access control.
  • Write code to interface with external C & Java applications.
  • Write code to interface with large objects & utilize SecureFile LOBs.
  • Write & tune PL/SQL code effectively to maximize performance.
  • Acquire an understanding of the Oracle Database Exadata Express Cloud Service.

Content Outline

  1. Introduction to SQL Workshop 1
  2. Retrieving Data Using the SQL SELECT Statement
  3. Restricting and Sorting Data
  4. Using Single-Row Functions to Customize Output
  5. Using Conversion Functions and Conditional Expressions
  6. Reporting Aggregated Data Using the Group Functions
  7. Displaying Data from Multiple Tables Using Joins
  8. Using Subqueries to Solve Queries
  9. Using Set Operators
  10. Managing Tables Using DML Statements
  11. Introduction to Data Definition Language

FAQs

Radiant Techlearning is headquartered in the Electronic city & technology hub of Northern India, Noida, surrounded by several large multinational, medium & small Software companies.

We have offices located all across the country and partners across the globe.

Radiant Techlearning has a data center containing a Virtual Training environment for participant hand-on-practice.

Participants can easily access these labs over Cloud with the help of a remote desktop connection.

Radiant virtual labs allow you to learn from anywhere and in any time zone.

The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you greatly in future tasks and assignments.

To know about the fee details, you can email us at training@radianttechlearning.com with your requirement in detail, containing the below information.

In the case of Self/ Individual

  • Training Program
  • Training Mode (Online/ Classroom)
  • Location (in case of the classroom)-
  • Background (Education/ Technology/ Year of experience, etc. )
  • Training Timeline

In the case of Corporate Training

  • Training Program
  • of Participants
  •  Training Mode (Online/ Classroom)
  • Location (in case of the classroom)-
  • Participant's Background (Education/ Technology/ Year of experience, etc.)
  • Training Timeline
  • Expectations from the training program

No. These training programs are helping to improve your skills & knowledge of the technology which would help you to land your dream job by learning them.

Our training program will maximize your ability and chances of getting a successful job. You have to select a job according to your convenience. Your performance in the training program and interview is crucial for getting a good job.

Yes, your employer can pay your fees.

The learners will be enthralled as we engage them the real-world and industry Oriented projects during the training program. These projects will improve your skills and knowledge and give you a better experience. These real-time projects will help you greatly in future tasks and assignments.

Send a Message.


  • Enroll
    • Learning Format: ILT
    • Duration: 80 Hours
    • Training Level : Beginner
    • Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
    • Price : INR 25000
    • Learning Format: VILT
    • Duration: 50 Hours
    • Training Level : Beginner
    • Validity Period : 3 Months
    • Price : INR 6000
    • Learning Format: Blended Learning (Highly Interactive Self-Paced Courses +Practice Lab+VILT+Career Assistance)
    • Duration: 160 Hours 50 Hours Self-paced courses+80 Hours of Boot Camp+20 Hours of Interview Assisstance
    • Training Level : Beginner
    • Validity Period : 6 Months
    • Jan 29th : 8:00 - 10:00 AM (Weekend Batch)
    • Price : INR 6000

    This is id #d