• Online, Self-Paced
Course 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.

Learning Objectives

Using SQL*Plus

  • 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

 

Writing SQL Statements and Arithmetic Expressions

  • 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

 

Column Aliases, Strings, and Duplicate Rows

  • 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

 

Practice: Using SQL to Retrieve Data

  • 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.