Enhance Your Oracle SQL Skills by Mastering PL/SQL
A step-by-step program to help you learn Oracle PL/SQL programming... so you can be confident in your job working with Oracle procedural code.
Before I tell you all about this program, let's make sure you're a good fit.
If you are:
- A database developer or professional wants to learn how stored procedures, functions, and triggers work, so you can be effective in your job and contribute to your team's projects.
- A data analyst who wants to understand stored procedure programming so they can retrieve their data effectively
- A software developer that works with a database for an application and wants to either understand existing stored procedures or contribute to new stored procedures.
You're in the right place!
Effective Oracle PL/SQL will take you from the basics to more advanced concepts of PL/SQL programming, so you can understand and use these concepts in your job.
By the end of this program,
you will…
-
Be Able to Write a Basic Stored Procedure
You'll be able to create a simple stored procedure in Oracle PL/SQL: the classic "hello world", so you can get something running quickly. -
Understand and Use Variables and Parameters
You'll be clear on what variables and parameters are used for and how to use them in procedures to improve your code. -
Know How to Control the Flow of Your Code
You'll learn a range of features to control how your code runs, such as IF statements and loops. -
Learn How to Find, Fix, and Prevent Errors
You'll learn and implement commonly-used practices in software development such as version control, debugging your code, testing your procedures, and handling errors. -
Create Functions and Triggers
You'll learn how to use procedural code in other objects: functions and triggers, and how to use them effectively. -
Learn and Understand Advanced Concepts
You'll also learn more advanced concepts with procedural programming, such as cursors, packages, performance considerations, creating modular code, and making changes to your code.
"Ben has simplified sub-queries for me, regex, and many other topics. I feel slow when reading a lot of explanations off the internet, but his explanations are so clear, they make these topics easy to understand."
Nancy T, Database Star Academy member
Enroll in Effective Oracle PL/SQL Today
- 13 high-quality video modules (73 lessons)
- SQL Scripts
- Complete Course PDF
Your explanations are so clear and concise that you don’t need to go on and on and on as I have heard others do.
- Donna M
The brevity of lessons are more manageable and the progression is well designed.
- Merri H
I have learnt a lot by following your site which cannot be described in words. Examples given after each topic are very useful. The videos are simple, informative and easy to understand.
- Korlahalli S
What’s Inside Effective Oracle PL/SQL
Module 1
The Basics of PL/SQL
If PL/SQL is new to you, you'll appreciate this module, where you'll learn what PL/SQL is and write your very first simple piece of code.
Module Highlights:
- Learn how this course is structured.
- Learn what PL/SQL is (Procedural Language/Structured Query Language) and how it can help you.
- How to write and run a simple piece of PL/SQL code.
Module 2
Simple Stored Procedure
If stored procedures are new to you, you'll appreciate this module, where you'll learn and write your very first simple stored procedure.
Module Highlights:
- Learn what a stored procedure is and why use them.
- How to create a simple stored procedure.
- How to execute or run a stored procedure.
- How to make changes to a stored procedure.
Module 3
Variables
Variables are a core principle of developing software, and you'll learn how to work with them in this module.
Module Highlights:
- Setting up the sample database for the course (Oracle HR database).
- What a variable is and why use them
- Using SELECT to get data from a table and store it into a variable
Module 4
Parameters
Parameters can improve the flexibility of your code, and this module will show you how to use them.
Module Highlights:
- Learn the limitations of your code so far.
- Learn what parameters are and how they can help.
- How to use parameters in your stored procedures.
- How to use both input and output parameters.
- How to insert, update, and delete data in a stored procedure.
Module 5
Version Control
Version control is a fundamental practice of software development. You'll learn what it is and how to implement it with your code, making you more effective in your current and future roles.
Module Highlights:
- What is version control and why you should use it
- How to set up your GitHub account and code repository
- How to add files to your repository
Module 6
More Stored Procedures
You'll learn more about stored procedures and how to control the flow of your code.
Module Highlights:
- How to control the flow of your code using IF and ELSE statements.
- How to use loops in your code and why you may not want to.
- Handling and logging errors in your procedure.
- What is debugging and why you should do it.
- How to use the debugging features within SQL Developer to debug your code.
Module 7
Improving Your Code
There are a range of strategies that you can use to improve your procedure code, which we'll cover in this module.
Module Highlights:
- What is "modular code" and how it can help.
- How to call a procedure from another procedure.
- How to pass errors to other parts of your code.
- How and why to add comments to your code.
Module 8
Functions
You can also create user-defined functions using procedural programming in Oracle, and you'll learn all about that in this module.
Module Highlights:
- What is a user-defined function (UDF) and why use them.
- How to create a user-defined function.
- How to execute a user-defined function.
Module 9
Triggers
Triggers are objects that can use procedural code, and you'll learn how to create and use them in this module.
Module Highlights:
- What are triggers and why you would use them.
- The drawbacks of using triggers.
- Creating a simple trigger.
- How to implement an audit table using triggers.
Module 10
Sets of Data
There are many ways to work with sets of data in PL/SQL and you'll learn about them in this module.
Module Highlights:
- A feature to help you relate your variables to tables and columns to reduce the risk of issues.
- Several data structures in PL/SQL to help you store sets of data.
- How to improve the performance of your SQL in PL/SQL.
Module 11
Packages
Oracle PL/SQL includes the concept of a package. Learn what they are and why use them in this module
Module Highlights:
- What a package is and why you would use them.
- The difference between a package specification and a package body.
- How to create your own package and execute code within the package.
Module 12
Testing
The ability to test your procedural code has many benefits, and you'll learn why and how in this module.
Module Highlights:
- What is testing and why you should test your code.
- How to set up the testing framework for your tests.
- How to write and execute tests on your stored procedures.
Module 13
Code Changes
You'll often need to make changes to your code, and this module will explain some tips on doing that and wrap up the course.
Module Highlights:
- A process to follow to make code changes when requirements change.
- A range of things to consider to improve the performance of your stored procedures.
When you enroll during this special, limited time period,
you’ll get:
Effective Oracle PL/SQL
-
13 Modules
A step-by-step roadmap to follow to become confident with writing and working with stored procedures and other PL/SQL code objects, starting with the very basics and moving onto more advanced concepts.
-
Comments for Questions and Answers
You'll have access to the built-in comments where you can ask questions to me and other members, and provide answers on other posts.
Plus These Bonuses to Help You Work With Oracle PL/SQL
Bonus 1
SQL Scripts
A collection of SQL files used in the course and as extra support to help you save time.
What You’ll Get:
- SQL scripts used within each lesson, so you can save time when following along rather than typing what you see on the screen.
- SQL scripts to support your procedure development, such as querying the data dictionary.
Bonus 2
Complete Course PDF
A PDF file with the complete course included, so you can read it offline and use as a reference.
What You’ll Get:
- A single PDF with all lessons included, so you can refer to it in the future
- PDF includes screenshots and SQL so you know what scripts and screens are being referenced
Here’s what you’re getting when you enroll today:
- Effective Oracle PL/SQL
- SQL Scripts
- Complete Course PDF
When you enroll today, you’ll get access to everything for just:
30-Day Money Back Guarantee
I'm very confident that this course can help you learn and understand Oracle PL/SQL.
If you enrol in this course, and are not satisfied, let me know within 30 days of enrolling and I'll provide a refund for you.
Frequently Asked Questions
Do I need to know advanced Oracle concepts to take this course?
Which SQL vendors/databases is this for?
What tools or software do you use in the course?
My team doesn't use stored procedures. Will this help me?
I don’t have the time to learn
I don’t have regular opportunities to practice this, so I forget what I need to do
Do I get access to all of the lessons at once?
What if I have questions during the course?
I have unreliable internet so it’s hard for me to watch the videos
Do you offer refunds?
Can you remind me of everything I’m getting when I sign up today?
Enroll in Effective Oracle PL/SQL
- 13 high-quality video modules (73 lessons)
- SQL Scripts
- Complete Course PDF
Still thinking about it?
You should give Effective Oracle PL/SQL a 30-day risk-free shot if you're motivated by any of the following:
- You know the basics of Oracle and want to use procedural programming to improve your code.
- You often work with stored procedures, functions, or triggers, and want to understand them better.
- You work on an application that calls stored procedures and want to better understand them and use them.
- Ready to take the actions needed to improve your Oracle skills.
I can’t wait for you to join Effective Oracle PL/SQL
I created this course because Oracle PL/SQL is a great topic to learn if you work with Oracle databases.
So much of the material out there is hard to follow and goes into more detail than you need to know.
As someone who works with data, it's important to understand how stored procedures work, so you can use them when the need arises, contribute more effectively to your team, and help you get a job in the future.
Knowing how to write and work with Oracle stored procedures will serve you for years to come.
All it takes is a small investment in your education, and practicing the strategies highlighted in the course.
You're in the right place, and this is the course for you.
There's no risk to joining, with my 30-day money back guarantee.
I hope to see you inside.
Ben Brumm
Enroll in Effective Oracle PL/SQL
- 13 high-quality video modules (73 lessons)
- SQL Scripts
- Complete Course PDF
