Plsql Beginner To Advanced Become A Perfect Plsql Developer

About the Database Installation Preview 03:02

The Ways to Get a Database Preview 14:50

In this SQL tutorial, the participants will learn how to get a database to proceed with The Complete PL/SQL Bootcamp: "Beginner to Advanced PL/SQL" course.

Option 1: Installing VMware and VirtualBox on Windows Preview 07:33

In this SQL tutorial, the participants will learn how to download and install two virtualization software programs which are VMware and VirtualBox step by step.

Option 1: How to Install the Virtual Box on Mac OS X? Preview 01:41

Option 1: Downloading Virtual Machine Image Preview 04:11

In this tutorial, the participants will learn how to download the virtual machine image.

Option 1: Configuring the VMware Virtualization Software Preview 08:18

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the VMware virtualization software as well as how to configure the virtual machine to get the most out of it.

Option 1: Configuring the Oracle VirtualBox Virtualization Software Preview 06:45

In this SQL tutorial, the participants will learn how to import the virtual machine image they downloaded into the Oracle VirtualBox virtualization software as well as how to configure the virtual machine to get the most out of it.

Option 1: Configuring SQL Developer inside of the Virtual Machine Preview 13:02

In this SQL tutorial, the participants will learn how to configure Oracle SQL Developer inside of the Virtual Machine image that they downloaded step by step.

What is Pluggable Database? Preview 03:13

In this lecture, students are going to learn what the pluggable database, in other words, multitenant architecture is in Oracle Database.

Option 2: Downloading and Installing the Oracle Database Preview 18:18

In this lecture, students are going to learn the oracle database 19c installation.

Lecture keywords: "oracle", "oracle sql", "oracle database", "oracle database installation", "oracle database 19c installation".

Option 2: Unlocking the HR Schema Preview 07:34

In this lecture, our students are going to learn how to unlock the HR schema to practice throughout the course.

Option 2: Configuring and Using the SQL Developer Preview 22:14

This lecture covers how to download and configure Oracle SQL Developer software and how to connect to the Oracle Database 19c.

Option 3: Using Oracle Live SQL Preview 07:40

Option 3: About Oracle Live SQL Restrictions Preview 00:24

Anonymous Blocks Preview 13:42

PL/SQL Outputs Preview 08:19

Quiz 2

This Quiz is about the anonymous blocks and PL/SQL Outputs

What are Variables and Why to Use Them? Preview 08:36

Naming Rules & Naming Conventions Preview 04:24

Declaring & Initializing & Using Variables - Part 1 Preview 10:44

In this lecture you will learn how to use variables with different ways.

Declaring & Initializing & Using Variables - Part 2 Preview 10:22

In this lecture you will learn how to use variables with different ways.

Declaring & Initializing & Using Variables (Code Samples) Preview 00:23

Using %TYPE Attribute Preview 07:07

In this lecture, you will learn how to use %TYPE operator to automatically assign the datatype.

Using %Type Attribute (Code Samples) Preview 00:06

PL/SQL Delimiters and Commenting Your Code Preview 05:36

In this lesson you will learn how to use delimiters and how to write comments and why to use them.

PL/SQL Delimiters and Commenting (Code Samples) Preview 00:07

PL SQL Variable Scope Preview 11:15

This lecture is about the scopes of variables in the blocks.

PL SQL Variable Scope (Code Samples) Preview 00:09

Using Bind Variables Preview 10:53

In this lesson you will learn a performance variable, bind variables.

Using Bind Variables (Code Samples) Preview 00:19

These are the codes that we used in Using Bind Variables Lesson

Quiz 3 - Variables

In this quiz, you will find multiple choice questions about the PL/SQL Variables.

What are Control Structures & IF Statements Preview 13:57

What are Control Structures & IF Statements (Code Samples) Preview 00:27

Case Expressions Preview 14:48

In this lecture you will learn how to use case expressions and case statements in PL/SQL. These are the control structures like If statements.

Case Expressions (Code Samples) Preview 00:32

What are Loops - Basic Loops Preview 10:11

In this lecture you will learn the loops terminology and how to use basic loops in PL/SQL..

Basic Loops (Code Samples) Preview 00:08

