home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral courses » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » Linux - UNIX » Mac OS X » iPad and iPhone iOSDatabases and middleware » Relational databases & SQL » Db2 for z/OS » Db2 for LUW » Oracle » SQL Server » MySQL & MariaDB » IMS » CICS » IBM MQ » WebSphere » Data Science, Big Data and AnalyticsApplication development » Methods and techniques » TOGAF » PRINCE2 » Agile development and Scrum » Programming languages » Internet development » Object Oriented systems » Java » Development tools » SAS » XML » SOA & web servicesSystems management » ITIL » SecuritybalkjePractical informationRegistration 
SQL for BI reporting and analysis

After a short introduction on data warehousing (DW) and business intelligence (BI) topics, we dive into a thorough discussion on the possibilities offered by SQL. More specifically, statistical, analytical and OLAP functions will be treated, as well as the use of SQL for ETL. The most important ones are individually discussed and demonstrated; realistic labs should allow the participant to get an idea of the applicability of these SQL functions and options.

The SQL syntax covered in this course is platform independent. When relevant, platform specific exceptions will be pointed-out with respect to Oracle, Db2, and SQL Server.

At the end of this training, participants will be able to:

Schedule

datedur.lang.  location  price
15 Nov2?Leuven  (BE)950 EUR  (excl. VAT) 
18 Dec2EWoerden  (NL)950 EUR  (exempt from VAT) 
SESSION INFO AND ENROLMENT

Intended for

This course targets everyone involved in the development of business reports, by means of SQL statements on relational database systems.

Background

In order to have the full benefit of this course, it is important to be really proficient with SQL (level SQL workshop and being familiar with complex queries; having followed the SQL advanced course is also an advantage). Furthermore you need a basic understanding of data warehousing concepts (see e.g. Data warehouse concepts) and be aware of some elementary statistical terminology (see e.g. Statistics fundamentals).

Main topics

Training method

Class training alternated with exercises.

Duration

2 days.

Course leader

Peter Vanroose, Kris Van Thillo.

Global score

   
4.2/5 (based on 30 evaluations)

Reviews

     
goede verdieping op onderwerp SQL (, )
     
Prima! (, )
     
Goed, gedreven trainer die veel onderwerpen aankaart (, )
     
Heel goed (, )
     
Goede cursus, veel theorie, misschien iets meer met praktijk voorbeelden en dan bedoel ik ook visueel tonen van uitkomst, niet alleen de query (, )
     
met enthousiasme gegeven (, )
     
Prima, veel geleerd. (, )
     
Goede uitleg en duidelijk verhaal. Goede nieuwe inzichten gekregen (, )
     
Uitstekend. Goed. (, )
     
Zeer enthousiast. (, )

Refresh this page to see other comments.


SESSION INFO AND ENROLMENT