Oracle PL-SQL Fundamentals

Video Description

The primary objective of this Oracle 11g training course is to provide an introduction to the PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming.

Table of Contents

  1. Introduction
    1. Introduction 00:03:13
  2. Lesson 1 Preparing Your Environment
    1. Course Setup 00:37:10
  3. Lesson 2 Working with Oracle Database Tools
    1. Selecting the Appropriate Database Tool 00:30:52
  4. Lesson 3 Language Features
    1. Understanding PL/SQL 00:18:06
  5. Lesson 3 Language Features
    1. PL/SQL Blocks 00:15:26
  6. Lesson 3 Language Features
    1. Working with SQL Plus 00:11:07
  7. Lesson 4 The DECLARE Clause
    1. DECLARE Clause Objects 00:16:32
  8. Lesson 4 The DECLARE Clause
    1. PL/SQL Available Data Types 00:17:02
  9. Lesson 4 The DECLARE Clause
    1. Declaring Simple Data Types and Assignments 00:12:23
  10. Lesson 4 The DECLARE Clause
    1. Declaring Complex Data Types and Assignments 00:10:45
  11. Lesson 4 The DECLARE Clause
    1. Declaring Complex RowTypes and Assignments 00:07:09
  12. Lesson 4 The DECLARE Clause
    1. Declaring Complex Tables 00:07:51
  13. Lesson 4 The DECLARE Clause
    1. Declaring Complex Records 00:08:19
  14. Lesson 4 The DECLARE Clause
    1. Creating and Declaring User-Defined Types 00:08:55
  15. Lesson 5 The BEGIN Clause
    1. What Can Be Included in the BEGIN Clause 00:07:09
  16. Lesson 5 The BEGIN Clause
    1. Working with CHAR and VARCHAR2 Variables 00:07:37
  17. Lesson 5 The BEGIN Clause
    1. Handling String Literals 00:07:48
  18. Lesson 5 The BEGIN Clause
    1. Working with Numeric Variables 00:06:47
  19. Lesson 5 The BEGIN Clause
    1. Working with Date Variables 00:06:07
  20. Lesson 5 The BEGIN Clause
    1. Assigning and Using Boolean Variables 00:07:51
  21. Lesson 5 The BEGIN Clause
    1. Using Comparison Operators 00:07:31
  22. Lesson 5 The BEGIN Clause
    1. Using SQL Functions 00:06:11
  23. Lesson 5 The BEGIN Clause
    1. SQL DML within PL/SQL 00:15:12
  24. Lesson 5 The BEGIN Clause
    1. Using SELECT 00:06:39
  25. Lesson 5 The BEGIN Clause
    1. Exceptions and Embedded SQL 00:11:23
  26. Lesson 5 The BEGIN Clause
    1. Using Sequences 00:14:35
  27. Lesson 5 The BEGIN Clause
    1. Logic Control and Branching 00:07:05
  28. Lesson 5 The BEGIN Clause
    1. Using GOTO 00:05:59
  29. Lesson 5 The BEGIN Clause
    1. Working with LOOPS 00:19:00
  30. Lesson 5 The BEGIN Clause
    1. Creating and Using the Indefinite Loop 00:07:06
  31. Lesson 5 The BEGIN Clause
    1. Creating and Using the Conditional Loop 00:08:55
  32. Lesson 5 The BEGIN Clause
    1. Using Nested Loops 00:11:41
  33. Lesson 5 The BEGIN Clause
    1. Using the If-Then-Else 00:19:01
  34. Lesson 5 The BEGIN Clause
    1. Using the CASE Statement 00:17:50
  35. Lesson 6 The EXCEPTION Clause
    1. What Are the Types of Exceptions 00:05:38
  36. Lesson 6 The EXCEPTION Clause
    1. Trapping Exceptions 00:05:39
  37. Lesson 6 The EXCEPTION Clause
    1. Identify Exception Details 00:11:04
  38. Lesson 6 The EXCEPTION Clause
    1. Creating User-Defined Exceptions 00:10:57
  39. Lesson 6 The EXCEPTION Clause
    1. Using SQLCODE and SQLERRM Objects 00:08:36
  40. Lesson 6 The EXCEPTION Clause
    1. Understand the Implicit Cursor 00:14:44
  41. Lesson 6 The EXCEPTION Clause
    1. Creating User-Defined Events 00:12:33
  42. Lesson 7 Explicit Cursors
    1. Understanding the Concept and Purpose of Explicit Cursors 00:18:17
  43. Lesson 7 Explicit Cursors
    1. Learn about Cursor Attributes 00:10:19
  44. Lesson 7 Explicit Cursors
    1. Using the Continue Statement 00:05:51
  45. Lesson 7 Explicit Cursors
    1. Working with Updateable Cursors 00:19:32
  46. Lesson 7 Explicit Cursors
    1. Creating and Using Cursor Parameters 00:14:52
  47. Lesson 7 Explicit Cursors
    1. FOR...LOOP Cursors 00:07:00
  48. Lesson 8 Nested Blocks
    1. Understanding Nested Blocks 00:10:54
  49. Lesson 8 Nested Blocks
    1. Understanding the Difference between Global vs Local Objects and Exceptions 00:12:42
  50. Lesson 9 Declared Subprograms
    1. What Are Subprograms and How Are They Different from Nested Blocks 00:17:56
  51. Conclusion
    1. Course Conclusion 00:03:59

Product Information

  • Title: Oracle PL-SQL Fundamentals
  • Author(s): Tim Miles
  • Release date: May 2013
  • Publisher(s): Intellezy
  • ISBN: 00053COMPUWORKS