Oracle PL/SQL Fundamentals vol. I & II

A complete introduction to PL/SQL database programming language

4.41 (5481 reviews)
Udemy
platform
English
language
Oracle
category
Oracle PL/SQL Fundamentals vol. I & II
26,535
students
20 hours
content
Jan 2022
last update
$89.99
regular price

What you will learn

Over 90 lectures and 20 hours of content

Prepare your enviornment

Introducing Database Program Units

Creating and Maintaining Packages

Using System-Supplied Packages

Creating and Maintaining Database Triggers

Implementing System Event Triggers

Work with Oracle database tools

Understand and work work language features

Work with DECLARE, BEGIN & EXCEPTION clause

Understand and use nested blocks

Use explicit cursors

Description

Oracle PL/SQL Fundamentals Pt. I Description of Course:

The primary objective of this Oracle 11g training part I course is to provide an introduction to the PL/SQL database programming language covering syntax, structure, and features of the language within the context of database applications and programming. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Learning Objectives:

  • Preparing Your Environment

  • Working with Oracle Database Tools

  • Language Features

  • The DECLARE Clause

  • The BEGIN Clause

  • The EXCEPTION Clause

  • Explicit Cursors

  • Nested Blocks

  • Declared Subprograms



Oracle PL/SQL Fundamentals Pt. II Description of Course:

In this part 2 of Oracle PL/SQL fundamentals, students will dive into topics such as understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Learning Objectives:

  • Preparing Your Environment

  • Database Program Units

  • Working with Stored Procedures and Functions

  • Maintaining Stored Procedures and Functions

  • Creating and Maintaining Packages

  • Advanced Cursor Techniques

  • Using System Supplied Packages

  • Creating Database Triggers

  • Trigger Maintenance

  • Working with System Event Triggers



As you proceed through the course, don’t forget you can ask questions and engage with us.  When watching a video, click the Browse Q&A at the bottom of the screen and then click the green Ask a new question button and we’ll get back to you with an answer!  With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs. Check out all Intellezy has to offer with our award-winning video content!

Content

Oracle 11g PL/SQL Fundamentals I

Introduction
Course Setup
Selecting the Appropriate Database Tool
Understanding PL/SQL
PL/SQL Blocks
Working with SQL Plus
DECLARE Clause Objects
PL/SQL Available Data Types
Declaring Simple Data Types and Assignments
Declaring Complex Data Types and Assignments
Declaring Complex RowTypes and Assignments
Declaring Complex Tables
Declaring Complex Records
Creating and Declaring User-Defined Types
What Can Be Included in the BEGIN Clause
Working with CHAR and VARCHAR2 Variables
Handling String Literals
Working with Numeric Variables
Working with Date Variables
Assigning and Using Boolean Variables
Using Comparison Operators
Using SQL Functions
SQL DML within PL/SQL
Using SELECT
Exceptions and Embedded SQL
Using Sequences
Logic Control and Branching
Using GOTO
Working with LOOPS
Creating and Using the Indefinite Loop
Creating and Using the Conditional Loop
Using Nested Loops
Using the If-Then-Else
Using the CASE Statement
What Are the Types of Exceptions
Trapping Exceptions
Identify Exception Details
Creating User-Defined Exceptions
Using SQLCODE and SQLERRM Objects
Understand the Implicit Cursor
Creating User-Defined Events
Understanding the Concept and Purpose of Explicit Cursors
Learn about Cursor Attributes
Using the Continue Statement
Working with Updateable Cursors
Creating and Using Cursor Parameters
FOR...LOOP Cursors
Understanding Nested Blocks
Difference between Global vs Local Objects and Exceptions
Subprograms: How They Differ from Nested Blocks
Conclusion

Oracle 11g PL/SQL Fundamentals II

Introduction
Install Oracle XE
SQL Developer Installation
Workstation Setup
Introducing the Database Program Unit
Creating Stored Procedures and Functions
Understanding the Parameter Specification
Executing Procedures and Functions
Calling Functions from within SQL
Handling Compilation Errors
Recompiling and Dropping Programs
Data Dictionary Storage
Managing Dependencies
Tracking Dependencies
Using the Dependency Tracking Utility
What Is a Package?
Creating a Package
Package Definition Information
Advanced Programming Techniques
Using Persistent Global Objects
Including Initialization Logic
Object Oriented Support within Packages
Package Maintenance
Learning to Use Cursor Variables
Weak Cursor Definitions
REFCURSOR Cursor Definition
Using Cursor Expression
Using the DBMS OUTPUT() Package
Using the UTL FILE() Package
Understanding the Database Trigger
Statement-Level Triggers
Row-Level Triggers
Row Level Trigger Example 1
Row Level Trigger Example 2
Row Level Trigger Example 3
Working with the INSTEAD OF Trigger
Using Triggers within an Application
Using the CALL Statement
Trigger Maintenance Tasks
Work with Multiple Triggers for a Single Table
Handling Mutating Table Issues
Using the Compound Trigger
What Is a System Event Trigger
Defining Scope
Identifying Available System Events
Conclusion

Reviews

