Oracle Database 19c- PL/SQL Workshop

Course Description

This course introduces learners to PL/SQL, Procedural Language for SQL. Explore the distinction between SQL and PL/SQL. Examine the characteristics of PL/SQL and how it is used to extend & automate SQL.

Target Audience

No prerequisites are needed for this course

Learning Outcomes

Learn to-

  • Declare Variables
  • Write Executable Statements
  • Write Control Structures
  • Create Procedures and Functions
  • Create Packages
  • Create Triggers

Content Outline

  1. Introduction
  2. Introduction to PL/SQL
  3. Declaring PL/SQL Variables
  4. Writing Executable Statements
  5. Using SQL Statements Within a PL/SQL Block
  6. Writing Control Structures
  7. Working with Composite Data Types
  8. Using Explicit Cursors
  9. Handling Exceptions
  10. Introducing Stored Procedures and Functions
  11. Creating Procedures
  12. Creating Functions
  13. Debugging Subprograms
  14. Creating Packages
  15. Working with Packages
  16. Using Oracle-Supplied Packages in Application Development
  17. Using Dynamic SQL
  18. Creating Triggers
  19. Creating Compound, DDL, and Event Database Triggers
  20. Design Considerations for the PL/SQL Code
  21. Tuning the PL/SQL Compiler
  22. Managing Dependencies

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 participants’ 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 in the natural world and Oriented industry 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 a lot in your 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 allow 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 in the natural world and Oriented industry 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 a lot in your future tasks and assignments.

Send a Message.


  • Enroll