Polyglot Institute Sultanate of Oman

Oracle Developer SQL

COURSE

DURATION

Oracle Developer SQL

40 Hours

ENQUIRE

PROGRAMME OVERVIEW

To provide participants with an introduction to the Oracle Database and its concepts.
To teach Structured Query language and working with SQL Plus
To teach the participants how to work with Oracle Forms and Reports to design interactive database application interfaces in a client/server environment.

TARGETED TRAINEES

In this course, you will learn about database and the concept of database, Retrieve row and column data from tables with the SELECT statement. You will also employ SQL functions to generate and retrieve customized data, run data manipulation statements (DML) to update data in the Oracle Database 11g. Control user access and manage schema objects & search data using advanced sub queries.

Developer
Application Developers
PL/SQL Developer
Forms Developer
System Analysts
Business Analysts
Data Warehouse Administrator

PREREQUISITES

Data processing
Familiarity with data processing concepts and technique

COURSE OUTLINES

Relational Database Concepts

What is an Oracle Database
Relational Database Structures
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Supported Data types
The Data Dictionary

Using SQL Developer

What is Oracle SQL Developer
Starting SQL Developer
Configure a Connection
Navigation Tabs & SQL Worksheet

Aggregate Functions

Overview of Built In Aggregate Functions
The GROUP BY Clause
The HAVING Clause

Joining Tables

Overview of Table Joins
Inner Joins, Outer Joins & Self Joins
Table Aliases & ANSI Standard Joins
Set Operators

Using SQL*PLUS

What is SQL*Plus
Getting Started
Entering and Executing SQL Statements
Editing SQL Statements
Creating, Editing and Executing SQL Files

Retrieving Data withthe Select Statement

The SELECT Statement
The SELECT and FROM Clauses
Conditions and the WHERE Clause
Other Conditional Operators
Logical Operators
The ORDER BY Clause
Column Aliases
Arithmetic Expressions
Precedence of Operators

SQL Parameters

Command Line Substitution Parameters
The Accept Command
The Define and Undefined Commands

Numeric, Character and Date Functions

Function Types
Using the Table dual to try out Functions
Numeric Functions
Character Functions
String Concatenation
Date Arithmetic and Date Functions

Conversion and Miscellaneous Functions

Conversion Functions
The NVL and NVL2 Functions
The DECODE Function
CASE Expressions
The COALESCE and NULLIF Functions

Managing Tables

Creating Tables
Specifying Constraints
Altering Tables, Columns and Constraints
Dropping Tables, Columns and Constraints
Copying Tables

Managang Sequences and Synonyms

Create a Sequence
View Sequence Details
Create a Synonym
List Synonyms

Using Sub-queries

Overview of Sub queries
In-Line Views
Top-N Queries
Complex Sub queries
Multi Column Sub queries
Correlated Sub queries
Sub query Rules
Using the ANY, ALL and SOME Operators

Managing Data

Inserting Rows
Updating Rows
Deleting Rows
Verifying Updates
Transaction Control
Commit and Rollback
Save points
Commits and Constraints
Amending Data in SQL Developer

Managing Indexes and Views

Creating Indexes
Dropping Indexes
Listing Indexes
Creating and Using Views
Dropping Views
Listing Views

CERTIFICATION

Certificate from Polyglot Institute approved by MOMP

ENQUIRE

UNIT	LANGUAGE AREA FOCUS	SKILL AREA FOCUS	HOURS
8	Indirect questions & statements Vocabulary: recruitment & personal character	Managing meetings Writing: letters (1)	6
9	Conditionals Vocabulary: international trade	Negotiating (1) Writing: emails (5)	5
10	Gerunds & infinitives Vocabulary: quality control & customer service	Telephoning: dealing with complaints Writing: reports (2)	5
11	Narrative tenses Vocabulary: knowing what is right or wrong	Problem-solving Writing: letters (2)	5
12	Relative clauses Vocabulary: character	Decision-making Writing: emails (6)	5
13	Passives Vocabulary: innovations	Presentation techniques Writing: short articles / Press releases	6
14	Modals: probability Vocabulary: business competition idioms	Negotiating (2) Writing: emails (7)	6
	Assessment		2

