
PL/SQL Fundamentals
About this course:
The PL/SQL course is for anyone who is keen on learning the fundamentals of PL/SQL in Oracle. PL/SQL is a procedural extension for SQL and the Oracle database, made by Oracle. Pl/SQL can boost productivity as well as save time on design and debugging. Learning PL/SQL goes a long way in learning about databases,
Course Pre-requisites:
- Familiarization with SQL concepts is useful
Learning Units:
-
Unit 1: Flow Control
-
Unit 2: Cursors
-
Unit 3: Handling Runtime Errors
-
Unit 4: Stored Procedures and Functions
-
Unit 5: Working with Composite Data Types
-
Unit 6: PL/SQL Variables
-
Unit 7: Anonymous PL/SQL Blocks
-
Unit 8: Declare Identifiers and Trap Exceptions
-
Unit 9: Triggers
-
Unit 10: Using Dynamic SQL
-
Unit 11: PL/SQL Packages
Pass Requirement:
Minimum of 60% for the Master Quiz.
Minimum of 60% for the IKM assessment.
Course Duration:
1 Week
Access Duration:
1 Month