Oracle Database 10g: Database Interfaces

This course is included in our On-demand training solution.

Overview

To explain how to use SQL and SQL*Plus to access an Oracle 10g database and introduce other common database interfaces

Target Audience

Anyone wanting to learn about Oracle Database 10g database administration

Prerequisites

An understanding of database concepts and technologies

Expected Duration

180 min.

Course Objectives

Oracle Database 10g: Database Interfaces

  • identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
  • recognize how to use the DESCRIBE, PROMPT, and SELECT commands to work with data.
  • recognize how to join tables and use DML and DDL statements to manipulate and define data.
  • identify the functions of different SQL statements and recognize the function of data locking.
  • identify ways of sending SQL commands to a database and recognize how to start SQL*Plus and iSQL*Plus.
  • use SQL*Plus and iSQL*Plus to manage data.
  • identify the basic elements of PL/SQL and recognize the uses of PL/SQL.
  • identify the characteristics of some common database interfaces.
  • identify how Oracle works with common database interfaces.
  • SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?