Oracle 11g PL/SQL Part 1 - Beginner
Write your first PL/SQL programs in Oracle 11g at your own pace: choose the right database tools, build blocks with DECLARE, BEGIN and EXCEPTION sections, use explicit cursors, nest blocks and meet declared subprograms.
About this course
Write your first PL/SQL programs in Oracle 11g at your own pace: choose the right database tools, build blocks with DECLARE, BEGIN and EXCEPTION sections, use explicit cursors, nest blocks and meet declared subprograms.
Curriculum
- Introduction
- Course Setup
- Selecting the Appropriate Database Tool
- Understanding PL SQL
- PL SQL Blocks
- Working with SQL Plus
- DECLARE Clause Objects
- PL SQL Available Data Types
- Declaring Simple Data Types and Assignments
- Declaring Complex Data Types and Assignments
- Declaring Complex RowTypes and Assignments
- Declaring Complex Tables
- Declaring Complex Records
- Creating and Declaring User-Defined Types
- What Can Be Included in the BEGIN Clause
- Working with CHAR and VARCHAR2 Variables
- Handling String Literals
- Working with Numeric Variables
- Working with Date Variables
- Assigning and Using Boolean Variables
- Using Comparison Operators
- Using SQL Functions
- SQL DML within PL SQL
- Using SELECT
- Exceptions and Embedded SQL
- Using Sequences
- Logic Control and Branching
- Using GOTO
- Working with LOOPS
- Creating and Using the Indefinite Loop
- Creating and Using the Conditional Loop
- Using Nested Loops
- Using the If-Then-Else
- Using the CASE Statement
- What Are the Types of Exceptions
- Trapping Exceptions
- Identify Exception Details
- Creating User-Defined Exceptions
- Using SQLCODE and SQLERRM Objects
- Understand the Implicit Cursor
- Creating User-Defined Events
- Understanding the Concept and Purpose of Explicit Cursors
- Learn about Cursor Attributes
- Using the Continue Statement
- Working with Updateable Cursors
- Creating and Using Cursor Parameters
- FOR...LOOP Cursors
- Understanding Nested Blocks
- Understanding the Difference between Global vs Local Objects and Exceptions
- What Are Subprograms and How Are They Different from Nested Blocks
- Course Recap
Who it's for
Developers and analysts who know SQL and want to program inside Oracle Database.
Before you start
No formal prerequisites. Bring curiosity and a willingness to practise.
Related courses
More in Programming & Web Development →Advanced Java 9
Programming & Web Development
View course →Android Studio Development Essentials
Programming & Web Development
View course →Blockchain: An Overview for Business Professionals
Programming & Web Development
View course →Computer Vision with Python OpenCV
Programming & Web Development
View course →Database Design - Beginner
Programming & Web Development
View course →Flask Development with Python
Programming & Web Development
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.