Introduction to Oracle and SQL in Oracle9i

To introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements

Familiarity with RDBMS technologies and programming techniques

Junior database administrators, application developers, and database operators

WEB

Relational database concepts| - describe basic relational database concepts.|Defining an entity relationship model| - define an entity relationship model for a database.|Oracle RDBMS and ORDBMS| - describe the features and characteristics of an Oracle relational database management system (RDBMS) and an Oracle object relational database management system (ORDBMS).|Writing basic SQL statements| - discuss and write basic SELECT SQL statements.|SQL statement features in an Oracle 9i database| - describe SQL statement features in an Oracle9i database.|The Oracle9i database iSQL*Plus environment| - describe the iSQL*Plus environment and how to interact with script files.|Using iSQL*Plus in an Oracle9i database| - use iSQL*Plus in an Oracle9i database to execute SQL statements and interact with script files.|The WHERE clause in Oracle databases| - restrict the data that a SQL statement returns by using a WHERE clause.|The ORDER BY clause in Oracle databases| - sort data returned by SQL statements by using the ORDER BY clause.|Using WHERE and ORDER BY clauses in an Oracle database| - use the WHERE and ORDER BY clauses to restrict and sort query results.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...