EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Oracle SQL Introduction Training Course

NEXT COURSE
26 Feb London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Oracle SQL Introduction training course (code: ORACSQL)

Rapidly Gain Oracle SQL Skills - Learn To Interrogate and Retrieve Useful Corporate Data


SEE MORE COURSES IN THIS CATEGORY

TRAINING COURSE OVERVIEW

The JBI Oracle SQL training course provides a thorough introduction to SQL language coding.  Basic features are covered in detail, and then the course moves on to more advanced topics such as wide selection of scalar and group functions, group by, SQL Joins (including ANSI standard join syntax) and correct use of union, intersect and minus. The course finishes with introducing main-line approaches to using DML (insert, update and delete) plus a simple review of basic DDL (creating tables, indexes, plus use of primary keys and foreign keys. Delegates are encouraged to work with the lecturer in class, trying smaller demo techniques, and then going on to more interesting coding challenges in a set of exercises. Often skeleton code is available, so code adaption is possible (thus mimicking common coding practice).

AUDIENCE

The course is suitable for any personnel involved in the maintenance of Oracle applications and databases and for users with some technical knowledge who wish to extend that knowledge and for end users who wish to construct their own reports. The course is a pre-requisite for the Database Administration and PL/SQL Courses. The skills learnt on this course can be applied to any Oracle Database version including 8i, 9i, 10g and 11g.



DETAILHIGHLIGHTS

Introduction to SQL.

What is SQL and what is it used for?

Data Dictionary

Using the Data Dictionary

The SELECT Statement

Mandatory Clauses
The WHERE Clause 
The ORDER BY Clause

Substitution Variables

Lexical and Bind variables

Functions

Numeric, Character, and Miscellaneous Functions 
Group Functions SUM, AVG, COUNT, STDDEV
Rollup, Cube 
GROUP BY and HAVING Clauses

Sub-queries

Queries within Queries
Basic Sub Queries 
Complex Sub Queries 
EXISTS and NOT EXISTS Clauses

Joining Tables

Cartesian Products 
Standard Table Joins 
Self Referencing Table Joins 
Inner and Outer Joins

Report Formatting

Page Settings 
Page Titles 
Page Numbering

Views

Creating Views 
Restricting Data Access with Views 
Simplifying Database Design

Users, Privileges and Synonyms, Security

Changing your password 
Allowing Other Users Access to Your Tables

Data Manipulation

Inserting Data Into Tables 
Updating Data 
Deleting Data

Table Locking

Commit and Rollback 
Table and Row Level Locking 
Assigning your own Locking Level

Nested functions

Advanced SQL*Plus Techniques

Generating SQL from SQL 
Spooling Output 
Copying Tables

SQL*Plus Performance Tuning, using Explain Plan

Basic Performance Tuning 
Performance Information using Explain Plan Utility

  • Create and maintain Oracle tables.
  • Insert, update, delete data from Oracle tables.
  • Produce complex queries.
  • Format queries in to Reports.
Receive the latest version of this course into your inbox


See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Blog (Show All)

JBI training course London UK

Application Security training courses | 4 Reasons to gain secure coding skills

03/10/2017: Traditionally Cyber security has been associated mainly with penetrating networks and infrastructure. Now a more subtle level of attack needs...


JBI training course London UK

Angular training courses | 7 Reasons to Learn Angular

05/10/2017: Back in March 2014, the Angular team dropped a bomb by announcing Angular 2 and everyone started yelling. Instead of an evolutionary step forward,...


JBI training course London UK

MVC Training : MVC is now in ASP.NET Core 1.0

05/10/2017: MVC The Model View Controller (MVC) architectural pattern has a long history (together with its variants) and has been used in many languages...


Case Studies (Show All)

JBI training course London UK

Grad Programme ensures new intake is productive

12/10/2017: The Graduate Programme provided a gateway into technology within investment banking. Graduates (Computer Science, Engineering, Maths, Physics...


JBI training course London UK

Power BI allows corporate data manipulation & visualization

13/10/2017: This organisation needed their Supply Chain department to get fully involved with Microsoft’s Power BI reporting product as soon as possible....


JBI training course London UK

Increasing Mobile App Development resource

07/10/2017: This client had previously utilised third parties to develop and deliver its customer facing products and services. A strategy change required...


Call our Tech Team :  0800 028 6400  request info

 

PUBLIC COURSES (LONDON, UK)
 

26th Feb 2018 - 3 days £1495
Book

see all dates


X

Show Discount for this course


PRIVATE COURSES


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote


  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote


CERTIFICATE

Our course is exhaustive and the certificate rewarded by us is proof that you have taken a big leap in this subject area.
 


 

Get in touch
0800 028 6400





Our inspiring and up-to-date courses gain exceptional feedback

►"great tips help reduce build times"
► "we got access to exclusive content"
► "Short course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

Newsletter ! Get exclusive news about upcoming programs, technical insights & special offers