Introducing SQL and SQL*Plus - identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. Using SQL*Plus commands to work with data in Oracle 10g - recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data. Manipulating data in Oracle 10g - recognize how to join tables and use DML and DDL statements to manipulate and define data. Using transactions in Oracle 10g - identify the functions of different SQL statements and recognize the function of data locking. Managing data in Oracle 10g using SQL and SQL*Plus - identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus. Using SQL*Plus and iSQL*Plus to manage Oracle 10g data - use SQL*Plus and iSQL*Plus to manage data. Introducing PL/SQL - identify the basic elements of PL/SQL and recognize the uses of PL/SQL. Java, OCIs, and APIs - identify the characteristics of some common database interfaces. Using Oracle 10g with PL/SQL, Java, and OCI - identify how Oracle works with common database interfaces.
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.