The Complete Pl/Sql Bootcamp : "Beginner To Advanced Pl/Sql" (updated 9/20220)

A Comprehensive Guide to Make You a Job-Ready PL/SQL Developer.Also Covers Oracle 1Z0-144 and 1Z0-149 PL SQL Exam Topics

What you'll learn
Pass the Oracle 1Z0-149 : Program with PL/SQL Certification Exam - on your first try!
Pass the Oracle 1Z0-148 : Advanced PL/SQL Certification Exam - on your first try!
Anything You Need for Coding PL/SQL From Beginner Level to Advanced Level
Every Subject is Explained from the Easiest to the Most Advanced.
Real-World Examples for Every Section
Some Advanced SQL Techniques
Use SQL Developer Efficiently for PL/SQL
Learn PL/SQL Architecture Very Well
Improve Performance of SQL& PL/SQL Codes
Create Your Dynamic SQL & PL/SQL Queries
Learn PL/SQL Object Oriented Programming
Learn PL/SQL Tuning for Performance
Learn & Master PL/SQL by Coding with Hundreds of Practical Examples!
Become a Job-Ready Oracle PL/SQL Developer Certified Professional!
Requirements
Basic knowledge of Oracle SQL
Description
Latest Course Updates: (Sep 2022): "Oracle-Supplied PL/SQL Packages" section was added!(Aug 2022): "Using Dynamic SQL & PL/SQL in PL/SQL" section is added!(Jun 2022): Closed-Captions are added!(May 2022): New Quiz Questions are added!Become an Oracle Database PL/SQL Developer Certified Professional!This comprehensive PL/SQL Programming Bootcamp is created for Real Beginner to Advanced PL/SQL Subjects with hundreds of Real-World Examples. Every subject starts from the simplest for non-programmers and goes until the most advanced parts for the students who already know PL/SQL. Every student who wants to learn or Become a Hero in PL/SQL will find everything that they are looking for. Students will learn and improve their: PL/SQL Coding Skills SQL & PL/SQL Performance PL/SQL ScalabilityPortability and Security about Database and PL/SQL ProgrammingAnd also our students will be prepared for:Exam Number: 1Z0-149 Oracle Database 19c: Program with PL/SQL  Oracle Certification ExamExam Number: 1Z0-148 Oracle Database 12c: Advanced PL/SQL        | Oracle Certification ExamExam Number: 1Z0-144 Oracle Database 12c: Program with PL/SQL | Oracle Certification ExamExam Number: 1Z0-144 Oracle Database 11g: Program with PL/SQL | Oracle Certification ExamOur PL/SQL Programming Bootcamp Covers:PL/SQL TerminologiesPL/SQL ArchitecturePL/SQL VariablesPL/SQL Control StructuresIf-Then-Else StructureCase ExpressionsLoops While LoopFor LoopNested LoopLoop LabelingContinue StatementGOTO StatementUsing SQL inside PL/SQLPL/SQL CursorsUsing PL/SQL Program Units (Functions & Procedures)PL/SQL PackagesPL/SQL Exceptions & Exception Handling PL/SQL DebuggingDynamic SQL & PL/SQLPL/SQL Composite Data Types (Collections)Associative ArraysNested TablesVarraysRecordsPL/SQL TriggersOracle-Supplied PackagesUsing Large Objects in PL/SQL (LOBs)Using PL/SQL Object OrientedUsing PL/SQL CompilerPL/SQL Performance &TuningPL/SQL CachingPL/SQL SecurityPL/SQL Fine-Grained Access Control (VPD)PL/SQL HintsPL/SQL Object DependenciesDesigning Better PL/SQLUsing Java/C in PL/SQLManaging DependenciesImportant Note: This course will be continuously getting updated with more lectures, quizzes, assessments to enhance your knowledge of Oracle PL/SQLSee you in the first lecture!

Overview

Section 1: What is PL/SQL ?

Lecture 1 Course Introductory Video

Lecture 2 UDEMY 101: How to Use Udemy? +Some Useful Tips

Lecture 3 What is PL/SQL and Why to Use?

Lecture 4 PL/SQL Architecture

Lecture 5 What is Pluggable Database?

Lecture 6 The Sample (HR) Schema Used in This Course

Lecture 7 Welcoming Gifts: Course Material & PL/SQL Cheatsheet

