Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT Statement


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
SQL*Plus is an interactive and batch query tool that is installed with every Oracle Server and client installation. This course will teach you the features and functionality of SQL*Plus. You will learn to retrieve data using the SQL select statement including arithmetic expressions, Null values, column aliases, literal strings. You will also learn how to deal with duplicate rows. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: SQL Fundamentals exam (1ZO-061). The exam is part of the Oracle Certified Associate certification.

Target Audience
Functional Implementer, Forms Developer, System Analysts, Application Developers, PL/SQL Developer and learners looking to obtain the Oracle Database 12c Administrator Certified Associated designation or to become an OPN Certified Specialist.

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Oracle Database 12c - Introduction to SQL: SQL*Plus and SELECT Statement

  • start the course
  • describe the features of SQL and SQL*Plus
  • describe the SQL*Plus editing commands
  • use the LIST, n, APPEND and CHANGE SQL*Plus editing commands
  • describe the SQL*Plus file commands
  • use the SAVE and START SQL*Plus file commands
  • use the SERVEROUTPUT and SPOOL SQL*Plus commands
  • use the AUTOTRACE SQL*Plus command
  • describe and use the basic SELECT statement
  • 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
  • use the alternative quote (q) operator to select a quotation mark delimiter
  • 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:
    od_insq_a02_it_enus

    Expertise Level
    Beginner