For individuals who develop database-centric Internet applications for Oracle. Oracle Certified Associates - PL/SQL demonstrate expertise in building database-centric Internet applications for both Oracle9i and Oracle Database 10g.
Create reports of sorted and restricted data
Employ SQL functions to generate and retrieve customized data
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Use the SET operators to create subsets of data
Run data manipulation statements (DML) to update data in the Oracle Database 11g
Run data definition language (DDL) statements to create and manage schema objects
Identify the major structural components of the Oracle Database 11g
The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.