PL/SQL Programming (CT-301)
Description:
	The course covers: Selecting Rows, Limiting Selected Rows, Row Functions, Group Functions, Data Modeling, and Database Design. Creating Tables, Creating Sequences, Creating Views and Indexes, Subprograms, Developing and Controlling in PL/SQL blocks. This course will prepare students to take the Oracle Certified DBA and Developer test.
You Will Learn:
	- Performing complex data manipulation with cursors - Anchoring variables to database definitions - Exploiting the process flow control of EXCEPTIONs to retry problem transactions - Creating triggers to handle data integrity and derivation - Utilizing weak and strong cursor variables for dynamic SQL - Bulk collecting data into PL/SQL tables for instant retrieval - Coding polymorphic packages to minimize code maintenance - Loading PL/SQL tables in memory for quick retrieval - Crafting user-written functions for high-end user ad hoc requests - Creating global variables in bodiless packages for session processing