Course Objectives

·         RELATIONAL DATABASES & SQL

·         USING SQL*PLUS

·         BUILDING A SELECT STATEMENT

·         BUILDING A WHERE CLAUSE

·         ORDERING THE RESULT TABLE

·         PSEUDO COLUMNS & FUNCTIONS

·         JOINING TABLES

·         USING SET OPERATORS

·         SUMMARY FUNCTIONS

·         USING SUBQUERIES

·         USING SUBQUERIES

·         SQL*PLUS COMMANDS

·         BUILD SIMPLE SQL*PLUS REPORTS

·         SQL DATA DEFINITION LANGUAGE

·         SQL DATA MANIPULATION LANGUAGE

Course Benefits

This course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are:

• Application designers and developers.
• Database administrators.
• Business users and non-technical end users.

Course Duration

40 hours