Oracle PL/SQL is My Game: EXAM 1Z0-144
4.6 (972 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,963 students enrolled

Oracle PL/SQL is My Game: EXAM 1Z0-144

Become Oracle PL/SQL Developer / Covers ORACLE university track 100%. All the presentations & scripts are attached
4.6 (972 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,964 students enrolled
Created by Khaled Alkhudari
Last updated 1/2020
English
Current price: $119.99 Original price: $199.99 Discount: 40% off
3 days left at this price!
30-Day Money-Back Guarantee
This course includes
  • 22 hours on-demand video
  • 4 articles
  • 135 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • The full track of Oracle university Exam 1Z0-144 : Program with PL/SQL
  • Oracle Database 12c Architecture
  • Downloading and installing oracle database 12c in details
  • Overview of PLSQL
  • Declaring PLSQL Variables
  • Writing executable statements
  • Interacting with Oracle DB Server
  • Writing Control structure
  • Working with Composite Data Types
  • Using explicit cursors
  • Handling Exceptions
  • Creating Procedures
  • Creating Functions
  • Creating Packages
  • Working with Packages
  • Using oracle-supplied Packages in Application Development
  • Using dynamic SQL
  • Design consideration for PLSQL Code
  • Creating triggers
  • Creating Compound, DDL, and Event Database Triggers
  • Using the PLSQL Compiler
  • Managing PLSQL Code
  • Managing Dependencies
Course content
Expand all 220 lectures 21:53:01
+ Course Setup
14 lectures 01:27:53
Course Setup Notes / 4 Options
04:32
Option 2- creating the HR Schema
07:34
Option 3- Part 1 : Oracle Database 12c Architecture
04:27
Option 3- Part 2 : Downloading Oracle DB 12c
03:42
Option 3- Part 3 : Installing Oracle DB 12c
09:16
Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer
10:39
Option 3- Part 5: Unlock HR Account Part 1
04:30
Option 3- Part 6 : Unlock HR Account Part 2
11:49
Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c
03:33
Option 4- Installing Oracle 11g express Edition + Unlock HR
10:21
About Oracle 18c express edition
00:20
HR Schema in this Course
04:34
Navigate HR schema
07:05
+ Overview of PL/SQL
5 lectures 29:13
What is PL/SQL? What is the benefits?
08:11
PL/SQL Block Structure & Types of Blocks
05:45
Using SQL*plus to run anonyms block
02:35
Creating Script and run it
04:50

Chapter 2 Quiz

Chapter 2 Quiz
6 questions
+ Declaring PLSQL Variables
10 lectures 56:25
About Variables and the syntax
07:02
Defining Variables exercise
06:46
Guidelines for declaring & initializing variables
03:33
Delimiters in string literals (the q' Notation)
05:32
Types of variables and data types 1
05:53
Types of variables and data types 2
05:26
Define Variables Using %TYPE
05:34
Understating the SELECT statement in PL/SQL
04:33
Bind Variables
06:08

Chapter 3 Quiz

Chapter 3 Quiz
6 questions
+ Writing executable statements
4 lectures 23:59
Inside PL/SQL Block
06:20
Inside PL/SQL Block (exercise)
06:13
Nested Blocks
07:19
SQL & PL/SQL programing Guidelines
04:07

Chapter 4 Quiz

Chapter 4 Quiz
5 questions
+ Interacting with Oracle DB Server
4 lectures 19:14
SELECT statement & DML in PL/SQL
04:13
SELECT statement & DML in PL/SQL exercise
06:20
Understanding Implicit SQL cursor/ SQL Attributes
03:24
Implicit SQL cursor exercise
05:17

Chapter 5 Quiz

Chapter 5 Quiz
5 questions
+ Writing Control structure
10 lectures 56:13
IF Statement Part 1
06:15
IF Statement Part 2
06:44
Handling nulls in IF statement
03:58
CASE expression & CASE Statement
08:10
While Loop
04:14
FOR Loop
04:47
Nested Loops
06:14
Nested Loops and Labels
04:49
Continue Statement
04:47

Chapter 6 Quiz

Chapter 6 Quiz
8 questions
+ Working with Composite Data Types
9 lectures 01:09:53
PL/SQL Records: Programmer method part 1
07:21
PL/SQL Records: Programmer method part 2
06:58
PL/SQL Records: %ROWTYPE method
08:37
Nested PL/SQL Records
05:20
INDEX BY tables (Associative arrays)
10:40
INDEX BY tables Methods
07:30
INDEX BY tables of Records
07:24
nested table
10:40
Varray
05:23

Chapter 7 Quiz

Chapter 7 Quiz
9 questions
+ Using explicit cursors
6 lectures 41:40
Understanding Explicit Cursor
12:26
Explicit Cursor exercise
08:34
Explicit Cursor Attributes
06:10
FOR LOOP Cursor
04:17
Cursor with Parameters
04:41
FOR UPDATE Clause & CURRENT OF Clause
05:32

Chapter 8 Quiz

Chapter 8 Quiz
10 questions
+ Handling Exceptions
7 lectures 37:51
Understanding Exceptions
06:24
Predefined Oracle Server Error Exception
07:25
Common mistakes when dealing with exceptions
03:39
Non-Predefined Oracle Server Error Exception
06:22
User-Defined Error Exception
05:40
Group Functions and exceptions
04:15
Many blocks and many exceptions
04:06

Chapter 9 Quiz

Chapter 9 Quiz
9 questions
+ Creating Procedure
10 lectures 01:03:13
Understanding Procedures and subprograms
08:07
Understanding Procedures Syntax
05:01
Creating Procedure (OUT parameter)
07:53
Creating Procedure (IN OUT parameter)
04:31
Comparing the Paramter Modes
02:39
Available notations for passing parameters
08:26
Using the default option for Parameters
03:37
Exception handling in multiple blocks
08:45
Using Boolean and PL/SQL records as parameters
05:05

Chapter 10 Quiz

Chapter 10 Quiz
10 questions
Requirements
  • You should know Oracle SQL ( 11g or 12c)
  • You should have strong knowledge in (SELECT statement, DML, DDL, DCL, creating views, indexes, and synonyms)
  • Windows Operating system is preferred, but this is not mandatory if you have the knowledge of downloading Oracle database on other OS
  • Downloading oracle database and this will be covered in details on Windows OS.
  • No need for any previous experience in PL/SQL, this Course starts from zero in PL/SQL
Description

This is one of the most amazing Udemy courses in Oracle PLSQL.

The course covers the oracle university track 100% for :

Exam Number: 1Z0-144 : Program with PL/SQL

I designed in this course in a very professional structure that includes huge amount of exercises and examples.

Be sure that you will become expert in PLSQL programming after finishing this course, and you will be ready 100% to pass the Oracle Exam. 

You will find all the presentations and all the SQL scripts attached in every chapter, so no need to waste your time repeating any example I did.

Simply this course is the best….


Who this course is for:
  • Students who wants to be expert in PL/SQL programming
  • Students who wants to be certified in PL/SQL
  • Fresh and junior programmers who need to find better jobs by gaining oracle certification
  • Students who already know Oracle SQL and they need to move to next level which is PL/SQL