Vendors

The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.

Learn To:

  • Use various features of PL/SQL.
  • Write anonymous blocks of code in PL/SQL.
  • Use various PL/SQL conditional constructs and loops in program blocks.
  • Interface the PL/SQL code with the database.
  • Use stored procedures and functions in their program blocks.
  • Handle Exceptions in PL/SQL code.
img-course-overview.jpg

What You'll Learn

Upon completing this course, the learner will be able to meet these overall objectives:
  • Design PL/SQL anonymous block that execute efficiently
  • Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
  • Handle exceptions in the program units
  • Create and execute simple stored procedures and functions
  • Write PL/SQL code to interface with the database
  • Describe the features and syntax of PL/SQL

Who Should Attend

Who Should Attend
  • PL/SQL Developer
  • Database Administrators
  • System Analysts
  • Forms Developer
  • Technical Consultant
  • Portal Developer
img-who-should-learn.png

Prerequisites

  • Familiarity with programming languages
  • Familiarity with data processing concepts and technique
  • Oracle Database 12c: Introduction for Experienced SQL Users

Learning Journey

Coming Soon...

Module 1: Introduction
Module 2: Introduction to PL/SQL
Module 3: Declaring PL/SQL Variables
Module 4: Writing Anonymous PL/SQL blocks
Module 5: Using SQL Statements within a PL/SQL Block
Module 6: Writing Control Structures
Module 7: Working with Composite Data Types
Module 8: Using Explicit Cursors
Module 9: Handling Exceptions
Module 10: Creating Stored Procedures and Functions

N/A
exam-cert

Frequently Asked Questions (FAQs)

Keep Exploring

Course Curriculum

Course Curriculum

Training Schedule

Training Schedule

Exam & Certification

Exam & Certification

FAQs

Frequently Asked Questions

img-improve-career.jpg

Improve yourself and your career by taking this course.

img-get-info.jpg

Ready to Take Your Business from Great to Awesome?

Level-up by partnering with Trainocate. Get in touch today.

Name
Email
Phone
I'm inquiring for
Inquiry Details

By submitting this form, you consent to Trainocate processing your data to respond to your inquiry and provide you with relevant information about our training programs, including occasional emails with the latest news, exclusive events, and special offers.

You can unsubscribe from our marketing emails at any time. Our data handling practices are in accordance with our Privacy Policy.