What is PL/SQL ?
- Course Introductory Video
- UDEMY 101: How to Use Udemy? +Some Useful Tips
- What is PL/SQL and Why to Use?
- PL/SQL Architecture
- The Sample (HR) Schema Used in This Course
- Bonus Materials : Course Material & PL/SQL Cheatsheet
- Quiz 1
Software Installation
- About the Database Installation
- Which Option to Choose to Have a Database?
- Option 1: Having the Database with the Oracle Virtual Box
- Option 1: How to Install the Virtual Box on Mac OS X?
- What is Pluggable Database?
- Option 2: Downloading and Installing the Oracle Database
- Option 2: Unlocking the HR Schema
- Option 2: Configuring and Using the SQL Developer
- Option 3: Using Oracle Live SQL
- Option 3: About Oracle Live SQL Restrictions
Let's Start Coding!..
- Anonymous Blocks
- PL/SQL Outputs
- Quiz 2
PL/SQL Variables
- What are Variables and Why to Use Them?
- Naming Rules & Naming Conventions
- Declaring & Initializing & Using Variables - Part 1
- Declaring & Initializing & Using Variables - Part 2
- Declaring & Initializing & Using Variables (Code Samples)
- Using %TYPE Attribute
- Using %Type Attribute (Code Samples)
- PL/SQL Delimiters and Commenting Your Code
- PL/SQL Delimiters and Commenting (Code Samples)
- PL SQL Variable Scope
- PL SQL Variable Scope (Code Samples)
- Using Bind Variables
- Using Bind Variables (Code Samples)
- Quiz 3 - Variables
Control Structures
- What are Control Structures & IF Statements
- What are Control Structures & IF Statements (Code Samples)
- Case Expressions
- Case Expressions (Code Samples)
- What are Loops - Basic Loops
- Basic Loops (Code Samples)
- While Loops
- While Loops (Code Samples)
- For Loops
- For Loops (Code Samples)
- Nested Loops & Loop Labeling
- Nested Loops & Loop Labeling (Code Samples)
- Continue Statement
- Continue Statement (Code Samples)
- GOTO Statement
- GOTO Statement (Code Samples)
- Quiz 4 - Control Structures
Using SQL in PL/SQL
- Operating with Selected Database Data..
- Operating Wİth Selected Queries (Code Samples)
- DML Operations in PL/SQL
- DML Operations in PL/SQL (Code Samples)
- Using Sequences in PL/SQL
- Using Sequences in PL/SQL (Code Samples)
- Bonus - Enabling Server Outputs by Default.
- Quiz 5 - Using SQL in PL/SQL
Composite Data Types
- Simple Data Types vs Composite Data Types
- PL/SQL Records - Part 1
- PL/SQL Records - Part 2
- PL/SQL Records (Code Samples)
- Easy DML With Records
- Easy DML With Records (Code Samples)
- What Are Collections?
- Varrays & Collection Methods
- Varrays (Code Samples)
- Nested Tables
- Nested Tables (Code Samples)
- PL&SQL Associative Arrays (Part 1)
- PL&SQL Associative Arrays (Part 2)
- Associative Arrays (Code Samples)
- Storing Collections in Tables - (Part 1)
- Storing Collections in Tables - (Part 2)
- Storing Collections in Tables (Code Samples)
- Quiz 6 - Composite Data Types
PL/SQL Cursors
- What are Cursors and Cursor Types in PL SQL?
- Using Explicit Cursors
- Using Explicit Cursors (Code Samples)
- Using Cursors with Records
- Cursors with Records (Code Samples)
- Looping with Cursors
- Looping with Cursors (Code Samples)
- PL SQL Cursors with Parameters
- PL SQL Cursors with Parameters (Code Samples)
- PL SQL Cursor Attributes
- PL SQL Cursor Attributes (Code Samples)
- For Update Clause
- For Update Clause (Code Samples)
- Where Current Of Clause
- Where Current Of Clause (Code Samples)