While Loops Preview 05:32

In this lecture you will learn how to use while loops of PL/SQL..

While Loops (Code Samples) Preview 00:06

For Loops Preview 09:54

For Loops (Code Samples) Preview 00:04

Nested Loops & Loop Labeling Preview 16:00

In this lecture you will learn how to use a loop inside another one and exiting the outer loop with using labels in PL/SQL.

Nested Loops & Loop Labeling (Code Samples) Preview 00:21

Continue Statement Preview 10:23

In this lecture you will learn how to use continue statement in PL/SQL Loops

Continue Statement (Code Samples) Preview 00:20

GOTO Statement Preview 13:30

GOTO Statement (Code Samples) Preview 00:26

Here you will find the codes of the examples that we did in our GOTO Statement lecture..

Quiz 4 - Control Structures

In this quiz you will find multiple choice quiz questions about the control strucures like if clause, loops, etc.

Operating with Selected Database Data.. Preview 18:26

In this lecture you will learn how to operate data that you queried from a table.

Operating Wİth Selected Queries (Code Samples) Preview 00:27

DML Operations in PL/SQL Preview 12:46

In this lecture, you will see how to insert, update and delete data in your tables with the help of PL/SQL.

DML Operations in PL/SQL (Code Samples) Preview 00:12

Using Sequences in PL/SQL Preview 12:37

You will learn how to use sequence objects in PL/SQL

Using Sequences in PL/SQL (Code Samples) Preview 00:57

In this lecture you will learn how to use sequences in PL/SQL with different ways.

Extra - Enabling Server Outputs by Default Preview 04:39

In this lecture you will learn how to make set serveroutput on command run automatically to enable server output.

Quiz 5 - Using SQL in PL/SQL

Simple Data Types vs Composite Data Types Preview 07:52

In this lecture you will learn the difference between scalar data types and complex data types.

PL/SQL Records - Part 1 Preview 16:40

PL/SQL Records - Part 2 Preview 16:30

In this lecture, you will learn how to create a complext type and a real-world like example about PL/SQL Records

PL/SQL Records (Code Samples) Preview 00:37

Easy DML With Records Preview 08:14

With this lecture, you will learn how to insert or update the data in your table with using records, easily.

Easy DML With Records (Code Samples) Preview 00:18

What Are Collections? Preview 06:14

In this lecture you will learn what are PL/SQL collections and a brief explanation about the types of the collections.

Varrays & Collection Methods Preview 22:59

Varrays (Code Samples) Preview 01:21

Nested Tables Preview 10:57

Nested Tables (Code Samples) Preview 00:41

PL&SQL Associative Arrays (Part 1) Preview 18:54

PL&SQL Associative Arrays (Part 2) Preview 14:53

Associative Arrays (Code Samples) Preview 02:12

Storing Collections in Tables - (Part 1) Preview 14:07

Storing Collections in Tables - (Part 2) Preview 11:15

Storing Collections in Tables (Code Samples) Preview 00:49

Here is the code samples that we used in composite data types section.

Quiz 6 - Composite Data Types

What are Cursors and Cursor Types in PL SQL? Preview 08:05

Using Explicit Cursors Preview 11:13

Using Explicit Cursors (Code Samples) Preview 00:21

Using Cursors with Records Preview 06:11

In this lecture you will learn how to use PL SQL records with cursors including cursor type records.

Cursors with Records (Code Samples) Preview 00:22

Looping with Cursors Preview 12:16

In this lecture you will learn how to loop with PL SQL cursors in many different ways. 

Looping with Cursors (Code Samples) Preview 00:46

In this article you will find the sample codes that we did in "Looping with Cursors" lecture

PL SQL Cursors with Parameters Preview 13:33

In this lecture you will learn how to use parameters with cursors. So you will use the same cursor with different parameters and you will get different results from the same cursor.

PL SQL Cursors with Parameters (Code Samples) Preview 01:36

In this article you will find the sample codes that we did in "Cursors with Parameters" lecture

PL SQL Cursor Attributes Preview 08:28

PL SQL Cursor Attributes (Code Samples) Preview 00:14

In this article you will find the sample codes that we did in "Cursor Attributes" lecture

