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

Course Curriculum

Chapter 1: Course Setup

Lecture 1: Course Agenda

Lecture 2: Course Setup Notes / 4 Options

Lecture 3: Option 2- creating the HR Schema

Lecture 4: Option 3- Part 1 : Oracle Database 12c Architecture

Lecture 5: Option 3- Part 2 : Downloading Oracle DB 12c

Lecture 6: Option 3- Part 3 : Installing Oracle DB 12c

Lecture 7: Option 3- Part 4 : Connecting SYS using SQL plus & SQL Developer

Lecture 8: Option 3- Part 5: Unlock HR Account Part 1

Lecture 9: Option 3- Part 6 : Unlock HR Account Part 2

Lecture 10: Option 3- Part 7 : ORA-01033 oracle initialization or shutdown in progress 12c

Lecture 11: Option 4- Installing Oracle 11g express Edition + Unlock HR

Lecture 12: About Oracle 18c express edition

Lecture 13: HR Schema in this Course

Lecture 14: Navigate HR schema

Chapter 2: Overview of PL/SQL

Lecture 1: What is PL/SQL? What is the benefits?

Lecture 2: PL/SQL Block Structure & Types of Blocks

Lecture 3: Writing simple Anonymous block

Lecture 4: Using SQL*plus to run anonyms block

Lecture 5: Creating Script and run it

Chapter 3: Declaring PLSQL Variables

Lecture 1: About Variables and the syntax

Lecture 2: Defining Variables exercise

Lecture 3: Guidelines for declaring & initializing variables

Lecture 4: Delimiters in string literals (the q' Notation)

Lecture 5: Types of variables and data types 1

Lecture 6: Types of variables and data types 2

Lecture 7: Data Types exercise

Lecture 8: Define Variables Using %TYPE

Lecture 9: Understating the SELECT statement in PL/SQL

Lecture 10: Bind Variables

Chapter 4: Writing executable statements

Lecture 1: Inside PL/SQL Block

Lecture 2: Inside PL/SQL Block (exercise)

Lecture 3: Nested Blocks

Lecture 4: SQL & PL/SQL programing Guidelines

Chapter 5: Interacting with Oracle DB Server

Lecture 1: SELECT statement & DML in PL/SQL

Lecture 2: SELECT statement & DML in PL/SQL exercise

Lecture 3: Understanding Implicit SQL cursor/ SQL Attributes

Lecture 4: Implicit SQL cursor exercise

Chapter 6: Writing Control structure

Lecture 1: IF Statement Part 1

Lecture 2: IF Statement Part 2

Lecture 3: Handling nulls in IF statement

Lecture 4: CASE expression & CASE Statement

Lecture 5: Basic Loop

Lecture 6: While Loop

Lecture 7: FOR Loop

Lecture 8: Nested Loops

Lecture 9: Nested Loops and Labels

Lecture 10: Continue Statement

Chapter 7: Working with Composite Data Types

Lecture 1: PL/SQL Records: Programmer method part 1

Lecture 2: PL/SQL Records: Programmer method part 2

Lecture 3: PL/SQL Records: %ROWTYPE method

Lecture 4: Nested PL/SQL Records

Lecture 5: INDEX BY tables (Associative arrays)

Lecture 6: INDEX BY tables Methods

Lecture 7: INDEX BY tables of Records

Lecture 8: nested table

Lecture 9: Varray

Chapter 8: Using explicit cursors

Lecture 1: Understanding Explicit Cursor

Lecture 2: Explicit Cursor exercise

Lecture 3: Explicit Cursor Attributes

Lecture 4: FOR LOOP Cursor

Lecture 5: Cursor with Parameters

Lecture 6: FOR UPDATE Clause & CURRENT OF Clause

Chapter 9: Handling Exceptions

Lecture 1: Understanding Exceptions

Lecture 2: Predefined Oracle Server Error Exception

Lecture 3: Common mistakes when dealing with exceptions

Lecture 4: Non-Predefined Oracle Server Error Exception

Lecture 5: User-Defined Error Exception

Lecture 6: Group Functions and exceptions

Lecture 7: Many blocks and many exceptions

Chapter 10: Creating Procedure

Lecture 1: Understanding Procedures and subprograms

Lecture 2: Understanding Procedures Syntax

Lecture 3: Creating Procedure (IN parameter)

Lecture 4: Creating Procedure (OUT parameter)

Lecture 5: Creating Procedure (IN OUT parameter)

Lecture 6: Comparing the Paramter Modes

Lecture 7: Available notations for passing parameters

Lecture 8: Using the default option for Parameters

Lecture 9: Exception handling in multiple blocks

Lecture 10: Using Boolean and PL/SQL records as parameters

Chapter 11: Creating Functions

Lecture 1: Understanding user-defined functions