by | Released February 2016 | ISBN: 9781771375702

In this Learning Oracle PL/SQL training course, expert author Darryl Hurley will teach you how to write solid and secure code. This course is designed for users that already have a basic understanding of Oracle PL/SQL.You will start by learning the basics, including block structure, scalar variables, nested tables, and loops. From there, Darryl will teach you about errors, data manipulation, and database procedure. This video tutorial also covers packages, triggers, and functions. You will also learn about code compilation, code assessment, security, and dynamic SQL. Finally, you will learn about Data Definition Language (DDL), transactions, and PL/SQL in SQL.Once you have completed this computer based training course, you will have learned everything you need to know to be able to write effective code with PL/SQL. Working files are included, allowing you to follow along with the author throughout the lessons. Show and hide more Publisher resources Download Example Code

1. Introduction/The Basics
   • Course Introduction 00:04:55
   • About The Author 00:01:50
   • Block Structure 00:04:09
   • Scalar Variables 00:01:31
   • Rowtype Variables 00:02:22
   • Introduction To Tables 00:03:16
   • Index By Tables 00:03:12
   • Nested Tables 00:03:05
   • Varrays 00:04:05
   • Loops 00:05:51
   • Control Structures 00:01:15
2. Errors
   • Error Introduction 00:05:14
   • Predefined Exceptions 00:05:44
   • Exception Handlers 00:05:13
   • User Defined Exceptions 00:03:16
3. Data Manipulation
   • Query Introduction 00:03:02
   • Cursors 00:09:08
   • Ref Cursors 00:03:45
   • Nested Cursors 00:03:31
   • Cursor Loops 00:01:53
   • Bulk Fetch 00:03:40
   • Inserting Data 00:02:31
   • Bulk Inserts 00:02:52
   • Insert Returning 00:02:43
   • Insert Save Exceptions 00:04:34
   • Updating Data 00:03:38
   • Bulk Updates 00:03:13
   • Update Returning 00:05:02
   • Update Save Exceptions 00:03:55
   • Deleting Data 00:02:56
   • Bulk Deletes 00:02:40
   • Delete Returning 00:03:39
   • Delete Save Exceptions 00:04:18
   • Merge 00:06:17
4. Database Procedure
   • Procedures 00:04:29
   • Calling Procedures 00:04:06
5. Packages
   • Package Specification 00:03:24
   • Package Bodies 00:03:07
   • Package Private And Public 00:02:55
   • Calling Packages 00:04:35
6. Triggers
   • DML Triggers 00:08:16
   • Trigger Ordering 00:03:05
   • Compound Triggers 00:03:12
   • DDL Triggers 00:05:31
   • Instead Of Triggers 00:07:43
   • Event Triggers 00:05:28
   • After Suspend Triggers 00:06:39
7. Functions
   • Functions 00:03:52
   • Result Cache Functions 00:02:52
   • Table Functions 00:05:46
   • Pipelined Functions 00:02:55
   • Parallel Table Functions 00:06:38
   • Streaming Table Functions 00:04:12
8. Code Compilation
   • PLSQL Compilation 00:03:29
   • Inquiry Directives 00:04:42
   • Conditional Compilation 00:04:35
   • PLSQL Optimize 00:02:19
9. Code Assessment
   • PLSQL Warnings 00:05:51
   • PLSQL Profiler 00:03:47
   • PLSQL Trace 00:01:35
   • PLSQL Scope 00:06:42
10. Security
    • Invoker Rights 00:05:45
    • Security Roles 00:02:58
    • Accessible By 00:03:24
    • Bequeath View 00:02:27
    • Inherit Privileges 00:03:48
    • Secure Roles 00:03:53
11. Dynamic SQL
    • Dynamic SQL 00:02:40
    • Dynamic SQL Parameters 00:04:25
    • Dynamic SQL Returning 00:02:55
12. Data Definition Language
    • DDL Create 00:03:06
    • DDL Modify 00:02:34
    • DDL Drop 00:04:10
13. Tansactions
    • Transactions 00:08:22
    • Read Only Transactions 00:02:38
    • Serializable Transactions 00:04:22
    • Autonomous Transactions 00:04:13
    • Savepoints 00:04:58
14. PLSQL In SQL
    • PLSQL In SQL 00:06:09
15. Wrap Up
    • Wrap Up 00:00:40
Show and hide more