For Update Clause Preview 20:32

In this lecture you will learn how to use the for update clause to lock the related rows

For Update Clause (Code Samples) Preview 00:39

Where Current Of Clause Preview 09:52

In this lecture you will learn how to update and delete the rows faster with using the wehre current of clause

Where Current Of Clause (Code Samples) Preview 00:31

Reference Cursors Preview 24:10

This lecture will be online today. It is processing and it takes some time.

Reference Cursors - (Code Samples) Preview 02:00

Here are the codes that we did in our lecture

What are the Exceptions? Preview 09:15

What are the Exceptions (Code Sample) Preview 00:03

Handling the Exceptions! Preview 17:55

Handling the Exceptions (Code Samples) Preview 01:26

Handling the Nonpredefined Exceptions Preview 06:24

Handling Nonpredefined Exceptions (Code Sample) Preview 00:10

Handling & Raising User-Defined Exceptions Preview 07:53

In this lecture you will learn how to handle the user-defined exceptions and raise an exception to its caller

Handling & Raising User-Defined Exceptions (Code Samples) Preview 00:45

Using RAISE_APPLICATION_ERROR() Procedure Preview 07:49

In this lecture you will learn how to raise an exception to the caller application with using pl sql raise_application_error procedure

Using RAISE_APPLICATION_ERROR() Procedure (Code Samples) Preview 00:33

What are Functions & Procedures and Why We Use? Preview 08:36

A brief description of the functions and procedures, and the difference between them and the anonymous blocks

What are Functions & Procedures and Why We Use (Code Samples) Preview 00:33

Creating and Using Stored Procedures Preview 16:51

Creating and Using Stored Procedures (Code Samples) Preview 00:44

Using IN & OUT Parameters Preview 14:34

In this lecture you will learn how to pass parameters to your procedures

Using IN & OUT Parameters (Code Samples) Preview 00:57

Named & Mixed Notations and Default Option Preview 16:25

Named & Mixed Notations and Default Option (Code Samples) Preview 00:33

Creating and Using Functions (Part 1) Preview 16:31

Creating and Using Functions (Part 2) Preview 07:21

Creating and Using PL/SQL Functions (Code Samples) Preview 00:19

Local Subprograms Preview 14:48

In this lecture you will learn why and how to create local functions and local procedures of PL SQL

Local Subprograms (Code Samples) Preview 00:48

Overloading the Subprograms Preview 13:11

In this lecture you will learn how to overload the functions and procedures

Overloading the Subprograms (Code Samples) Preview 00:46

Handling the Exceptions in Subprograms Preview 19:42

Handling the Exceptions in Subprograms (Code Samples) Preview 00:52

Finding & Removing the Subprograms Preview 11:02

In this lecture you will learn how to find your subprograms and how to drop the functions & procedures

Regular & Pipelined Table Functions Preview 19:32

In this lecture you will learn how to query a function just like a table.

Regular & Pipelined Table Functions (Code Samples) Preview 00:32

What Are Packages? Preview 09:37

In this lecture you will learn the concept of the package and why you should create PL/SQL packages.

Creating & Using & Modifying & Removing the Packages Preview 27:16

In this lecture you will learn how to create a package, how to use it, how to modify body and spec of a package and how to remove a package or a package body.

Creating & Using & Modifying & Removing the Packages (Code Samples) Preview 00:26

Visibility of Package Objects Preview 11:23

In this lecture you will learn the usage of public, private, global, local objects.

Visibility of Package Objects (Code Samples) Preview 00:42

Illegal Object Reference & Forward Declaration Preview 07:27

In this lecture you will learn when you will have the illegal object reference error and how to solve it with forward declaration

Package Initialization Preview 08:45

Persistent State of Packages - Part 1 Preview 19:13

In this lecture you will learn how the package objects are stored in the memory and how long do they live in there.

Persistent State of Packages - Part 2 Preview 13:59

In this lecture you will learn how the package objects are stored in the memory and how long do they live in there.

Persistent State of Packages (Code Samples) Preview 00:20

Using Collections in Packages - Part 1 Preview 26:12

Using Collections in Packages - Part 2 Preview 09:43

Using Collections in Packages (Code Samples) Preview 01:27

