Oracle Plsql Is My Game Exam 1z0 144

Become Oracle PL/SQL Developer / Covers ORACLE university track 100%. All the presentations & scripts are attached

Last updated 2022-01-10 | 4.5

- 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

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

* 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

  • 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

22 sections • 238 lectures

Course Agenda Preview 05:31

Course Setup Notes / 4 Options Preview 04:32

Option 2- creating the HR Schema Preview 07:34

Option 3- Part 1 : Oracle Database 12c Architecture Preview 04:27

Option 3- Part 2 : Downloading Oracle DB 12c Preview 03:42

Option 3- Part 3 : Installing Oracle DB 12c Preview 09:16

Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer Preview 10:39

Option 3- Part 5: Unlock HR Account Part 1 Preview 04:30

Option 3- Part 6 : Unlock HR Account Part 2 Preview 11:49

Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c Preview 03:33

Option 4- Installing Oracle 11g express Edition + Unlock HR Preview 10:21

About Oracle 18c express edition Preview 00:20

HR Schema in this Course Preview 04:34

Navigate HR schema Preview 07:05

What is PL/SQL? What is the benefits? Preview 08:11

PL/SQL Block Structure & Types of Blocks Preview 05:45

Writing simple Anonymous block Preview 07:52

Using SQL*plus to run anonyms block Preview 02:35

Creating Script and run it Preview 04:50

Chapter 2 Quiz

Chapter 2 Quiz

About Variables and the syntax Preview 07:02

Defining Variables exercise Preview 06:46

Guidelines for declaring & initializing variables Preview 03:33