UNIT	LANGUAGE AREA FOCUS	SKILL AREA FOCUS	HOURS
1	Present Simple & Present Continuous Vocabulary: brands & products	Taking part in meetings (1) Writing: emails (1)	5
2	Future Tenses Vocabulary: British / American English	Telephoning: making arrangements Writing: emails (2)	5
3	Noun combinations Vocabulary: company structure	Socialising: introductions & networking Writing: reports (1)	5
4	Past Simple & Present Perfect Vocabulary: describing change	Taking part in meetings (2) Writing: minutes	6
5	Describing trends Vocabulary: finance & financial issues	Dealing with figures Writing: emails (3)	6
6	Articles: a, an, the, zero article Vocabulary: advertising	Starting presentations Writing: summarising	5
7	Modals: advice, obligation & necessity Vocabulary: business idioms	Social English Writing: emails (4)	6
	Assessment		2

UNIT	LANGUAGE AREA FOCUS	SKILL AREA FOCUS	OUTCOMES
9	Modals for obligation, necessity & permission	Meetings Controlling the discussion	• talk about sales & advertising • talk about obligation • interrupt & avoid being interrupted • control the discussion in meetings
10	Present Continuous	Presenting Giving a formal presentation	• talk about new green initiatives • talk about innovative practices • ask for clarification • give a formal presentation
11	First conditional	Socialising Invitations & offers	• talk about corporate entertainment • talk about future possibilities • talk about food & drink • make & respond to invitations & offers
12	Present Perfect (2)	Presenting Describing trends	• talk about performance • talk about present & past performance • say large & approximate numbers • describe trends
13	Future predictions	Meetings Predicting	• talk about global issues • make predictions • respond to ideas • predict future trends
14	Second conditional	Exchanging info Negotiating conditions	• talk about managing time • speculate & discuss consequences • talk about time • negotiate conditions
15	Modal verbs for giving advice	Exchanging info Showing understanding & suggesting solutions	• talk about personal development & training • give advice, say thank you & respond • show understanding & suggest solutions
16	Revision of grammar & tenses	Presenting Giving a personal presentation	• talk about ambitions & careers • revise grammar & tenses • say goodbye • give a personal presentation

UNIT	LANGUAGE AREA FOCUS	SKILL AREA FOCUS	OUTCOMES
1	Present Simple	Socialising Introducing yourself and others	• talk about what companies do • make polite requests • introduce yourself & others
2	Present Continuous	Telephoning Making & Receiving telephone calls	• talk about jobs & people you work with • talk about work activities • give phone numbers & spell names • make & receive telephone calls
3	Asking questions	Presenting Visual information	• talk about company structure • welcome visitors • present visual information
4	Past Simple	Meetings Giving a report	• talk about new products & stages in development • show interest • give a report
5	Present Perfect (1)	Meetings Discussing progress	• talk about job benefits & employment procedures • describe personal experiences • delegate work • discuss progress on projects
6	Comparisons	Meetings Asking for & giving opinions	• talk about customer service • make comparisons • respond to complaints • ask for & give opinions
7	Countable & Uncountable nouns	Socialising Making small talk & developing a conversation	• talk about travel • ask for travel information • report to a company reception • make small talk & develop a conversation
8	Future plans, arrangements & decisions	Meetings Making & responding to suggestions	• talk about orders & deliveries • talk about the future • make arrangements • make & respond to suggestions

UNIT	LANGUAGE AREA FOCUS	SKILL AREA FOCUS	OUTCOMES
9	Reported Speech	Exchanging info Placing & Handling Orders	• talk about logistics & supply chains • place & handle orders • leave a voicemail message • report problems or disagreements
10	Nouns & Quantifiers	Meetings Making suggestions & recommendations	• describe your place of work • make suggestions or recommendations • link ideas • talk about work facilities
11	First & Second Conditionals	Meetings Participating in a discussion	• talk about decision-making • participate in a discussion • be persuasive • talk about future possibilities
12	Superlative forms	Presenting Giving a formal presentation	• talk about innovative ideas • give a formal presentation • respond to difficult questions & comments • talk about extremes
13	Advice & Recommendation	Exchanging info Discussing problems	• talk about breakdowns & faults • discuss problems & offer advice • check someone understands • advise & recommend
14	Passive Forms	Socialising Planning future contracts	• talk about processes • make & change future plans • get someone’s attention • describe processes
15	Past Continuous & Past Perfect	Meetings Apprasing performance & setting objectives	• talk about personal qualities • appraise performance & set objectives • give feedback • tell a story • talk about past events
16	Contrasting language	Meetings Reporting back	• talk about achievements • report back on and evaluate research • generalize • use contrasting language

Your User Account

Oracle Developer SQL

COURSE

DURATION

Oracle Developer SQL

40 Hours

PROGRAMME OVERVIEW

TARGETED TRAINEES

PREREQUISITES

COURSE OUTLINES

CERTIFICATION