• Online, Self-Paced
Course Description

Explore how to retrieve data using SQL SELECT statements including arithmetic expressions, NULL values, column aliases, and literal strings. You will also learn how to deal with duplicate rows.

Learning Objectives

Oracle Database 12c R2 SQL: Using Basic SELECT statements

  • use the basic SELECT statements
  • recognize the rules and guidelines for constructing valid SQL statements in SQL Developer and SQL*Plus
  • describe and use the arithmetic expressions in SQL
  • apply the standard order of precedence in SQL arithmetic expressions
  • identify how NULL values are defined in SQL and how they affect arithmetic expression outcomes
  • define column aliases in the SELECT list
  • use the concatenation operator to create a character expression in the SQL statement output
  • use literal character strings in a SELECT statement
  • describe when to use the WHERE clause
  • eliminate duplicate rows from SQL statement output using the DISTINCT qualifier
  • display the structure of a table using the SQL*Plus DESCRIBE command
  • select data from different tables, describe tables, perform arithmetic calculations, and specify column names using aliases


Framework Connections

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.