Delimiters in string literals (the q' Notation) Preview 05:32

Types of variables and data types 1 Preview 05:53

Types of variables and data types 2 Preview 05:26

Data Types exercise Preview 05:58

Define Variables Using %TYPE Preview 05:34

Understating the SELECT statement in PL/SQL Preview 04:33

Bind Variables Preview 06:08

Chapter 3 Quiz

Chapter 3 Quiz

Inside PL/SQL Block Preview 06:20

Inside PL/SQL Block (exercise) Preview 06:13

Nested Blocks Preview 07:19

SQL & PL/SQL programing Guidelines Preview 04:07

Chapter 4 Quiz

Chapter 4 Quiz

SELECT statement & DML in PL/SQL Preview 04:13

SELECT statement & DML in PL/SQL exercise Preview 06:20

Understanding Implicit SQL cursor/ SQL Attributes Preview 03:24

Implicit SQL cursor exercise Preview 05:17

Chapter 5 Quiz

Chapter 5 Quiz

IF Statement Part 1 Preview 06:15

IF Statement Part 2 Preview 06:44

Handling nulls in IF statement Preview 03:58

CASE expression & CASE Statement Preview 08:10

Basic Loop Preview 06:15

While Loop Preview 04:14

FOR Loop Preview 04:47

Nested Loops Preview 06:14

Nested Loops and Labels Preview 04:49

Continue Statement Preview 04:47

Chapter 6 Quiz

Chapter 6 Quiz

PL/SQL Records: Programmer method part 1 Preview 07:21

PL/SQL Records: Programmer method part 2 Preview 06:58

PL/SQL Records: %ROWTYPE method Preview 08:37

Nested PL/SQL Records Preview 05:20

INDEX BY tables (Associative arrays) Preview 10:40

INDEX BY tables Methods Preview 07:30

INDEX BY tables of Records Preview 07:24

nested table Preview 10:40

Varray Preview 05:23

Chapter 7 Quiz

Chapter 7 Quiz

Understanding Explicit Cursor Preview 12:26

Explicit Cursor exercise Preview 08:34

Explicit Cursor Attributes Preview 06:10

FOR LOOP Cursor Preview 04:17

Cursor with Parameters Preview 04:41

FOR UPDATE Clause & CURRENT OF Clause Preview 05:32

Chapter 8 Quiz

Chapter 8 Quiz

Understanding Exceptions Preview 06:24

Predefined Oracle Server Error Exception Preview 07:25

Common mistakes when dealing with exceptions Preview 03:39

Non-Predefined Oracle Server Error Exception Preview 06:22

User-Defined Error Exception Preview 05:40

Group Functions and exceptions Preview 04:15

Many blocks and many exceptions Preview 04:06

Chapter 9 Quiz

Chapter 9 Quiz

Understanding Procedures and subprograms Preview 08:07

Understanding Procedures Syntax Preview 05:01

Creating Procedure (IN parameter) Preview 09:09

Creating Procedure (OUT parameter) Preview 07:53

Creating Procedure (IN OUT parameter) Preview 04:31

Comparing the Paramter Modes Preview 02:39

Available notations for passing parameters Preview 08:26

Using the default option for Parameters Preview 03:37

Exception handling in multiple blocks Preview 08:45

Using Boolean and PL/SQL records as parameters Preview 05:05

Chapter 10 Quiz

Chapter 10 Quiz

Understanding user-defined functions Preview 04:52

Difference between procedures & functions Preview 04:05

Creating function example Preview 09:14

No_data_found and functions Preview 03:41

Advantages of user-defined functions in SQL Statements Preview 07:09

Restrictions when calling functions from SQL part 1 Preview 05:08

Restrictions when calling functions from SQL part 2 Preview 05:35

Chapter 11 Quiz

Chapter 11 Quiz

Understanding packages by nice example Preview 09:28

More about packages Preview 03:23

Creating package practice Preview 06:44

Creating package specification without body Preview 06:16

Guidelines for writing packages Preview 07:27

The visibility of a package’s components Preview 04:46

When & Why to recompile the package? Preview 06:26

Chapter 12 Quiz

Chapter 12 Quiz

Understanding Overloading Subprograms in PL/SQL Preview 04:47

Overloading Subprograms practices (procedures) Preview 09:16

Overloading Subprograms practices (functions) Preview 04:42

Overloading Standard package Preview 03:57

Forward Declaration Preview 09:21

Persistent State of packages Preview 06:40

Using PRAGMA SERIALLY_REUSABLE Preview 04:04

Persistent State and cursor Preview 07:54

using pl/sql tables in packages Preview 00:04

Chapter 13 Quiz

Chapter 13 Quiz

About oracle-supplied Packages Preview 03:04

DBMS_OUTPUT part 1 Preview 08:44

DBMS_OUTPUT part 2 Preview 08:53

UTL_FILE Package Part 1 / create directory Preview 06:58

UTL_FILE Package Part 2 / get_line example 1 Preview 05:18

UTL_FILE Package Part 3 / get_line example 2 Preview 03:06

UTL_FILE Package Part 4 / put_line Preview 04:50

UTL_FILE Package Part 5 / exceptions Preview 05:32

UTL_MAIL Preview 04:03

UTL_MAIL.send Preview 06:43

utl_mail.send_attach_raw Preview 09:02

utl_mail.send_attach_varchar2 Preview 04:22

Chapter 14 Quiz

Execution flow of SQL Preview 03:15

what is Dynamic SQL? Preview 05:16

Execute immediate example 1 / delete any table Preview 05:48

Execute immediate example 2 / DDL in PLSQL Preview 07:50

Execute immediate example 3 / USING Clause Preview 05:26

Execute immediate example 4 / INTO Clause Preview 03:58

Execute immediate example 5 / single row query Preview 05:02

What is REF Cursor ? Preview 05:08

Dynamic SQL with multi row query Preview 04:57

Execute immediate/ more examples Preview 05:57

DBMS_SQL Package VS Execute immediat Preview 11:24

Chapter 15 Quiz

Standardizing Part 1 Preview 08:26

Standardizing Part 2 Preview 04:12

Definer’s Rights Preview 09:15

Invoker’s Rights Preview 03:40

Autonomous Transactions Preview 06:19

Features Autonomous Transactions Preview 02:32

The (IN) parameters always passed by reference Preview 04:22

The (out/in out) parameters can be passed by value or reference Preview 04:32

Passing by reference example (IN parameters) Preview 03:02

Passing by value VS passing by reference using nocopy Preview 09:51

When Does NOCOPY hint has no effects? Preview 07:11

NOCOPY Performance Exercise Preview 03:26

Using the PARALLEL_ENABLE hint Preview 03:14

Using the RESULT_CACHE hint Preview 06:59

Using the DETERMINISTIC hint Preview 02:54

Understanding Bulk Binding Preview 03:55

Bulk Binding Example Preview 05:29

Bulk binding with save exception part 1 Preview 07:58

Bulk binding with save exception part 2 Preview 07:23

Understanding Bulk collect Preview 02:34

Bulk collect another example Preview 03:36

Bulk collect and cursors Preview 04:39

using returning in bulk collect Preview 07:29

INDICES OF Preview 04:48

Chapter 16 Quiz

Understanding Triggers Preview 06:04

Tirgger Types/ Trigger Event Types Preview 03:46

Statement Level trigger VS Row Level (Part 1) Preview 05:55

Statement Level trigger VS Row Level (Part 2) Preview 03:14

Triggers common cases Preview 02:47

Statement Level trigger Example 1 Preview 04:45

Statement Level trigger Example 2 Preview 02:56

Understanding the NEW & OLD qualifiers Preview 02:31

Row level trigger example Preview 07:07

Row level trigger (create Audit table) Preview 10:11

Trigger Firing sequence Preview 08:09

Compile/enable/ disable/ drop trigger Preview 03:19

Using the triggers for populating a default value Preview 02:48

Instead of triggers ( on Views) Preview 07:48

Chapter 17 Quiz

Follows Statement in triggers Preview 05:38

Understanding Compound triggers Preview 06:36

Understanding Mutating Table Preview 06:21

Solving Mutating Table issue using compound trigger Preview 07:04

Using Compound trigger & array to solve Mutating Preview 07:44

Mutating table & ON DELETE CASCADE Preview 05:12

Database Triggers VS Stored procedures Preview 01:59

Creating DDL triggers ( Schema or Database ) Preview 07:41

Create system event trigger Preview 06:09

Final comments about the triggers Preview 04:45

Chapter 18 Quiz

Introduction about PL/SQL compiler Preview 05:58

Understanding ( Plsql_code_type ) parameter Preview 08:41

Understanding ( plsql_optimize_level ) parameter Preview 07:29

Understanding Warnings in PL/SQL Preview 06:05

Understanding (plsql_warnings) parameter Preview 08:02

More examples for plsql_warnings Preview 09:48

using the package dbms_warning Preview 09:44

Chapter 19 Quiz

Understanding conditional compilation Preview 05:45

Understanding (dbms_db_version ) package Preview 03:09

conditional compilation examples Preview 08:27

Understanding plsql_ccflags part 1 Preview 07:07

Understanding plsql_ccflags part 2 Preview 05:33

Understanding plsql_ccflags part 3 Preview 04:29

plsql_ccflags Real example Preview 07:32

Understanding Obfuscation Preview 04:06

dbms_ddl.create_wrapped Preview 06:18

The Wrapper Utility part 1 Preview 04:54

The Wrapper Utility part 2 Preview 08:14

Understanding dependencies Preview 04:01

Impact of changing referenced object Preview 02:51

Example of changing referenced object Preview 05:05

Query the Direct and indirect dependencies 1 Preview 05:02

Query the Direct and indirect dependencies 2 Preview 10:36

Objects could have 4 statuses Preview 03:05

Understanding invalidation of Dependent Objects Preview 02:58

Invalidation of Dependent Objects Example Preview 09:30

Impact of adding/altering the referenced object on the View Preview 08:34

Impact of adding/altering the referenced object on the function Preview 06:11

Impact of adding/altering the referenced object on the procedure Preview 05:02

Packages and Dependencies Part 1 Preview 02:34

Packages and Dependencies Part 2 Preview 05:20

Synonyms and Dependencies part 1 Preview 06:01

Synonyms and Dependencies part 2 Preview 08:39

Synonyms and Dependencies part 3 Preview 03:40

Guidelines for reducing invalidation Preview 02:42

Understanding Remote Dependencies Preview 03:39

Understanding Database link Preview 03:45

Creating new pluggable DB & DB link Preview 12:55

Remote Dependencies & time stamp Preview 07:54

Example: Remote Dependencies & time stamp Preview 12:19

Example: Remote Dependencies & Signature mode Preview 09:20

permanent solution for ORA-01033 oracle initialization or shutdown in progress Preview 00:24

DML logs using package dbms_errlog Preview 08:28

Move your skills to Oracle Analytic Functions In-Depth & Advanced Oracle SQL Preview 00:22

oracle 18c express edition part 1 (download and install ) Preview 08:59

oracle 18c express edition part 2 (unlock hr ) Preview 11:32

oracle 18c express edition part 3 ( sql developer ) Preview 06:46