Oracle PL/SQL is My Game: EXAM 1Z0-144
6,281 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
Bestseller
6,281 students enrolled
Current price: $139.99
Original price: $199.99
Discount:
30% off
5 hours 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
Preview
05:31
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
+
–
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
Preview
05:58
Define Variables Using %TYPE
05:34
Understating the SELECT statement in PL/SQL
04:33
Bind Variables
06:08
+
–
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
Preview
06:15
While Loop
04:14
FOR Loop
04:47
Nested Loops
06:14
Nested Loops and Labels
04:49
Continue Statement
04:47
+
–
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
+
–
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
+
–
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
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
Featured review
Sarah Funtanilla
(
236 courses,
43 reviews
)
a year ago
Best PL/SQL Training but I hope you can add additional exercises in the last section for every chapters to be solve by student so that we can practice more. Thumbs Up, please create Advance PL SQL course.