Oracle Plsql Is My Game Exam 1z0 144
Tags: Oracle Certification , Pl/SQL
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