Oracle Database 12c R2 SQL: Using Basic SELECT statements from Skillsoft

Online, Self-Paced

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