Oracle Database SQL and PLSQL Basics

Name: Oracle Database SQL and PLSQL Basics
Rating: 4.4 (57 reviews)

Last updated 7/2025

English

What you'll learn

8 sections • 37 lectures • 12h 39m total length

SELECT and FROM Clause36:40
Explore oracle database sql basics by mastering the select and from clause, distinct options, column expressions, and aliases; learn ddl, dml, and dcl concepts and practice with table structures.
WHERE and ORDER BY Clause35:05
Single Row Function48:07
Group Functions- GROUP BY , HAVING Clause14:11
Joins26:52
Subqueries38:46
Manipulating Data INSERT, UPDATE and DELETE28:11

Declaring Variables27:14
learn how to declare variables in pl/sql, understand the four blocks (declare, begin, exception, end), differentiate anonymous vs named blocks, and print outputs with dbms_output.
IF ELse, CASE, Loops26:45
Cursor - Implicit and Explicit45:14
Explore Oracle database cursors, comparing implicit and explicit cursors, declaring and using cursor variables in PL/SQL, opening, fetching, and closing, with parameterized queries and loop-based data retrieval.
Procedure37:50
Functions28:35
Exception Handling28:55
Packages29:38
Triggers29:33
Types in PLSQL19:50
Explore PL/SQL types by defining records and collections, declare and use type blocks, and fetch single or multiple records through anonymous blocks and packages.
PLSQL Record Types - Associate Array, Nested Table and VARRAY16:11
Bulk Collect, Insert, Update and Delete22:25
How to create/read files from Object Storage - OCI - Using DBMS_CLOUD API11:16

The course is for the Oracle Database Developers - which is designed for beginner level.

Starting with SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER by For Data Extraction Purpose

INSERT, UPDATE, DELETE for DML Operations

CREATE, ALTER , DROP For DDL Operations

In Procedural Language For SQL - Starting with Variable Declaration, Loops, CURSORS, API's etc are covered