Oracle 9i Foundations: SQL & SQL *Plus Basics Professional Training Solutions Ltd

Price: TBA

Location: Westland Square Pearse St Dublin 2 Ireland
Duration: 3 Days

Course details

You will receive a hands-on introduction to SQL Basics and SQL *Plus including a basic knowledge of relational databases and how to access them through SQL and SQL *Plus. Basic topics necessary to the use of an Oracle 9i database are covered.

Prerequisites:

An understanding of relational database design concepts.

In the Beginning...Database Management System Overview:

What is a Database?
Types of DBMSs

Introduction to Entity Relationship Modeling:

What is a Data Model?
Why Use an Entity Relationship Model?
Input and Components of an Entity Relationship Model
Reading the Entity Relationship Model
Guidelines for a Model Review

Fundamentals of Relational Database Management Systems:

What is an RDBMS?
History of SQL
Physical Data Storage
Relationships between Tables
Domains - Data Integrity Constraint

SQL Basics and SQL *Plus:

Understanding the Difference Between SQL, SQL *Plus and PL/SQL
Invoking and Leaving SQL *Plus
Entering and Executing Commands
The SQL Buffer, SQL *Plus Default Output
LOGIN.SQL
The SELECT Command & Mandatory Clauses

Using iSQL Plus:

Understanding the iSQL *Plus Environment and Commands

The WHERE and ORDER BY Clause:

WHERE, ORDER BY Clause
Using the Data Dictionary

Single Row Functions:

Functions, Date and Numeric Format Models/Data Conversion
Control Statements

Joining Data from Multiple Tables in Queries:

The JOIN Condition / The Cartesian Product
Outer JOINs
SET Operators
ANSI SQL99 Join Syntax

Group Functions and the GROUP BY Clause:

Group Functions
Distinct Operator in Group Functions
GROUP BY, WITH Clause, ROLLUP, CUBE
GROUPING SETS

Using Subqueries and CASE Clauses:

Single-Row, Multi-Row, Multi-Column Subqueries
Subqueries in a WHERE Clause, the FROM Clause - In-Line Views, and in the SELECT Clause - Scalar Subqueries
Correlated Subqueries
CASE Clause

Analytic Functions (Optional):

Single Row Analytic Functions
Aggregating Analytic Functions

SQL *Plus Reporting:

SQL *Plus Report Writing Commands
COLUMN Command / Titles, System Variables
Master-Detail Report with TITLE and COLUMN Commands
Control Breaks, Computing Aggregate Amounts
Using SET, Variables in SQL *Plus, SQL to Generate SQL

Data Manipulation Language (DML) Commands:

INSERT, UPDATE, DELETE, MERGE Command
Use of Subqueries
Transaction Control / Read Consistency / Locking

Getting Data In and Out of Oracle:

SQL *Loader Basics
Importing Into Excel
Direct Database Queries Using ODBC

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 Ireland

Are you from Professional Training Solutions Ltd ? Claim your course!

Courses you can instantly connect with... Do an online course on SQL Server starting now.