PL/SQL by Example – Beginner to Advanced PL/SQL

Using PL/SQL learn how to combine the efficiency of SQL & Procedural Language(PL) to build a powerful PL/SQL Application.

What Will I Learn?
  • Declare PL/SQL Variables
  • Conditionally control code flow (loops, control structures)
  • Use some of the Oracle supplied PL/SQL packages to generate screen output
  • Create anonymous PL/SQL blocks, functions and procedures
  • Use PL/SQL packages to group and contain related constructs
  • Catch run time errors using Exceptions
  • Perform Data processing using Records and Cursors
  • Manage data using Collections
  • Create triggers to solve business challenges
  • Peform Bulk Processing to improve performance
  • Execute SQL using Dynamic SQL
  • Pipelining the data as it is processed
  • Working with Large Objects (LOB’s)
  • pl/sql by example – beginner to advanced pl/sql free download
  • pl/sql by example – beginner to advanced pl/sql download
  • advanced pl sql tutorial pdf
  • oracle advanced pl/sql developer professional guide pdf
  • advanced pl sql concepts in oracle 12c
  • advanced pl sql interview questions for experienced
  • pl sql+advanced concepts interview questions
  • pl sql examples for practice
  • SQL Knowledge is needed and is a must!!!

Learn to become a PL/SQL developer in just four weeks.

This fast, easy and effective course will take you from zero PL/SQL writing skills to being able to write efficient programs to process data.

PL/SQL is the Oracle Procedural Language extension of SQL. A PL/SQL program can have both SQL statements and procedural statements. In the PL/SQL program, the SQL statements are used to access sets of data stored in a database, while the procedural statements are used to process individual piece of data and control the program flow.

In this course participants will learn

  • Describe the features and syntax of PL/SQL
  • Design PL/SQL anonymous blocks that execute efficiently
  • Use the Oracle supplied PL/SQL packages to generate screen output
  • Create and debug Stored Procedures and Functions
  • Design PL/SQL packages to group related constructs
  • Use PL/SQL programming constructs and conditionally control code flow
  • Create overloaded package subprograms for more flexibility
  • Handle runtime errors using Exceptions
  • Writing manageable code using Records
  • Storing and processing data using Collections
  • Processing data using Implicit and Explicit Cursors

Softwares used

  • Oracle Database 11g
  • SQL Developer
Who is the target audience?
  • This PL/SQL course is meant for students who want to learn Procedure Language to control SQL Statements.
  • This course is not for you if you’re looking to learn more advanced concepts of PL/SQL
 Source: “”

Be the first to comment

Leave a Reply

Your email address will not be published.