Oracle SQL and PL/SQL
- Description
- Curriculum
- FAQ
- Reviews
- Grade
Introduction
This course is designed to equip you with the skills and knowledge required to become a
proficient PL/SQL developer. It covers the fundamentals of Oracle SQL, PL/SQL programming,
and advanced concepts, making it suitable for both beginners and experienced developers.
You’ll also gain the expertise to pass the Oracle 1Z0-149 certification exam on your first attempt.
What You’ll Learn
- Master Oracle SQL and PL/SQL programming from beginner to advanced levels.
- Prepare for the Oracle 1Z0-149 certification exam with confidence.
- Learn how to write and optimize queries, work with database objects, and manage transactions.
- Understand key concepts like triggers, cursors, collections, and exception handling.
- Develop real-world applications using Oracle PL/SQL.
-
1
UDEMY 101: How to Use Udemy? + TipsEnter Short Description of the lesson
-
2
PL/SQL Architecture
Enter Short Description of the lesson
-
3
What is a Pluggable Database?
Enter Short Description of the lesson
-
4
The Sample (HR) Schema Used in This Course
Enter Short descrption of the lesson
-
5
Course Materials & PL/SQL Cheatsheet
Enter Description of the lesson
-
6
Installing VMware and VirtualBox
Enter short description of the lesson
-
7
Installing VirtualBox on Mac OS X –
Enter Short Description of the Lesson
-
8
Downloading Virtual Machine Image
Enter Short Description of the Lesson
-
9
Installing VirtualBox and Oracle on Windows
Enter Short Description of the Lesson
-
10
Unlocking HR Schema
Enter Short Description of the Lesson
-
11
Installing Oracle Express Edition
Enter Short Description of the Lesson
-
12
Using Oracle Live SQL
Enter Short Description of the Lesson
-
13
Configuring SQL Developer
Enter Short Description of the Lesson
-
14
How to Reset a Forgotten Password
Enter Short Description of the Lesson
-
15
Enabling Server Output by Default
Enter Short Description of the Lesson
-
16
Configuring TNS Names
Enter Short Description of the Lesson
-
17
Setting Up SQL Developer on Mac OS
Enter Short Description of the Lesson
-
18
Anonymous Blocks
Enter Short Description of the Lesson
-
19
PL/SQL Outputs
Enter Short Description of the Lesson
-
20
Declaring and Initializing Variables
Enter Short Description of the Lesson
-
21
Data Types in PL/SQL
Enter Short Description of the Lesson
-
22
Using %TYPE Attribute
Enter Short Description of the Lesson
-
23
Constants and Literals
Enter Short Description of the Lesson
-
24
Scope of Variables
Enter Short Description of the Lesson
-
25
Built-in Functions in PL/SQL
Enter Short Description of the Lesson
-
26
Arithmetic Operations
Enter Short Description of the Lesson
-
27
Using DBMS_OUTPUT.PUT_LINE
Enter Short Description of the Lesson
-
28
Using Comments in PL/SQL
Enter Short Description of the Lesson
-
29
Creating Simple Scripts
Enter Short Description of the Lesson
-
30
Quiz on PL/SQL Basics
-
31
IF Statements
Enter Short Description of the Lesson
-
32
Nested IF Statements
Enter Short Description of the Lesson
-
33
CASE Statements
Enter Short Description of the Lesson
-
34
WHILE Loops
Enter Short Description of the Lesson
-
35
FOR Loops
Enter Short Description of the Lesson
-
36
Nested Loops
Enter Short Description of the Lesson
-
37
EXIT Statements
Enter Short Description of the Lesson
-
38
GOTO Statements
Enter Short Description of the Lesson
-
39
LOOP Labels
Enter Short Description of the Lesson
-
40
Quiz on Control Structures
-
41
DML Operations in PL/SQL
Enter Short Description of the Lesson
-
42
SELECT Statements in PL/SQL
Enter Short Description of the Lesson
-
43
Working with Sequences
Enter Short Description of the Lesson
-
44
Inserting Records Using PL/SQL
Enter Short Description of the Lesson
-
45
Fetching Data Using PL/SQL
Enter Short Description of the Lesson
-
46
Working with Multiple Tables
Enter Short Description of the Lesson
-
47
Using Joins in PL/SQL
Enter Short Description of the Lesson
-
48
Using COMMIT and ROLLBACK
Enter Short Description of the Lesson
-
49
Quiz on SQL in PL/SQL
-
50
PL/SQL Records
Enter Short Description of the Lesson
-
51
Using Nested Records
Enter Short Description of the Lesson
-
52
Collections in PL/SQL
Enter Short Description of the Lesson
-
53
Associative Arrays
Enter Short Description of the Lesson
-
54
Nested Tables
Enter Short Description of the Lesson
-
55
VARRAYs
Enter Short Description of the Lesson
-
56
Working with BULK COLLECT
Enter Short Description of the Lesson
-
57
Quiz on Composite Data Types
-
58
Introduction to Cursors
Enter Short Description of the Lesson
-
59
Explicit Cursors
Enter Short Description of the Lesson
-
60
Cursor FOR Loops
Enter Short Description of the Lesson
-
61
Cursor Attributes
Enter Short Description of the Lesson
-
62
Cursor Parameters
Enter Short Description of the Lesson
-
63
Implicit Cursors
Enter Short Description of the Lesson
-
64
Handling Cursors with Exceptions
Enter Short Description of the Lesson
-
65
Using Cursors in Nested Loops
Enter Short Description of the Lesson
-
66
Bulk Collect with Cursors
Enter Short Description of the Lesson
-
67
Quiz on Cursors
-
68
Predefined Exceptions
Enter Short Description of the Lesson
-
69
Non-Predefined Exceptions
Enter Short Description of the Lesson
-
70
User-Defined Exceptions
Enter Short Description of the Lesson
-
71
Using RAISE_APPLICATION_ERROR
Enter Short Description of the Lesson
-
72
Propagation of Exceptions
Enter Short Description of the Lesson
-
73
Handling Multiple Exceptions
Enter Short Description of the Lesson
-
74
Logging Exceptions
Enter Short Description of the Lesson
-
75
Nested Exception Blocks
Enter Short Description of the Lesson
-
76
Quiz on Exception Handling
-
77
Creating Functions
Enter Short Description of the Lesson
-
78
Using Parameters in Functions
Enter Short Description of the Lesson
-
79
Overloading Functions
Enter Short Description of the Lesson
-
80
Stored Procedures
Enter Short Description of the Lesson
-
81
IN, OUT, and IN OUT Parameters
Enter Short Description of the Lesson
-
82
Invoking Procedures from SQL
Enter Short Description of the Lesson
-
83
Using Functions in Joins
Enter Short Description of the Lesson
-
84
Recursive Functions
Enter Short Description of the Lesson
-
85
Quiz on Functions and Procedures
-
86
Creating Packages
Enter Short Description of the Lesson
-
87
Using Package Body
Enter Short Description of the Lesson
-
88
Persistent State of Packages
Enter Short Description of the Lesson
-
89
Using Private Subprograms
Enter Short Description of the Lesson
-
90
Maintaining Dependencies
Enter Short Description of the Lesson
-
91
Recompiling Packages
Enter Short Description of the Lesson
-
92
Debugging Packages
Enter Short Description of the Lesson
-
93
Quiz on Packages
-
94
Introduction to Triggers
Enter Short Description of the Lesson
-
95
DML Triggers
Enter Short Description of the Lesson
-
96
Using NEW and OLD Qualifiers
Enter Short Description of the Lesson
-
97
INSTEAD OF Triggers
Enter Short Description of the Lesson
-
98
Compound Triggers
Enter Short Description of the Lesson
-
99
Auditing with Triggers
Enter Short Description of the Lesson
-
100
Quiz on Triggers
Developers preparing for Oracle certification exams (1Z0-144, 1Z0-149).
IT professionals seeking to enhance their skills.
Access to a computer with Oracle Database installed (setup instructions are included).
Google