About ABIS
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 and Data Science

After a short introduction on data warehouses (DW), data lakes, business intelligence (BI) and Data Science 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, for data exploration, and for MapReduce. 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, SQL Server and Hive/Spark.

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


datedur.lang.  location  price
28 May2NWoerden  (NL)950 EUR  (exempt from VAT) 

Intended for

This course targets everyone involved in the development of business reports, by means of SQL statements on relational database systems or Hadoop (Hive) or Spark SQL.


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 an advantage). Furthermore it's helpful to have a basic understanding of data warehouses (see e.g. our course Modern data warehousing and business intelligence) or Big Data (see e.g. Big data architecture and infrastructure) and be aware of some elementary statistical terminology (see e.g. Statistics fundamentals).

Main topics

Training method

Class training alternated with exercises. These can be done on Db2, Oracle, SQL Server, Hive, or Spark. (Please indicate your choice on the enrolment form.)


2 days.

Course leader

Peter Vanroose, Arnout Veugelen.

Global score

4.2/5 (based on 30 evaluations)


goede verdieping op onderwerp SQL (, )
goed cursus met fijne afwisseling tussen theorie en praktijk (, )
Zeer enthousiast. (, )
Prima, veel geleerd. (, )
omdat ik persoonlijk wat minder goed de basis beheers, vond ik het bijtijden bijzonder pittig (, )
Prima! (, )
Goede cursus; voldoende hoog niveau, met gelegenheid tot even "ophalen" van kennis. Analyse-onderdeel bleek een beetje onderbelicht, maar dat heeft mogelijk te maken met de geschiktheid van SQL hiervoor. (, )
Uitstekend, zeer goede voorbeelden (, )
Goede uitleg en duidelijk verhaal. Goede nieuwe inzichten gekregen (, )
Le cours s'est bien passé en general (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses: