Oracle PL/SQL Fundamentals vol. I & II
What you'll 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
Requirements
- Familiarity with database and programming principles
Description
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).
Who this course is for:
- Application designers and developers
- Database administrators
- Business users and non-technical senior end users
Course content
- Preview03:06
- Preview37:03
- 30:45Selecting the Appropriate Database Tool
- Preview17:59Understanding PL/SQL
- 15:19PL/SQL Blocks
- Preview11:00Working with SQL Plus
- 16:25DECLARE Clause Objects
- 16:55PL/SQL Available Data Types
- 12:16Declaring Simple Data Types and Assignments
- 10:38Declaring Complex Data Types and Assignments
- 07:02Declaring Complex RowTypes and Assignments
- 07:44Declaring Complex Tables
- 08:12Declaring Complex Records
- Preview08:48Creating and Declaring User-Defined Types
- 07:02What Can Be Included in the BEGIN Clause
- 07:30Working with CHAR and VARCHAR2 Variables
- 07:41Handling String Literals
- 06:40Working with Numeric Variables
- 06:00Working with Date Variables
- 07:44Assigning and Using Boolean Variables
- 07:24Using Comparison Operators
- 06:11Using SQL Functions
- 15:05SQL DML within PL/SQL
- 06:32Using SELECT
- 11:16Exceptions and Embedded SQL
- 14:28Using Sequences
- 06:58Logic Control and Branching
- Preview05:52Using GOTO
- 18:53Working with LOOPS
- 06:59Creating and Using the Indefinite Loop
- 08:48Creating and Using the Conditional Loop
- 11:33Using Nested Loops
- 18:54Using the If-Then-Else
- 17:43Using the CASE Statement
- 05:31What Are the Types of Exceptions
- 05:32Trapping Exceptions
- 10:57Identify Exception Details
- 10:49Creating User-Defined Exceptions
- 08:29Using SQLCODE and SQLERRM Objects
- 14:37Understand the Implicit Cursor
- 12:26Creating User-Defined Events
- 18:10Understanding the Concept and Purpose of Explicit Cursors
- 10:12Learn about Cursor Attributes
- 05:44Using the Continue Statement
- 19:25Working with Updateable Cursors
- 14:45Creating and Using Cursor Parameters
- 06:53FOR...LOOP Cursors
- 10:46Understanding Nested Blocks
- 12:35Difference between Global vs Local Objects and Exceptions
- 17:37Subprograms: How They Differ from Nested Blocks
- Preview03:52
Instructor
Intellezy collaborates with organizations to help implement and adopt technology to its maximum potential. From our change management consulting to our learning and development services, Intellezy uses both culture and education to drive the ROI of any organization. Our online videos and quick reference guides are designed to educate and empower individuals, right when they need it. In today’s rapidly evolving workplace, it is imperative to make sure you have the skills and expertise required to succeed. Our library, recognized by top influencers such as eLearning Journal and The Craig Weiss Group, provides dynamic and task-focused videos right at your fingertips, right when you need them.