O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Oracle 11g PL-SQL Fundamentals II

Video Description

The objective of this Oracle 11g training course is to provide an introduction to develop database server-side PL/SQL program units within an Oracle database. The areas covered include understanding the basic form and structure of program units stored within the database, building and maintaining stored procedures, functions, packaged programs, and database triggers. Additional topics include taking advantage of advanced programming techniques such as cursor variables and cursor expressions. This Oracle 11g course will prepare students for the Oracle certification exams (OCP).

Table of Contents

  1. Introduction
    1. Introduction 00:02:47
  2. Lesson 1 - Preparing Your Environment
    1. Install Oracle XE 00:11:07
    2. SQL Developer Installation 00:19:48
    3. Workstation Setup 00:12:14
  3. Lesson 2 - Database Program Units
    1. Introducing the Database Program Unit 00:19:12
  4. Lesson 3 - Working with Stored Procedures and Functions
    1. Creating Stored Procedures and Functions 00:18:51
  5. Lesson 3 - Working with Stored Procedures and Functions
    1. Understanding the Parameter Specification 00:23:04
  6. Lesson 3 - Working with Stored Procedures and Functions
    1. Executing Procedures and Functions 00:26:19
  7. Lesson 3 - Working with Stored Procedures and Functions
    1. Calling Functions from within SQL 00:13:12
  8. Lesson 3 - Working with Stored Procedures and Functions
    1. Handling Compilation Errors 00:08:27
  9. Lesson 4 - Maintaining Stored Procedures and Functions
    1. Recompiling and Dropping Programs 00:16:13
  10. Lesson 4 - Maintaining Stored Procedures and Functions
    1. Data Dictionary Storage 00:24:54
  11. Lesson 4 - Maintaining Stored Procedures and Functions
    1. Managing Dependencies 00:12:59
  12. Lesson 4 - Maintaining Stored Procedures and Functions
    1. Tracking Dependencies 00:08:32
  13. Lesson 4 - Maintaining Stored Procedures and Functions
    1. Using the Dependency Tracking Utility 00:09:32
  14. Lesson 5 - Creating and Maintaining Packages
    1. What is a Package? 00:10:09
  15. Lesson 5 - Creating and Maintaining Packages
    1. Creating a Package 00:19:11
  16. Lesson 5 - Creating and Maintaining Packages
    1. Package Definition Information 00:07:59
  17. Lesson 5 - Creating and Maintaining Packages
    1. Advanced Programming Techniques 00:06:14
  18. Lesson 5 - Creating and Maintaining Packages
    1. Using Persistent Global Objects 00:03:44
  19. Lesson 5 - Creating and Maintaining Packages
    1. Including Initialization Logic 00:15:24
  20. Lesson 5 - Creating and Maintaining Packages
    1. Object Oriented Support within Packages 00:13:51
  21. Lesson 5 - Creating and Maintaining Packages
    1. Package Maintenance 00:17:54
  22. Lesson 6 - Advanced Cursor Techniques
    1. Learning to Use Cursor Variables 00:23:45
  23. Lesson 6 - Advanced Cursor Techniques
    1. Weak Cursor Definitions 00:16:17
  24. Lesson 6 - Advanced Cursor Techniques
    1. REFCURSOR Cursor Definition 00:05:13
  25. Lesson 6 - Advanced Cursor Techniques
    1. Using Cursor Expressions 00:13:44
  26. Lesson 7 - Using System Supplied Packages
    1. Using the DBMS_OUTPUT() Package 00:11:45
  27. Lesson 7 - Using System Supplied Packages
    1. Using the UTL_FILE() Package 00:29:37
  28. Lesson 8 - Creating Database Triggers
    1. Understanding the Database Trigger 00:23:25
  29. Lesson 8 - Creating Database Triggers
    1. Statement-Level Triggers 00:22:42
  30. Lesson 8 - Creating Database Triggers
    1. Row-Level Triggers 00:12:11
  31. Lesson 8 - Creating Database Triggers
    1. Row Level Trigger Example 1 00:11:16
  32. Lesson 8 - Creating Database Triggers
    1. Row Level Trigger Example 2 00:07:32
  33. Lesson 8 - Creating Database Triggers
    1. Row Level Trigger Example 3 00:07:43
  34. Lesson 8 - Creating Database Triggers
    1. Working with the INSTEAD OF Trigger 00:11:01
  35. Lesson 8 - Creating Database Triggers
    1. Using Triggers within an Application 00:08:54
  36. Lesson 9 - Trigger Maintenance
    1. Using the CALL Statement 00:09:15
  37. Lesson 9 - Trigger Maintenance
    1. Trigger Maintenance Tasks 00:12:22
  38. Lesson 9 - Trigger Maintenance
    1. Working with Multiple Triggers for a Single Table 00:10:54
  39. Lesson 9 - Trigger Maintenance
    1. Handling Mutating Table Issues 00:22:16
  40. Lesson 9 - Trigger Maintenance
    1. Using the Compound Trigger 00:05:42
  41. Lesson 10 - Working with System Event Triggers
    1. What is a System Event Trigger? 00:05:32
  42. Lesson 10 - Working with System Event Triggers
    1. Defining Scope 00:03:44
  43. Lesson 10 - Working with System Event Triggers
    1. Identifying Available System Events 00:12:19
  44. Conclusion
    1. Conclusion 00:01:38