+ Basic to intermediate level

This course will give those with basic Oracle SQL skills the advanced SQL skills necessary to design and code complex queries against Oracle databases to generate the REPORTS that management really wants. You will learn to use many advanced SQL coding techniques such as coding analytic functions for business intelligence reporting and decision support queries, using partition outer join to "densify" data, the Oracle12 MODEL clause ("spreadsheet-like capability directly from the database"), Oracle12 regular expressions for pattern matching, using the extended aggregate functions CUBE and ROLLUP, coding SET operations such as INTERSECT, using subqueries to increase SQL performance and more


Financial, Operational, and External Auditors; Information System Auditors and Audit Management; Data analysts and Financial Control personnel; Prospective ACL users.


3-Saturdays training course in an online or on-site style setting


Ghana Address

No. 9 Samora Machel Road Asylum
Down, Accra – Ghana
Tel: +233 (0) 30 223 1305

Lagos Address

39A Sura Mogaji Street, Off Coker Road, Ilupeju, Lagos, Nigeria
Tel: +234 (0) 909008496

Abuja Address

Plot 624, James Agwu Onoja Street,
Block 1, Flat 2, Wuye District, Abuja.
Tel: 08179444443, 08038553466

Contact Us: