Course Details

Previous Page


Oracle Database 12c - Introduction to SQL: Restrict, Sort, and Customize Output


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



Overview/Description
Database tables hold a large number of rows, which are often not sorted, in any specific order. This course will teach you how to selectively return only a subset of rows, sorted and customized. 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)
2.3

Lesson Objectives

Oracle Database 12c - Introduction to SQL: Restrict, Sort, and Customize Output

  • start the course
  • describe the limiting of rows selected in a query and how to use the WHERE clause in a SQL statement
  • use character strings and dates in a WHERE clause in a SQL statement
  • use the comparison operators in a WHERE clause in a SQL statement
  • use the BETWEEN and IN operators in a WHERE clause in a SQL statement
  • use the LIKE operator and combine wildcard characters in a WHERE clause in a SQL statement
  • use the NULL and logical operator conditions in a WHERE clause in a SQL statement
  • use the AND, OR and NOT operators in a WHERE clause in a SQL statement
  • define the rules of precedence in a WHERE clause in a SQL statement
  • use the ORDER BY clause to sort the data returned by a SQL statement
  • use the ROW_LIMITING_CLAUSE to limit the number of rows returned by a SQL statement
  • describe the use of substitution variables in a SQL statement and use a single-ampersand substitution variable to provide a value in a SQL statement
  • use substitution variables for column names, expressions and text in a SQL statement
  • reuse a substitution variable by making use a double-ampersand substitution variable in a SQL statement
  • use the DEFINE and VERIFY commands to create, assign, and verify a substitution variable when using SQL Developer
  • write a SQL statement using the WHERE clause and pass a substitution variable to the SQL statement
  • identify the types of SQL functions in a SQL statement and describe single-row functions
  • use character functions in a SQL statement
  • use the case-conversion functions in a SQL statement
  • use the character-manipulation functions in a SQL statement
  • use the nesting functions in a SQL statement
  • use the numeric ROUND and TRUNC functions in a SQL statement
  • use the MOD function in a SQL statement
  • work with dates and the RR date format in a SQL statement
  • use SYSDATE, CURRENT_DATE and CURRENT_TIMESTAMP functions in a SQL statement
  • use arithmetic operators with dates in a SQL statement
  • describe and use date-manipulation functions MONTHS_BETWEEN, ADD_MONTHS, NEXT_DAY, LAST_DAY in a SQL statement
  • use the numeric ROUND and TRUNC functions with dates
  • write a SQL statement using the CHARACTER, NUMBER, and DATE functions
  • Course Number:
    od_insq_a03_it_enus