Oracle Database 11g Components - identify the functions, capabilities, and terminology associated with Oracle Database 11g's components and relational databases in general. Using SQL Statements - recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables. The SQL SELECT Statement - recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database. Restricting Data - recognize the steps for limiting and ordering the rows returned by a SQL query. Sorting Data - recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands. SQL Functions - recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data. Identifying and Writing SELECT Queries - identify and write SQL queries to display, sort, and format output in a given scenario.
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.