How Can I Find the Packages? Preview 07:28

In this lecture you will learn how to find the packages with using the SQL Developer tool and data dictionary views.

What are Triggers & Trigger Types Preview 10:00

In this lecture, you will learn the main concepts of triggers and brief explanations for the trigger types.

Understanding DML Triggers Preview 11:20

This lecture will show you the full picture of the DML Triggers

Specifying the Timing of Triggers Preview 19:02

Specifying the Timing of Triggers (Code Samples) Preview 00:13

Statement & Row Level Triggers Preview 13:29

In this lecture, you will learn the difference of statement and row level triggers, and see some examples about them.

Statement & Row Level Triggers (Code Samples) Preview 00:34

Using New & Old Qualifiers in Triggers Preview 19:22

Using New & Old Qualifiers in Triggers (Code Samples) Preview 00:10

Using Conditional Predicates Preview 10:26

Using Conditional Predicates (Code Samples) Preview 00:20

Using RAISE_APPLICATION_ERROR Procedure in Triggers Preview 05:32

Using RAISE_APPLICATION_ERROR Procedure in Triggers (Code Samples) Preview 00:24

Using Update Of Event in Triggers Preview 06:28

Using Update Of Event in Triggers (Code Samples) Preview 00:07

Using WHEN Clause in Triggers Preview 07:10

Using When Clause in Triggers (Code Samples) Preview 00:08

INSTEAD OF Triggers Preview 19:45

Instead of Triggers (Code Samples) Preview 00:29

Exploring & Managing the Triggers Preview 08:20

Creating Disabled Triggers Preview 05:05

Creating Disabled Triggers (Code Samples) Preview 00:08

Additional Real-World Examples for DML Triggers Preview 21:27

Additional Real-World Examples for DML Triggers (Code Samples) Preview 00:46

Compound Triggers Preview 27:39

In this lecture, we are going to see Compound Triggers in Oracle 11g, Oracle 12c – Tutorial with examples.

Compound Triggers (Code Samples) Preview 00:52

Handling Mutating Table Errors Preview 20:17

Handling Mutating Table Errors (Code Samples) Preview 01:11

PL/SQL Debugging: Debugging Your Subprograms - (Part 1) Preview 10:53

This lecture explains PL/SQL Debugging and how to debug PL SQL procedures and PL SQL functions step by step using PL SQL debugging feature.

PL/SQL Debugging: Debugging Your Subprograms - (Part 2) Preview 11:16

PL/SQL Debugging: Debugging Your Subprograms - (Part 3) Preview 08:42

Granting Debug Privileges to a User Preview 00:15

PL/SQL Debugging: Debugging the Anonymous Blocks Preview 05:49

Source Code: Debugging the Anonymous Blocks Preview 00:11

Introduction to Dynamic SQL and Dynamic PL/SQL Preview 12:43

In this PL/SQL tutorial, we will demonstrate an introductory PL/SQL lecture about using the Dynamic SQL and Dynamic PLSQL.

Native Dynamic SQL, PL/SQL Preview 11:15

In this PL/SQL tutorial, the students will learn the use of Native Dynamic SQL and Native Dynamic PL/SQL with several examples.

EXECUTE IMMEDIATE Statement Preview 10:55

In this PL/SQL tutorial, students are going to learn how to use the EXECUTE IMMEDIATE statement without using the USING and INTO clauses in Oracle PL/SQL programming with its various examples.

Execute Immediate Statement (Code Samples) Preview 00:19

The source codes used in the Execute Immediate Statement lecture

EXECUTE IMMEDIATE STATEMENT with the USING Clause Preview 15:15

In this PL/SQL tutorial, students will learn the second method of the EXECUTE IMMEDIATE statement which is the execute immediate with the USING clause with its several examples.

EXECUTE IMMEDIATE STATEMENT with the USING Clause (Code Samples) Preview 01:02

Includes the codes about how to use the execute immediate command with the USING clause

EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses Preview 12:30

In this PL/SQL tutorial, students will learn the third method of the EXECUTE IMMEDIATE statement which is the execute immediate with the USING and the INTO clauses with its examples.

EXECUTE IMMEDIATE STATEMENT with the USING and INTO Clauses (Code Samples) Preview 00:50