Section 2: Software Installation

Lecture 8 About the Database Installation

Lecture 9 The Ways to Get a Database

Lecture 10 Option 1: Installing VMware and VirtualBox on Windows

Lecture 11 Option 1: How to Install the Virtual Box on Mac OS X?

Lecture 12 Option 1: Downloading Virtual Machine Image

Lecture 13 Option 1: Configuring the VMware Virtualization Software

Lecture 14 Option 1: Configuring the Oracle VirtualBox Virtualization Software

Lecture 15 Option 1: Configuring SQL Developer inside of the Virtual Machine

Lecture 16 Option 2: Downloading and Installing the Oracle Database

Lecture 17 Option 2: Unlocking the HR Schema

Lecture 18 Option 2: Configuring and Using the SQL Developer

Lecture 19 Option 2: Installing Sample Schemas in Oracle Database

Lecture 20 Option 2: HR Schema Create Code (if you could not get the HR user in other ways)

Lecture 21 Option 3: Using Oracle Live SQL

Lecture 22 Option 3: About Oracle Live SQL Restrictions

Section 3: Let's Start Coding!

Lecture 23 Anonymous Blocks

Lecture 24 PL/SQL Outputs

Section 4: PL/SQL Variables

Lecture 25 What are Variables and Why to Use Them?

Lecture 26 Naming Rules & Naming Conventions

Lecture 27 Declaring & Initializing & Using Variables - Part 1

Lecture 28 Declaring & Initializing & Using Variables - Part 2

Lecture 29 Declaring & Initializing & Using Variables (Code Samples)

Lecture 30 Using %TYPE Attribute

Lecture 31 Using %Type Attribute (Code Samples)

Lecture 32 PL/SQL Delimiters and Commenting Your Code

Lecture 33 PL/SQL Delimiters and Commenting (Code Samples)

Lecture 34 PL SQL Variable Scope

Lecture 35 PL SQL Variable Scope (Code Samples)

Lecture 36 Using Bind Variables

Lecture 37 Using Bind Variables (Code Samples)

Section 5: Control Structures

Lecture 38 What are Control Structures & IF Statements

Lecture 39 What are Control Structures & IF Statements (Code Samples)

Lecture 40 Case Expressions

Lecture 41 Case Expressions (Code Samples)

Lecture 42 What are Loops - Basic Loops

Lecture 43 Basic Loops (Code Samples)

Lecture 44 While Loops

Lecture 45 While Loops (Code Samples)

Lecture 46 For Loops

Lecture 47 For Loops (Code Samples)

Lecture 48 Nested Loops & Loop Labeling

Lecture 49 Nested Loops & Loop Labeling (Code Samples)

Lecture 50 Continue Statement

Lecture 51 Continue Statement (Code Samples)

Lecture 52 GOTO Statement

Lecture 53 GOTO Statement (Code Samples)

Section 6: Using SQL in PL/SQL

Lecture 54 Operating with Selected Database Data..

Lecture 55 Operating Wİth Selected Queries (Code Samples)

Lecture 56 DML Operations in PL/SQL

Lecture 57 DML Operations in PL/SQL (Code Samples)

Lecture 58 Using Sequences in PL/SQL

Lecture 59 Using Sequences in PL/SQL (Code Samples)

Lecture 60 Extra - Enabling Server Outputs by Default

Section 7: Composite Data Types

Lecture 61 Simple Data Types vs Composite Data Types

Lecture 62 PL/SQL Records - Part 1

Lecture 63 PL/SQL Records - Part 2

Lecture 64 PL/SQL Records (Code Samples)

Lecture 65 Easy DML With Records

Lecture 66 Easy DML With Records (Code Samples)

Lecture 67 What Are Collections?

Lecture 68 Varrays & Collection Methods

Lecture 69 Varrays (Code Samples)

Lecture 70 Nested Tables

Lecture 71 Nested Tables (Code Samples)

Lecture 72 PL&SQL Associative Arrays (Part 1)

Lecture 73 PL&SQL Associative Arrays (Part 2)

Lecture 74 Associative Arrays (Code Samples)

Lecture 75 Storing Collections in Tables - (Part 1)

Lecture 76 Storing Collections in Tables - (Part 2)

Lecture 77 Storing Collections in Tables (Code Samples)

