The Oracle Database: PL/SQL Fundamentals Ed 2 course introduces students to the PL/SQL programming language. In the class, students learn to create PL/SQL blocks of application code.
- Understanding the benefits and structure of PL/SQL
- Understanding PL/SQL Blocks
- Generating output messages in PL/SQL
- Identifying valid and invalid identifiers
- Declaring and initializing variables
- Various data types
- Identifying the benefits of using the %TYPE attribute
- Using bind variables
- Lexical Units in a PL/SQL Block
- Using SQL Functions in PL/SQL
- Data Type Conversion
- Using Nested Blocks as Statements
- Referencing an Identifier Value in a Nested Block
- Qualifying an Identifier with a Label
- Operators in PL/SQL
- Using Sequences in PL/SQL Expressions
- Using SQL Statements in PL/SQL
- Retrieving Data in PL/SQL with the SELECT statement
- Using Naming Conventions in DML Statements and data retrieval
- Manipulating Data on the Server Using PL/SQL
- SQL Cursors
- Using SQL Cursor Attributes to Obtain Feedback on DML
- Saving and Discarding Transactions
- Controlling PL/SQL Flow of Execution
- Using IF and CASE Statements for conditional processing
- Handling Nulls
- Building Boolean Conditions with Logical Operators
- Using Iterative Control with Loop Statements
- Composite Data Types of PL/SQL Records and Tables
- Using PL/SQL Records
- Inserting and Updating PL/SQL Records
- Using INDEX BY Tables
- Using Associative arrays
- Declaring and Using VArrays
- Cursors
- Explicit Cursor Operations
- Controlling Explicit Cursors
- Using Explicit Cursors to Process Rows
- Cursors and Records
- Cursor FOR Loops Using Subqueries
- Explicit Cursor Attributes
- %NOTFOUND and %ROWCOUNT Attributes
- Concept of Exception
- Handling Exceptions with PL/SQL
- Predefined Exceptions
- Trapping Predefined and Non-predefined Oracle Server Errors
- Functions that Return Information on Exceptions
- Usage of PRAGMA keyword
- Trapping User-Defined Exceptions
- Propagating Exceptions
- Overview of Stored Procedures and Functions
- Differentiating between anonymous blocks and subprograms
- CREATE OR REPLACE PROCEDURE | FUNCTION
- Understanding the Header Area of a Stored Procedure and Function
- Creating Simple Procedures and Functions
- Creating a Simple Procedure with an IN Parameter
- Executing a Procedure and a Function
•Technical Consultant•Portal Developer•PL/SQL Developer•Database Administrators•System Analysts•Forms Developer
•Required Prerequisites:•Familiarity with data processing concepts and technique•Familiarity with programming languages•Oracle Database 12c: Introduction for Experienced SQL Users•Suggested Prerequisites:•Familiarity with data processing concepts and techniques•Familiarity with programming languages
After completing this course, students will be able to:
Register
Not currently scheduled
Fast track the availability of this course.
Add to watch list or call 1300 794 006.
Add to watch list or call 1300 794 006.
Request a Quote
About Microsoft On-Demand Learning
Build your Microsoft technical expertise while balancing the demands of your schedule. The new MOC On-Demand series courses combine high-quality video lectures, live hands-on labs and knowledge-checks in a self-paced format to help you build skills as your schedule allows—all at once or five minutes at a time.
MOC On-Demand at a Glance
Self-Paced Learning
Immediate Feedback on Mastery
SATV Eligible
Direct From the Source
Learn Anywhere Anytime
Live Hands-on
Labs
