SkillSoft.Oracle.Database.10g.Database.Interfaces.Release.2
SkillSoft.Oracle.Database.10g.Database.Interfaces.Release.2
Format: HTML/Flash | Size: 9 mb | Expected Duration: 180 Minutes
Format: HTML/Flash | Size: 9 mb | Expected Duration: 180 Minutes
Overview/Description:
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
Objectives:
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.
More info
Download