Oracle PL/SQL Fundamentals vol. I & II

Oracle PL/SQL Fundamentals vol. I & II

English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 20 Hours | 7.68 GB

A complete introduction to PL/SQL database programming language

In this Oracle 11g PL/SQL Bundle you will receive introduction training on PL/SQL database programming language covering syntax, structure and features of the language within the context of database applications and programming. In volume II students will dive into topics such as 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).

What Will I Learn?

  • Over 90 lectures and 20 hours of content
  • Prepare your enviornment
  • Introducing Database Program Units
  • Creating and Maintaining Packages
  • Using System-Supplied Packages
  • Creating and Maintaining Database Triggers
  • Implementing System Event Triggers
  • Work with Oracle database tools
  • Understand and work work language features
  • Work with DECLARE, BEGIN & EXCEPTION clause
  • Understand and use nested blocks
  • Use explicit cursors
Table of Contents

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

Oracle 11g PLSQL Fundamentals II
52 Introduction
53 Install Oracle XE
54 SQL Developer Installation
55 Workstation Setup
56 Introducing the Database Program Unit
57 Creating Stored Procedures and Functions
58 Understanding the Parameter Specification
59 Executing Procedures and Functions
60 Calling Functions from within SQL
61 Handling Compilation Errors
62 Recompiling and Dropping Programs
63 Data Dictionary Storage
64 Managing Dependencies
65 Tracking Dependencies
66 Using the Dependency Tracking Utility
67 What Is a Package
68 Creating a Package
69 Package Definition Information
70 Advanced Programming Techniques
71 Using Persistent Global Objects
72 Including Initialization Logic
73 Object Oriented Support within Packages
74 Package Maintenance
75 Learning to Use Cursor Variables
76 Weak Cursor Definitions
77 REFCURSOR Cursor Definition
78 Using Cursor Expression
79 Using the DBMS OUTPUT() Package
80 Using the UTL FILE() Package
81 Understanding the Database Trigger
82 Statement-Level Triggers
83 Row-Level Triggers
84 Row Level Trigger Example 1
85 Row Level Trigger Example 2
86 Row Level Trigger Example 3
87 Working with the INSTEAD OF Trigger
88 Using Triggers within an Application
89 Using the CALL Statement
90 Trigger Maintenance Tasks
91 Work with Multiple Triggers for a Single Table
92 Handling Mutating Table Issues
93 Using the Compound Trigger
94 What Is a System Event Trigger
95 Defining Scope
96 Identifying Available System Events
97 Conclusion