Oracle Database 11g: Using SQL to Query Your Database

Target Audience

Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites

Familiarity with Data Processing Concepts and Techniques. Ability to use a graphical user interface (GUI)

Expected Duration (hours)
2.2

Lesson Objectives

Oracle Database 11g: Using SQL to Query Your Database

• Identify the functions, capabilities, and terminology associated with Oracle Database 11g's components and Relational databases in general.
• Recognize the steps for using Oracle SQL Developer to create a new database connection and browse tables.
• Recognize the steps for using the SQL SELECT statement to retrieve different sets of data from a database.
• Recognize the steps for limiting and ordering the rows returned by a SQL query.
• Recognize ways to sort data returned by a SQL query, using substitution variables as well as the DEFINE and VERIFY commands.
• Recognize the steps for using SQL functions to modify, format, and otherwise manipulate returned data.
• Identify and write SQL queries to display, sort, and format output in a given scenario.