Introduction to Oracle 9i SQL

Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 3 Days
Call: +971 4 4542450

Course details

This course is a common starting point in the Oracle database curriculum for administrators, developers and business users. The objective of this course is to provide an introduction to the SQL database language within the context of an Oracle database.

RELATIONAL DATABASES & SQL::

About Relational Databases
Elements of SQL

USING SQL*PLUS::

About SQL *Plus
Using the MS Windows SQL *Plus Tool
Using the ISQL *Plus Tool
Entering Commands and Syntax

BUILDING A SELECT STATEMENT::

About the Select Statement
Selecting Columns
Using Alias Names

BUILDING A WHERE CLAUSE::

About Logical Operators
Equality Operator
Boolean Operator
Null & Between Operators
Finding Text Strings
In Operator

ORDERING THE RESULT TABLE::

About the Order by clause
Multiple Column Sorts
Specifying the sort sequence
About Null Values within Sorts
Using Column Aliases

PSEUDO COLUMNS & FUNCTIONS::

About Pseudo Colums & Functios
Using ROWID
Using ROWNUM
Using the functios
Using the Dual Table
Session Timezone Function

JOINING TABLES::

About Joins
Inner Joins
Reflexive Join
Non Key Join
Outer Join

USING SET OPERATORS::

About the Set Operators
Set Operator Examples

SUMMARY FUNCTIONS::

About Summary Functions
Summary Function with Distinct

USING SUBQUERIES::

About Subqueries
Standard Subqueries
Correlated Subqueries

CREATING & SELECTING GROUPS::

About Summary Groups
Finding groups with the base tables
Selecting data from the base tables
Selecting groups from the result table

SQL*PLUS COMMANDS::

About SQL *Plus Commands
More about Script Files
Invoking Operating System Commands
Saving Session Output

BUILD SIMPLE SQL*PLUS REPORTS::

About the SQL *Plus report Features
Session Output with set
Format column output with Column
Defining Reort Beaks with Break
Produce Subtotals with Commute

SQL DATA DEFINITION LANGUAGE::

About SQL DDL
Create Table Statement
Alter Table Statement
Drop Table Statement
Supportive Statements

SQL DATA MANIPULATION LANGUAGE::

About SQL DML
About the Insert Statement
About the Delete Statement
About the Update Statement
About Transactions
Truncate Table
Complex Table References

Updated on 08 November, 2015

Course Location

Show map Location Westland Square Pearse St Dublin 2 Ireland

About Professional Training Solutions Ltd

Professional Training is a group of experienced specialists providing specific training and consultancy solutions, within Management Skills, I.T. systems, Human Restheirce Development, Credit Management, Sales, Finance and Engineering.

they believe in using a combination of tailored, flexible approaches and real-life business knowledge to develop and provide techniques and solutions for immediate implementation.

their recent projects include supporting major initiatives for clients in utilities, telecoms, manufacturing and software, covering:

restructuring for competitiveness

productivity improvements through updating work processes to match new technology

managing outstheircing

strategic financial planning and engineering

their methodology is to:

Work closely with clients to understand and help them prioritise their needs

Design and deliver the best mix of training activities and consultancy to establish the competencies required

Provide ongoing coaching to sustain the improved practices and processes

they create relevant, targeted, enjoyable, and interactive, training sessions which are designed to improve the retention of information by participants and create a clear link from the training to the workplace. This creates a planned, visible improvement in key business indicators such as productivity, motivation, loyalty, employee retention, and ultimately, profit.

their collaborative approach builds long-term relationships with clients. Together, they can deal effectively with the inevitable challenges all businesses face.

See all Professional Training Solutions Ltd courses

View more Virtual classroom training for Oracle online courses See all Oracle Courses

See all current SQL Server and Oracle jobs in UAE