Inludes the codes we used in the Execute Immediate Statement with the USING and INTO clauses

EXECUTE IMMMEDIATE with BULK COLLECT INTO Clause Preview 05:57

In this PL/SQL tutorial, students are going to learn how to use the EXECUTE IMMEDIATE statement with the BULK COLLECT INTO clause in Oracle PL/SQL programming with its examples.

Execute Immediate with Bulk Collect (Code Samples) Preview 00:19

Inludes the codes we used with the Execute Immediate Statement with Bulk Collect

Dynamic PL/SQL Blocks Preview 11:46

In this PL SQL tutorial, students will learn how to write Dynamic PL SQL with examples.

Dynamic PL/SQL Blocks (Code Sample) Preview 01:24

The step by step code samples that we used in the DYNAMIC PL/SQL BLOCKS lesson

OPEN - FOR, FETCH Statements Preview 07:17

In this PL/SQL tutorial, students will learn the Oracle OPEN FOR FETCH statements with various examples.

OPEN - FOR, FETCH Statements (Code Sample) Preview 00:33

Includes step by step executions of the code lines we used in the OPEN-FOR, FETCH Statements lecture

Using the DMBS_SQL Package (The Method 4) Preview 24:01

In this PL SQL tutorial, the course participants will learn how to use the DMBS_SQL package or also known as "the Method 4" while using Dynamic SQL & PL/SQL in Oracle.

Using the DBMS_SQL Package (Code Samples) Preview 01:02

Includes step by step executions of the code lines we used in the USING THE DBMS_SQL PACKAGE lecture

What are Oracle Supplied Packages? Preview 07:10

This PL/SQL tutorial explains what the Oracle Supplied Packages are and why we need to use Oracle Supplied PL/SQL Packages.

Using the DBMS_OUTPUT Package Preview 13:59

In this PL SQL tutorial, participants will learn one of the most frequently used Oracle Supplied PL/SQL packages, which is the DBMS_OUTPUT package, either to display PL/SQL debugging information or to send text messages from PL SQL procedures and functions with various examples.

Using the DBMS_OUTPUT Package (Code Samples) Preview 00:29

This lecture covers step by step executions of the code lines we used in the "Using the DBMS_OUTPUT PACKAGE" lecture.

Using the UTL_FILE Package (Part 1) Preview 15:57

This PL SQL tutorial contains how to use the UTL_FILE package to let your PL/SQL programs read and write operating system (OS) text files.

Using the UTL_FILE Package (Part 2) Preview 17:41

This PL SQL tutorial contains how to use the UTL_FILE package to let your PL/SQL programs read and write operating system (OS) text files.

Using the UTL_FILE Package (Part 3) Preview 11:40

This PL SQL tutorial contains how to use the UTL_FILE package to let your PL/SQL programs read and write operating system (OS) text files.

Using the UTL_FILE Package (Code Samples) Preview 01:11

Includes step by step execution of the codes we used in the UTL_FILE package lecture

Using the UTL_MAIL Package (Part 1) Preview 13:05

In this PL SQL tutorial, students will learn how to use the UTL_MAIL package which is a utility for managing email that includes commonly used email features, such as attachments, CC, and BCC with its examples.

Using the UTL_MAIL Package (Part 2) Preview 13:56

In this part of the PL SQL UTL Mail Package tutorial lecture, students will continue to learn how to use the UTL_MAIL package which is a utility for managing email that includes commonly used email features, such as attachments, CC, and BCC with its examples.

Using the UTL_MAIL Package (Code Samples) Preview 02:29

Includes step by step execution of the codes we used in the UTL_MAIL package lecture

For Your Attention!.. Preview 00:43

Appendix 1: Oracle Database 12c Installation into Your Computer Preview 09:04

This lecture explains how to download and install Oracle Database 12c, from my first course.

I added this video again into my this course, since some of my students my not get the first course, but they confuse how to install the software.

Appendix 2: How to Unlock the HR Schema in the Oracle Database 12c? Preview 01:40

Appendix 3: Configuring and Using Oracle SQL Developer for Oracle Database 12c Preview 09:53

Bonus Lecture Preview 00:26