Ariana
September 1, 2023
Point 1. Introduction and 2.Course Setup were a bit confusing, so I had to research for myself how to install the systems required on youtube. Also, what caused a lot of confusion were the documents the tutor referred to on 2.Course Setup, since they are not as a compresed file nor in point 2., they are on point 1. I assume this confusion on the location of the documents is bc the tutorial is from some years ago and the softwares have since been updated, so it's all good.
Terry
June 16, 2023
The instructor was very engaging and I loved his use of different expressions, such as "whoa, pump the brakes!", or "and Bob's your uncle". His sense of humor and overall enthusiastic delivery for his subject was able to hold my attention for the most part. He knows PL/SQL without a doubt and the lessons are applicable. My biggest disappointment with this course was that for the student, it was a mostly passive experience. He does have all the scripts downloadable, but the best courses are those that ask you to do the exercise and then afterwards provide a solution. As anyone who teaches will tell you, if you get the opportunity to practice what was just preached, you will learn better and retain more. The class is good with a lot of pertinent material, I just wish the format had been a little different. The instructor is top notch and I would bet a heck of a guy to hang with.
James
June 9, 2023
Excellent course. I never expect a course can be designed and explained so easy and simply. The instructor is helpful.
Sonja
May 19, 2023
The best PL/SQL course on Udemy. Clearly explained. Lecturer is knowledgeable. Only covers up to 11g though. In need of an upgrade...
David
February 1, 2023
My initial experience is not positive. There's a total lack of preparation by the instructor. He's literally making it up as he goes, which is disappointing. He appears to be discovering the course material at the same time as we are, which is not ideal.
Sebastian
January 4, 2023
Instructor really knows his stuff and explains it well which is great so keep that in mind (he says that a lot lol). Only gripe I had was that the 1st 20 or so videos I felt like there wasn't much to practice, more just listening and taking in things. It gets better and you can play around with the code more after that.
Myriam
December 19, 2022
No The set up module is really bad. It took me hours to have everything installed I wish it had been showned step by step in the tutorial
Arturo
October 21, 2022
The course is great. Tim is very clear, thorough and engaging. I'm really enjoying the course. The only thing I would add to it is exercises for students to do and then compare them to the instructor's.
Rohini
September 21, 2022
The instructor says that copy of Oracle XE is given in the resources to download and install it. I cannot see it anywhere. I am confused and stuck. I don't even know where should I ask my questions and solutions for issues that I am facing.
Alex
June 29, 2022
Although this course is quite old is still very useful and comprehensive. I really enjoyed taking it. Thank you!
Shaun
June 21, 2022
I was initially a little worried that I work at an advanced level with some of the worlds largest companies but the course stated fundamentals level... These two courses are not at a fundamental level. You come away with knoweldge more advanced than many of the people that you will work with who have used Oracle for some time. I come to this as an expert with DB2 so some of the concepts were simply a matter of transposing Oracle onto my DB2 knowledge and during the course I did have a few "Ah, thats how they implemented that". Also, I did find PL/SQL... Or more to the point the PL part of that very similar to VBA so again it was a matter of transposing new knowledge onto existing. I was very, very impresesed at the content and scope of the course. And the presenters skills were second to non. There does seem quite a bit missing that I was hoping would be part of the course mainly around functions such as Rank, Dense Rank, NTile, CUME_DIST etc. but their absence is more than made up for by the scope of information presented. Towards the end there was talk of other Oracle courses but I cannot find them on Udemy otherwise I would buy them. That is how impressed I was. Many thanks for a great couple of months study. I was extremely happy with this course. Shaun.
Douglas
June 17, 2022
In the second lesson, the instructor shows his screen. At the bottom the date of the taping is clearly visible. The year? 2013. The current year as of this writing, 2022. This course is almost 10 years old. And no where, when purchasing it, was this indicated. If Oracle, and PL/SQL have not changed dramatically in 10 years, I need to find another DBMS. No wonder it was so cheap, but it is still not worth it. And, I will not be purchasing any more courses from this company and will advise against doing so to my collogues.
Marcos
May 1, 2022
The course is packed with information but unfortunately the delivery is quite tedious. Pre-created projects, no coding, needless repetition, and boring slides, mostly, And worst of all, it has no exercises or quizzes, so no opportunity to commit this knowledge to memory for real. It might be good for you if can tolerate this style and you want a reference guide for PL/SQL. But if you actually want to learn, this is not for you. Look elsewhere.
Selamawit
March 18, 2022
I just got hired as Oracle developer even though my training is on Microsft SQL Server DBA ,Just started this course yesterday to get familiar with oracle pl/sql so far so good. The instructor is very engaging and i feel like am in real class very knowledgeable hope the rest of the course is like this. I have searched and tried many pl/sql but this one is one of the best it should get highest rating. If anything is changed I will update my review!
Ariel
April 6, 2021
Every lesson is worth the time to watch and learn. The explanation was very specific and easy to follow. I like the way the instructor used the same block of codes and made the progression in the subsequent videos. I highly recommended this course. Thank you for the very awesome job. I do really appreciate the effort in setting up the templates and codes. It makes easier for me to follow.

Charts

Price

Oracle PL/SQL Fundamentals vol. I & II - Price chart

Rating

Oracle PL/SQL Fundamentals vol. I & II - Ratings chart

Enrollment distribution

Oracle PL/SQL Fundamentals vol. I & II - Distribution chart

Related Topics

128786
udemy ID
12/3/2013
course created date
9/7/2019
course indexed date
Bot
course submited by