Section 8: PL/SQL Cursors

Lecture 78 What are Cursors and Cursor Types in PL SQL?

Lecture 79 Using Explicit Cursors

Lecture 80 Using Explicit Cursors (Code Samples)

Lecture 81 Using Cursors with Records

Lecture 82 Cursors with Records (Code Samples)

Lecture 83 Looping with Cursors

Lecture 84 Looping with Cursors (Code Samples)

Lecture 85 PL SQL Cursors with Parameters

Lecture 86 PL SQL Cursors with Parameters (Code Samples)

Lecture 87 PL SQL Cursor Attributes

Lecture 88 PL SQL Cursor Attributes (Code Samples)

Lecture 89 For Update Clause

Lecture 90 For Update Clause (Code Samples)

Lecture 91 Where Current Of Clause

Lecture 92 Where Current Of Clause (Code Samples)

Lecture 93 Reference Cursors

Lecture 94 Reference Cursors - (Code Samples)

Section 9: PL/SQL Exceptions

Lecture 95 What are the Exceptions?

Lecture 96 What are the Exceptions (Code Sample)

Lecture 97 Handling the Exceptions!

Lecture 98 Handling the Exceptions (Code Samples)

Lecture 99 Handling the Nonpredefined Exceptions

Lecture 100 Handling Nonpredefined Exceptions (Code Sample)

Lecture 101 Handling & Raising User-Defined Exceptions

Lecture 102 Handling & Raising User-Defined Exceptions (Code Samples)

Lecture 103 Using RAISE_APPLICATION_ERROR() Procedure

Lecture 104 Using RAISE_APPLICATION_ERROR() Procedure (Code Samples)

Section 10: PL/SQL Functions & Procedures

Lecture 105 What are Functions & Procedures and Why We Use?

Lecture 106 What are Functions & Procedures and Why We Use (Code Samples)

Lecture 107 Creating and Using Stored Procedures

Lecture 108 Creating and Using Stored Procedures (Code Samples)

Lecture 109 Using IN & OUT Parameters

Lecture 110 Using IN & OUT Parameters (Code Samples)

Lecture 111 Named & Mixed Notations and Default Option

Lecture 112 Named & Mixed Notations and Default Option (Code Samples)

Lecture 113 Creating and Using Functions (Part 1)

Lecture 114 Creating and Using Functions (Part 2)

Lecture 115 Creating and Using PL/SQL Functions (Code Samples)

Lecture 116 Local Subprograms

Lecture 117 Local Subprograms (Code Samples)

Lecture 118 Overloading the Subprograms

Lecture 119 Overloading the Subprograms (Code Samples)

Lecture 120 Handling the Exceptions in Subprograms

Lecture 121 Handling the Exceptions in Subprograms (Code Samples)

Lecture 122 Finding & Removing the Subprograms

Lecture 123 Regular & Pipelined Table Functions

Lecture 124 Regular & Pipelined Table Functions (Code Samples)

Section 11: PL/SQL Packages

Lecture 125 What Are Packages?

Lecture 126 Creating & Using & Modifying & Removing the Packages

Lecture 127 Creating & Using & Modifying & Removing the Packages (Code Samples)

Lecture 128 Visibility of Package Objects

Lecture 129 Visibility of Package Objects (Code Samples)

Lecture 130 Illegal Object Reference & Forward Declaration

Lecture 131 Package Initialization

Lecture 132 Persistent State of Packages - Part 1

Lecture 133 Persistent State of Packages - Part 2

Lecture 134 Persistent State of Packages (Code Samples)

Lecture 135 Using Collections in Packages - Part 1

Lecture 136 Using Collections in Packages - Part 2

Lecture 137 Using Collections in Packages (Code Samples)

Lecture 138 How Can I Find the Packages?

Section 12: PL/SQL Triggers

Lecture 139 What are Triggers & Trigger Types

Lecture 140 Understanding DML Triggers

Lecture 141 Specifying the Timing of Triggers

Lecture 142 Specifying the Timing of Triggers (Code Samples)

Lecture 143 Statement & Row Level Triggers

Lecture 144 Statement & Row Level Triggers (Code Samples)

Lecture 145 Using New & Old Qualifiers in Triggers

Lecture 146 Using New & Old Qualifiers in Triggers (Code Samples)

