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

4.3 (2987)
PL/SQL by Example - Beginner to Advanced PL/SQL
Learning paid
5.5 hours course
Course by Udemy
$ 129.99
PL/SQL by Example - Beginner to Advanced PL/SQL
$ 129.99
What will you 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)
About the course

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
How to make best use of the Program...
Software Installation
Lets install the necessary software if we do not have the software already....
Installing Oracle
Installing Java SDK
Installing SQL Developer
Running scripts necessary for the course
Scripts for our Lab Exercises
PL/SQL Basics
Lets get introduced to PL/SQL, control the code flow using loops and other control structures.
What is PL/SQL
PL/SQL Advantages
PL/SQL Structure
  • SQL Knowledge is needed and is a must!!!
Amarnath Reddy
Amarnath Reddy
Oracle Architect & Best Selling Instructor | 27000+ Students
Udemy courses are suited to professional development. The platform is organized in such a way that it is experts themselves that decide the topic and when the course will start. All supporting documents are made available to you for lifetime access. On this platform, you can find a course on about any subject, and that is no exaggeration – from a tutorial on how to ride a motorcycle, to managing the financial markets. The language and the course format are established by the teacher. This is why it is important to read the information about the course carefully before parting with any money.
Comments (2987)
Like any other website, konevy uses «cookies». These cookies are used to store information including visitor's preferences, and the pages on the website that the visitor accessed or visited. The information is used to optimize the users' experience by customizing our web page content based on visitors' browser type and/or other information. For more general information on cookies, please read the «What Are Cookies» article on Cookie Consent website.