-:program Outline

· RELATIONAL DATABASES & DATA MODELS · SELECTION & SETUP OF THE DATABASE INTERFACE · USING THE DATABASE INTERFACE · INTRODUCTION TO THE SQL LANGUAGE · THE SELECT STATEMENT · RESTRICTING RESULTS WITH THE WHERE CLAUSE · PSEUDO COLUMNS, FUNCTIONS & TOP-N QUERIES · JOINING TABLES · USING THE SET OPERATORS · SUMMARY FUNCTIONS · AGGREGATING DATA WITHIN GROUPS · USE DDL TO CREATE & MANAGE TABLES · USE DML TO MANIPULATE DATA · UNDERSTANDING THE DATA MODELS

Target Audience :-

The target audience for this course is all Oracle professionals, both business and systems professionals. Among the specific groups for whom this course will be helpful are: • Business and non-IT professionals • Application designers and database developers • Business Intelligence (BI) analysts and consumers • Database administrators • Web server administrators