Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
Master the basic concepts, tools and techniques that you will need to create fully functional, robust and portable oracle PL/SQL applications.
Build a Powerful Foundation in PL/SQL With This Course For Beginners.
Oracle 11g and SQL developer installation and configuration.
Anonymous blocks, subprograms, exceptions, triggers and packages.
Transaction control statements. Loops, conditionals and sequence.
A powerful and lucrative skill at your fingertips.
Mastering the fundamentals of PL/SQL puts a very lucrative skill at your fingertips. Oracle and SQL developer are free, easy to learn and use. PL/SQL is the only language used to build business logic within an oracle database. Jobs in PL/SQL development are plentiful and very lucrative. Mastering PL/SQL could double your income if you are already an SQL developer. This is true for other third generation developers (c++, java). PL/SQL will help you improve performance by pushing your business logic to the database.
Content and Overview.
Suitable for beginning programmers, through this course of 63 lectures over two and a half hours, you will learn PL/SQL fundamentals and establish a powerful understanding of the concepts behind procedural programming. Each chapter ends with a recap and a quiz to reinforce your knowledge.
Starting with the installation and configuration of oracle and SQL developer, through lexical units to variables. Next you create anonymous blocks which will establish a strong understanding of variables and the DBMS_OUTPUT package.
With the basics mastered, the course will take you through advanced topics like flow control (loops, GOTO), subprograms (functions and procedures) and transaction control (SAVEPOINT, ROLLBACK).
After completing this course, you will have the skills to build professional, production ready, business applications. You will also be able to answer 100 practical PL/SQL interview questions.
The course includes working code samples which you could adapt for your study or professional projects.
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Getting Started With PL/SQL|
Welcome To Oracle PL/SQL Essential Training.Preview
Prerequisites and Install oraclePreview
The Hr Schema and SQL DeveloperPreview
|Section 2: Introduction to PL/SQL|
Introduction and Overview of PL/SQL
Data Types and Lexical Units
Identifiers and Literals
Delimiters and Comments
|Section 3: Anonymous Blocks|
Creating Anonymous Blocks
Executable Blocks containing Variables
Variables and Nested Bocks
|Section 4: Flow Control Statements|
Conditional Flow Control Statements (IF THEN ELSE)
Conditional Flow Control Statements (CASE)
Iterative Control Statements Simple Loop
Iterative Control Statements (WHILE LOOP)
Iterative Control Statements (FOR LOOP)
Sequential Control Statements (GOTO)
Using the CONTINUE Statement to manage Iteration
|Section 5: Composite Data Types.|
Composite Data Types and Records.
Assigning Values to Record Fields
Composite Data Types and Collections
Collection Methods and Composite Index By Tables
Compostie Data Types and Nested Tables
|Section 6: Introduction to Cursors|
Introduction to Cursors
Explicit Cursor FOR LOOPs
Implicit Cursor FOR LOOP
Introducing Parameters in Cursors
Oracle REF CURSOR
|Section 7: Subprograms, Procedures, Functions, and Parameters|
Functions Returning Composite Data Types
|Section 8: Error Handling|
Error Handling and Named Predefined Exceptions.
Using SQLCODE and SQLERRM in WHEN OTHERS Statement
Unnamed Predefined Exceptions
User-Defined Business Exceptions
The raise_application_error Procedure
|Section 9: PL/SQL Transaction Processing|
Introduction to PL/SQL Transaction Processing
ROLLBACK Using EXCEPTION Handlers
SAVEPOINT Using COMMIT, EXCEPTION Handlers, and ROLLBACK
|Section 10: Introduction to PL/SQL Packages|
Creating Package Specifications without Bodies
Creating Package Specifications with Package Bodies
Extending Package Functionality by Overloading Subprograms
Oracle Built-in Packages: The UTIL_File Package
Using the UTIL_FILE Package
The DBMS_SCHEDULER Built in package
|Section 11: Triggers|
Introduction to Triggers
System Level Triggers
Table Level DML Trigger
Hi there! I'm Victor and I am a senior business intelligence consultant for high tech and financial corporations. Some of my previous clients include SAP AG, Oracle, Lloyds Bank, O2, and HSBC. I am currently working on big data and SAP Hana projects. I am also a published author and public speaker.
My role for the last 15 years generally involves leading the delivery of business intelligence solutions. Specifically, this includes integrating data warehouse databases (oracle, SQL server) with ETL (SAP data services) and reporting t (SAP crystal reports, web intelligence) to give the best insights to senior management.
My motivation to create Udemy courses is two fold. First, I struggled for years to master PL/SQL and other programming languages. The second reason is that, when I interview unsuccessful candidates for PL/SQL roles, their understanding of the fundamental principles was always lacking.
Thus I decided to create simple, clear, coherent and concise courses which will prepare students for their professional life. Just so they do not struggle as much as I did when I was coming up.