HOME
 

Oracle SQL

STL
Course summary
3 days
English
Nationwide
Company-Specific / In-House

Oracle SQL



Courses never cancelled. Last minute rescheduling. 24 month delegate support forum. And more... To provide the skills needed to query and update data held in an Oracle Relational Database.

Suitability - Who should attend?



Any database managers, network administrators, software developers and database administrators that need to use SQL to query and update an Oracle database.

Training Course Content



Session 1: RELATIONAL DATABASE CONCEPTS

Overview of Oracle databases
Relational database structures
Working with Tables, Rows and Columns
Understanding Indexes, Primary Keys and Foreign Keys
Available Data types
The Data Dictionary

Session 2: USING SQL*PLUS

Overview of SQL*Plus
Creating SQL statements
Modifying SQL Statements
Creating, modifying and running SQL Files

Session 3: USING SQL DEVELOPER

Overview of Oracle SQL Developer
Initialising SQL Developer
Configuring connections
Using Navigation Tabs
Understanding a SQL Worksheet
Using the Query Builder

Session 4: RETRIEVING DATA WITH THE SELECT STATEMENT

The SELECT Statement
Using SELECT and FROM clauses
Using Conditions with the WHERE clause
Other Conditional Operators
Logical Operators
The ORDER BY Clause
Aliasing a Column
Using arithmetic expressions
Precedence of Operators

Session 5: AGGREGATE FUNCTIONS

Understanding native aggregate functions
Using the GROUP BY Clause
Using the HAVING Clause

Session 6: JOINING TABLES

Working with Table Joins
Using an Inner Join
Aliasing a Table
Using an Outer Joins
Self Joins
ANSI Standard Joins

Session 7: BASIC SUBQUERIES AND SET OPERATORS

Introduction to Subqueries
Using basic Subqueries
The Set Operators
The Union,Intersect and Minus Operators

Session 8: NUMERIC, CHARACTER AND DATE FUNCTIONS

Types of function
Testing functions
Numeric functions
Character-based functions
Concatenating strings
Date functions

Session 9: CONVERSION AND MISCELLANEOUS FUNCTIONS

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

Session 10: SQL PARAMETERS

Using Command Line Parameters
The Accept Command
The Define Command
The Undefine Command

Session 11: COMPLEX SUBQUERIES

Using subqueries
Working with In-Line Views
Top-N based queries
Subqueries and Joins
Subqueries using multiple columns
Inter-related Subqueries
Subquery Rules
Overview of ANY, ALL and SOME Operators

Session 12: MANAGING DATA

How to insert Rows
How to update Rows
How to delete Rows
Authorising Updates
Transaction Control
Commit and Rollback
Savepoints
Commits and Constraints
Using SQL Developer to amend data

Session 13: MANAGING TABLES

Creating tables
Setting limits
Modifying Tables, Columns and Constraints
Releasing Tables, Columns and Constraints
Recovering Dropped Tables
Cloning Tables

Session 14: MANAGING INDEXES AND VIEWS

Creating Indexes
Dropping Indexes
Listing Indexes
Creating views
Using Views
Dropping Views
Listing Views

Session 15: MANAGING SEQUENCES AND SYNONYMS

Creating sequences
Viewing info of sequences
Creating synonyms
Listing synonyms

Expenses



Prices from £3000 (Guideline pricing). Promotional rates often available the further ahead you book. Contact us for quote.

Provider: STL

STL - Microsoft Training

Best in-class training - Be delighted, not just satisfied

We're here to help - from using Microsoft Excel for informed financial decisions, presentation skills for a winning sales pitch,  to leadership & development programmes. Other services include technical training, Microsoft, Oracle, Cisco, eLearning through to project management, Prince2, ITIL and more....


Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Oracle SQL.

  Contact the provider

  Get more information

  Register your interest

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Contact information for STL

STL

Greater London
STL, 2nd Floor, Cruising Association House
E14 8BT 1 Northey Street

 Show phone number
www.microsofttraining.net

Request information

Find out more about this Oracle SQL course - simply fill out your details:

 
U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's first annual U.K. L&D Report!

UK L&D Report

Learn more

 
Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

 
Find more courses here