Lecture 147 Using Conditional Predicates

Lecture 148 Using Conditional Predicates (Code Samples)

Lecture 149 Using RAISE_APPLICATION_ERROR Procedure in Triggers

Lecture 150 Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples)

Lecture 151 Using Update Of Event in Triggers

Lecture 152 Using Update Of Event in Triggers (Code Samples)

Lecture 153 Using WHEN Clause in Triggers

Lecture 154 Using When Clause in Triggers (Code Samples)

Lecture 155 INSTEAD OF Triggers

Lecture 156 Instead of Triggers (Code Samples)

Lecture 157 Exploring & Managing the Triggers

Lecture 158 Creating Disabled Triggers

Lecture 159 Creating Disabled Triggers (Code Samples)

Lecture 160 Additional Real-World Examples for DML Triggers

Lecture 161 Additional Real-World Examples for DML Triggers (Code Samples)

Lecture 162 Compound Triggers

Lecture 163 Compound Triggers (Code Samples)

Lecture 164 Handling Mutating Table Errors

Lecture 165 Handling Mutating Table Errors (Code Samples)

Section 13: PL/SQL Debugging: Debugging Your Codes & Subprograms

Lecture 166 PL/SQL Debugging: Debugging Your Subprograms - (Part 1)

Lecture 167 PL/SQL Debugging: Debugging Your Subprograms - (Part 2)

Lecture 168 PL/SQL Debugging: Debugging Your Subprograms - (Part 3)

Lecture 169 Granting Debug Privileges to a User

Lecture 170 PL/SQL Debugging: Debugging the Anonymous Blocks

Lecture 171 Source Code: Debugging the Anonymous Blocks

Section 14: Using Dynamic SQL & PL/SQL in PL/SQL!

Lecture 172 Introduction to Dynamic SQL and Dynamic PL/SQL

Lecture 173 Native Dynamic SQL, PL/SQL

Lecture 174 EXECUTE IMMEDIATE Statement

Lecture 175 Execute Immediate Statement (Code Samples)

Lecture 176 EXECUTE IMMEDIATE STATEMENT with the USING Clause

Lecture 177 EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples)

Lecture 178 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses

Lecture 179 EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples)

Lecture 180 EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause

Lecture 181 Execute Immediate with Bulk Collect (Code Samples)

Lecture 182 Dynamic PL/SQL Blocks

Lecture 183 Dynamic PL/SQL Blocks (Code Sample)

Lecture 184 OPEN - FOR, FETCH Statements

Lecture 185 OPEN - FOR, FETCH Statements (Code Sample)

Lecture 186 Using the DMBS_SQL Package (The Method 4)

Lecture 187 Using the DBMS_SQL Package (Code Samples)

Section 15: Using Oracle-Supplied Packages

Lecture 188 What are Oracle Supplied Packages?

Lecture 189 Using the DBMS_OUTPUT Package

Lecture 190 Using the DBMS_OUTPUT Package (Code Samples)

Lecture 191 Using the UTL_FILE Package (Part 1)

Lecture 192 Using the UTL_FILE Package (Part 2)

Lecture 193 Using the UTL_FILE Package (Part 3)

Lecture 194 Using the UTL_FILE Package (Code Samples)

Lecture 195 Using the UTL_MAIL Package (Part 1)

Lecture 196 Using the UTL_MAIL Package (Part 2)

Lecture 197 Using the UTL_MAIL Package (Code Samples)

Lecture 198 For Your Attention!..

Section 16: Appendix

Lecture 199 Appendix 1: Oracle Database 12c Installation into Your Computer

Lecture 200 Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c?

Lecture 201 Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c

Section 17: Bonus

Lecture 202 Bonus Lecture

Anyone who wants to learn PL/SQL Programming Language,Anyone who is looking for Beginner PL/SQL Subjects,Anyone who is looking for Advanced PL/SQL Subjects,Anyone who wants to pass "Oracle 1Z0-144 Program with PL/SQL" Exam,Anyone who wants to pass "Oracle 1Z0-148 Advanced PL/SQL" Exam,Anyone who wants to pass "Oracle 1Z0-149: Program with PL/SQL" Exam with Oracle Database 19c,SQL Developers (All Levels),Beginner & Intermediate PL/SQL Developers,Database Administrators,Application Designers,Software Developers