Training >> Courses >> Introduction to Oracle 9i

Introduction to Oracle 9i - RDBMS, SQL & SQL*PLUS

Course Description

This course offers students an extensive introduction to data server technology.  The class covers the concepts of both relational and object relational databases and the powerful SQL programming language.  Students are taught to create and maintain database objects and to store retrieve, and manipulate data.  Students learn to retrieve data by using advanced techniques such as set operators, and hierarchical retrieval.  They also learn to write SQL and SQL*PLUS script files using the iSQL*PLUS tool to generate report like output.  Demonstrations and hands-on practice in each session.

Course Objectives:

·	Learn to write SQL and SQL*PLUS script files.
·	Learn to retrieve data.

Course Contents:

·	Overview of Relational Databases
·	Writing Basic SQL Statements
·	Displaying Data from Multiple Tables
·	Sub Queries
·	Manipulating Data
·	Creating Views
·	Restricting and Sorting Data
·	Single Row Functions
·	Aggregating Data Using Group Functions
·	Fundamentals of SQL*PLUS
·	Oracle Data Dictionary
·	Database Objects
·	Controlling User Access
·	Sub-Queries security model

Find out more about Amfasoft’s education offerings