Oracle Database Querying Advanced

This course is aimed at Oracle database developers, administrators and analysts who need to take the basics of Oracle SQL Data Manipulation Language (DML) statements to the next level. The aim of the course is to show the more advanced use of SELECT, UPDATE and DELETE statements providing delegates with the necessary knowledge and hands on experience to construct complex queries to satisfy complex information extraction requirements. The course focuses on real world business needs and shows how to make the extensive Oracle library of functions work together to manipulate and extract data values. It also explores the many different ways of retrieving information from multiple tables from simple multi-table SELECT statements through to complex correlated sub-queries as well as introducing the many ways of analysing and processing data through methods such as grouping of data and implementing computed columns. The course will do more than just teach each topic as an isolated subject; it will show delegates how to integrate all these query methods and more to help satisfy their business information extraction needs. The course is appropriate to users of Oracle 9i, Oracle 10g and Oracle 11g.

Introduction

Multiple Table Selects

Temporary Tables

Views

Advanced Data Organisation

Sub Queries

Advanced Update and Delete Statements

Merging Records

Common Table Expressions

Simple Execution Plans

Dates

London Greenwich

Monday 31 to Tuesday 01 August 2017

£695

Book Now

London Greenwich

Tuesday 29 to Wednesday 30 August 2017

£695

Book Now

London Greenwich

Monday 06 to Tuesday 07 November 2017

£695

Book Now


Collections

Database courses

Programming courses