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 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