Oracle SQL Intermediate - Data Extraction Training Course

Course Code

osqlide

Duration

14 hours (usually 2 days including breaks)

Requirements

Recommended attendance on the "Oracle SQL for Beginners" training course

Overview

The objective of the course is to enable participants to gain a mastery of how to work with the SQL language in Oracle database for data extraction at intermediate level.

Course Outline

Limiting results

  • The WHERE clause
  • Comparison operators
  • LIKE Condition
  • Prerequisite BETWEEN ... AND
  • IS NULL condition
  • Condition IN
  • Boolean operators AND, OR and NOT
  • Many of the conditions in the WHERE clause
  • The order of the operators.
  • DISTINCT clause

SQL functions

  • The differences between the functions of one and multilines
  • Features text, numeric, date,
  • Explicit and implicit conversion
  • Conversion functions
  • Nesting functions
  • Viewing the performance of the functions - dual table
  • Getting the current date function SYSDATE
  • Handling of NULL values

Aggregating data using the grouping function

  • Grouping functions
  • How grouping functions treat NULL values
  • Create groups of data - the GROUP BY clause
  • Grouping multiple columns
  • Limiting the function result grouping - the HAVING clause

Subqueries

  • Place subqueries in the SELECT command
  • Subqueries single and multi-lineage
  • Operators Subqueries single-line
  • Features grouping in subquery
  • Operators Subqueries multi-IN, ALL, ANY
  • How NULL values ​​are treated in subqueries

Operators collective

  • UNION operator
  • UNION ALL operator
  • INTERSECT operator
  • MINUS operator

Further Usage Of Joins

  • Revisit Joins
  • Combining Inner and Outer Joins
  • Partitioned Outer Joins
  • Hierarchical Queries

Further Usage Of Sub-Queries

  • Revisit sub-queries
  • Use of sub-queries as virtual tables/inline views and columns
  • Use of the WITH construction
  • Combining sub-queries and joins

Analytics functions

  • OVER clause
  • Partition Clause
  • Windowing Clause
  • Rank, Lead, Lag, First, Last functions

Retrieving data from multiple tables (if time at end)

  • Types of connectors
  • The use NATURAL JOIN
  • Aliases tables
  • Joins in the WHERE clause
  • INNER JOIN Inner join
  • External Merge LEFT, RIGHT, FULL OUTER JOIN
  • Cartesian product

Aggregate Functions (if time at end)

  • Revisit Group By function and Having clause
  • Group and Rollup
  • Group and Cube

Testimonials

★★★★★
★★★★★

Bookings, Prices and Enquiries

Guaranteed to run even with a single delegate!

Private Classroom

From £2500

Private Remote

From £2200 (98)

Public Classroom

Location Date Course Price [Remote/Classroom]
Portsmouth Technopole2018-10-30 09:30£ 2200 / £ 2500
Birmingham 2018-10-31 09:30£ 2200 / £ 2850
Belfast City Centre2018-11-05 09:30£ 2200 / £ 3100
Bristol, Temple Gate2018-11-05 09:30£ 2200 / £ 2700
Aberdeen - Berry Street2018-11-07 09:30£ 2200 / £ 2860
Cardiff2018-11-07 09:30£ 2200 / £ 2800
Brighton2018-11-08 09:30£ 2200 / £ 2600
Leicester - St. Georges House2018-11-14 09:30£ 2200 / £ 2700
Oxford2018-11-14 09:30£ 2200 / £ 2750
Manchester, King Street2018-11-15 09:30£ 2200 / £ 2850
Newcastle2018-11-15 09:30£ 2200 / £ 2600
Swindon2018-11-21 09:30£ 2200 / £ 2550
York - Priory Street Centre 2018-11-22 09:30£ 2200 / £ 2500
Southampton2018-12-03 09:30£ 2200 / £ 2700
St Helier, Jersey, Channel Isles2018-12-03 09:30£ 2200 / £ 3150
Cambridge2018-12-05 09:30£ 2200 / £ 2650
Exeter - The Senate2018-12-05 09:30£ 2200 / £ 2800
London, Hatton Garden2018-12-06 09:30£ 2200 / £ 2950
Reading TVP2018-12-11 09:30£ 2200 / £ 2730
Glasgow2018-12-11 09:30£ 2200 / £ 2900
Cannot find a suitable date? Choose Your Course Date >>Too expensive? Suggest your price

Course Discounts

Course Venue Course Date Course Price [Remote / Classroom]
Jenkins: Continuous Integration for Agile Development Manchester, King Street Thu, 2018-10-18 09:30 £2574 / £3224
Introduction to Recommendation Systems Swansea- Princess House Thu, 2018-10-18 09:30 £990 / £1140
Advanced Statistics using SPSS Predictive Analytics Software Birmingham Mon, 2018-10-22 09:30 £5148 / £6448
Building Augmented Reality Applications with Vuforia and Unity Glasgow Wed, 2018-10-24 09:30 £2178 / £2878
Impact Evaluation – Quantitative Analysis London, Hatton Garden Wed, 2018-10-24 09:30 £2574 / £3324
Statistics with SPSS Predictive Analytics Software Cambridge Thu, 2018-11-01 09:30 £2574 / £3024
Programming in Scala Cambridge Thu, 2018-11-01 09:30 £2178 / £2628
CakePHP: Rapid Web Application Development Birmingham Tue, 2018-11-06 09:30 £4356 / £5656
AWS: A Hands-on Introduction to Cloud Computing Brighton Wed, 2018-11-07 09:30 £1287 / £1487
JMeter Fundamentals and JMeter Advanced Edinburgh Training and Conference Venue Mon, 2018-12-03 09:30 £2178 / £2578
HAProxy Administration London, Hatton Garden Mon, 2018-12-03 09:30 £2178 / £2928
Social Media Marketing Oxford Wed, 2018-12-12 09:30 N/A / £1364
Test Automation with Selenium Manchester, King Street Wed, 2018-12-12 09:30 £3267 / £4242

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in your region!

As a Business Development Manager you will:

  • expand business in the region
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

contact us right away!