Books & Videos

Table of Contents

Chapter: Introduction

Oracle PL/SQL Programming Fundamentals LiveLessons: Introduction

05m 21s

Chapter: Lesson 1: PL/SQL Course Overview

Learning Objectives

00m 18s

1.1 Understand the course pre-requisites

01m 11s

1.2 Learn the Oracle database objects to be used in this course

02m 33s

1.3 Review the command-line SQL*Plus tool

03m 48s

1.4 Review SQL Developer tool

03m 28s

1.5 Review TOAD tool

03m 4s

Put it all together

00m 52s

Chapter: Lesson 2: Oracle PL/SQL Overview

Learning Objectives

00m 27s

2.1 Review Oracle architecture

04m 2s

2.2 Review PL/SQL overview

07m 57s

Put it all together

00m 43s

Chapter: Lesson 3: PL/SQL Basics and Variables

Learning Objectives

00m 18s

3.1 Explore PL/SQL basics

05m 3s

3.2 Use PL/SQL variables

22m 37s

Put it all together

00m 33s

Chapter: Lesson 4: Logic Flow

Learning Objectives

00m 22s

4.1 Understand IF/THEN/ELSE logic

09m 14s

4.2 Explore the CASE statement

06m 27s

4.3 Utilize looping syntax

12m 41s

Put it all together

00m 16s

Chapter: Lesson 5: PL/SQL Cursors

Learning Objectives

00m 18s

5.1 Introduce PL/SQL cursors and the implicit cursor

05m 0s

5.2 Explore explicit cursors

10m 31s

Put it all together

00m 48s

Chapter: Lesson 6: PL/SQL Exception Handling

Learning Objectives

00m 33s

6.1 Introduce PL/SQL exceptions

02m 6s

6.2 Explore PL/SQL exception basic syntax

03m 44s

6.3 Discover implicit vs explicit exceptions

04m 31s

6.4 Work with SQLCODE and SQLERRM features

02m 43s

6.5 Understand user-defined exceptions

02m 12s

6.6 Use application-defined exceptions

05m 30s

Put it all together

01m 8s

Chapter: Lesson 7: PL/SQL Procedures and Functions

Learning Objectives

00m 30s

7.1 Introduce PL/SQL procedures and functions

02m 7s

7.2 Explore PL/SQL procedures

04m 33s

7.3 Understand PL/SQL functions

06m 5s

7.4 Work with parameter passing

15m 6s

Put it all together

00m 42s

Chapter: Lesson 8: PL/SQL Packages

Learning Objectives

00m 18s

8.1 Introduce PL/SQL packages

02m 56s

8.2 Explore the package syntax

03m 13s

8.3 Review executing code in packages

07m 53s

Put it all together

00m 30s

Chapter: Lesson 9: PL/SQL Triggers

Learning Objectives

00m 24s

9.1 Introduce PL/SQL triggers

03m 25s

9.2 Explore the trigger syntax

03m 53s

9.3 Review the order of trigger processing and other restrictions

02m 43s

9.4 Work with useful examples

07m 59s

Put it all together

00m 49s

Chapter: Lesson 10: PL/SQL New Features

Learning Objectives

00m 15s

10.1 Introduce PL/SQL new features

00m 40s

10.2 Explore the new features with tips and techniques

13m 22s

Put it all together

00m 47s

Chapter: Lesson 11: PL/SQL Collections

Learning Objectives

00m 36s

11.1 Introduce PL/SQL collections

01m 25s

11.2 Explore the collection syntax

03m 2s

11.3 Review code examples

05m 12s

11.4 Explore bulk binding techniques

07m 25s

Put it all together

00m 33s

Chapter: Lesson 12: PL/SQL Debugger, PL/SQL Profiler, PL/SQL Tuning Tips

Learning Objectives

00m 43s

12.1 Introduce PL/SQL debugging, PL/SQL profiling, PL/SQL coding tips

00m 22s

12.2 Explore the TOAD debugger

08m 38s

12.3 Explore the SQL developer debugger

05m 40s

12.4 Review the PL/SQL profiler

01m 43s

12.5 Use the PL/SQL profiler with SQL*Plus

05m 25s

12.6 Use the TOAD PL/SQL profiler

03m 52s

12.7 Review PL/SQL coding tips

09m 36s

Put it all together

00m 39s

Chapter: Oracle PL/SQL Programming Fundamentals LiveLessons: Summary

Summary

00m 47s