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


Oracle SQL Introduction Training Course


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

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

31st Jul 2017 - 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


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

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

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive 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