Oracle Plsql Fundamentals Vol I Ii

  1. Home
  2. Plsql
  3. Oracle Plsql Fundamentals Vol I Ii

Tags: Pl/SQL

A complete introduction to PL/SQL database programming language

Last updated 2022-01-10 | 4.5

- Over 90 lectures and 20 hours of content
- Prepare your enviornment
- Introducing Database Program Units

What you'll learn

Over 90 lectures and 20 hours of content
Prepare your enviornment
Introducing Database Program Units
Creating and Maintaining Packages
Using System-Supplied Packages
Creating and Maintaining Database Triggers
Implementing System Event Triggers
Work with Oracle database tools
Understand and work work language features
Work with DECLARE
BEGIN & EXCEPTION clause
Understand and use nested blocks
Use explicit cursors

* Requirements

* Familiarity with database and programming principles

Description

  • Over 90 lectures and 20 hours of content
  • Prepare your enviornment
  • Introducing Database Program Units
  • Creating and Maintaining Packages
  • Using System-Supplied Packages
  • Creating and Maintaining Database Triggers
  • Implementing System Event Triggers
  • Work with Oracle database tools
  • Understand and work work language features
  • Work with DECLARE, BEGIN & EXCEPTION clause
  • Understand and use nested blocks
  • Use explicit cursors

Course content

2 sections • 97 lectures

Oracle 11g PL/SQL Fundamentals I 51 lectures

Introduction Preview 03:06

The instructor has provided additional resources and example files for you to use. If you would like to access these, please download the attached .zip file, which contains the files shown in this course.

Course Setup Preview 37:03

Selecting the Appropriate Database Tool Preview 30:45

Understanding PL/SQL Preview 17:59

PL/SQL Blocks Preview 15:19

Working with SQL Plus Preview 11:00

DECLARE Clause Objects Preview 16:25

PL/SQL Available Data Types Preview 16:55

Declaring Simple Data Types and Assignments Preview 12:16

Declaring Complex Data Types and Assignments Preview 10:38

Declaring Complex RowTypes and Assignments Preview 07:02

Declaring Complex Tables Preview 07:44

Declaring Complex Records Preview 08:12

Creating and Declaring User-Defined Types Preview 08:48

What Can Be Included in the BEGIN Clause Preview 07:02

Working with CHAR and VARCHAR2 Variables Preview 07:30

Handling String Literals Preview 07:41

Working with Numeric Variables Preview 06:40

Working with Date Variables Preview 06:00

Assigning and Using Boolean Variables Preview 07:44

Using Comparison Operators Preview 07:24

Using SQL Functions Preview 06:11

SQL DML within PL/SQL Preview 15:05

Using SELECT Preview 06:32

Exceptions and Embedded SQL Preview 11:16

Using Sequences Preview 14:28

Logic Control and Branching Preview 06:58

Using GOTO Preview 05:52

Working with LOOPS Preview 18:53

Creating and Using the Indefinite Loop Preview 06:59

Creating and Using the Conditional Loop Preview 08:48

Using Nested Loops Preview 11:33

Using the If-Then-Else Preview 18:54

Using the CASE Statement Preview 17:43

What Are the Types of Exceptions Preview 05:31

Trapping Exceptions Preview 05:32

Identify Exception Details Preview 10:57

Creating User-Defined Exceptions Preview 10:49

Using SQLCODE and SQLERRM Objects Preview 08:29

Understand the Implicit Cursor Preview 14:37

Creating User-Defined Events Preview 12:26

Understanding the Concept and Purpose of Explicit Cursors Preview 18:10

Learn about Cursor Attributes Preview 10:12

Using the Continue Statement Preview 05:44

Working with Updateable Cursors Preview 19:25

Creating and Using Cursor Parameters Preview 14:45

FOR...LOOP Cursors Preview 06:53

Understanding Nested Blocks Preview 10:46

Difference between Global vs Local Objects and Exceptions Preview 12:35

Subprograms: How They Differ from Nested Blocks Preview 17:37

Conclusion Preview 03:52

Oracle 11g PL/SQL Fundamentals II 46 lectures

Introduction Preview 02:40

The instructor has provided additional resources and example files for you to use. If you would like to access these, please download the attached .zip file, which contains the files shown in this course.

Install Oracle XE Preview 10:59

SQL Developer Installation Preview 19:47

Workstation Setup Preview 12:14

Introducing the Database Program Unit Preview 19:05

Creating Stored Procedures and Functions Preview 18:44

Understanding the Parameter Specification Preview 22:57

Executing Procedures and Functions Preview 26:11

Calling Functions from within SQL Preview 13:05

Handling Compilation Errors Preview 08:26

Recompiling and Dropping Programs Preview 16:06

Data Dictionary Storage Preview 24:54

Managing Dependencies Preview 12:59

Tracking Dependencies Preview 08:32

Using the Dependency Tracking Utility Preview 09:32

What Is a Package? Preview 10:02

Creating a Package Preview 19:11

Package Definition Information Preview 07:59

Advanced Programming Techniques Preview 06:13

Using Persistent Global Objects Preview 03:44

Including Initialization Logic Preview 15:24

Object Oriented Support within Packages Preview 13:51

Package Maintenance Preview 17:54

Learning to Use Cursor Variables Preview 23:38

Weak Cursor Definitions Preview 16:17

REFCURSOR Cursor Definition Preview 05:13

Using Cursor Expression Preview 13:43

Using the DBMS OUTPUT() Package Preview 11:38

Using the UTL FILE() Package Preview 29:36

Understanding the Database Trigger Preview 23:18

Statement-Level Triggers Preview 22:42

Row-Level Triggers Preview 12:11

Row Level Trigger Example 1 Preview 11:15

Row Level Trigger Example 2 Preview 07:31

Row Level Trigger Example 3 Preview 07:42

Working with the INSTEAD OF Trigger Preview 11:00

Using Triggers within an Application Preview 08:54

Using the CALL Statement Preview 09:08

Trigger Maintenance Tasks Preview 12:22

Work with Multiple Triggers for a Single Table Preview 10:54

Handling Mutating Table Issues Preview 22:16

Using the Compound Trigger Preview 05:41

What Is a System Event Trigger Preview 05:25

Defining Scope Preview 03:43

Identifying Available System Events Preview 12:19

Conclusion Preview 01:38