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,
- Familiarization with SQL concepts is useful
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
Minimum of 60% for the Master Quiz.
Minimum of 60% for the IKM assessment.