Course details

Oracle Database 12c R2 SQL: Using Basic SELECT statements

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