Oracle Database 12c R2 SQL: Using Basic SELECT statements Overview/Description Expected Duration Lesson Objectives Course Number Expertise Level Overview/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.
Expected Duration (hours)
1.0
Lesson 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
Course Number: it_dfosfd_03_enus
Expertise Level
Beginner