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

After a short introduction on data warehousing (DW), 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 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.

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

Schedule

datedur.lang.  location  price
22 Mar2?Leuven  (BE)950 EUR  (excl. VAT) 
25 Apr2NWoerden  (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 or Hadoop (Hive) 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) or Big Data concepts (see e.g. Big data concepts) 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 or Hive. (Please indicate your choice on the enrolment form.)

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, veel geleerd. (, )
     
Goede uitleg en duidelijk verhaal. Goede nieuwe inzichten gekregen (, )
     
omdat ik persoonlijk wat minder goed de basis beheers, vond ik het bijtijden bijzonder pittig (, )
     
Goede cursus, veel theorie, misschien iets meer met praktijk voorbeelden en dan bedoel ik ook visueel tonen van uitkomst, niet alleen de query (, )
     
Goed, gedreven trainer die veel onderwerpen aankaart (, )
     
Le cours s'est bien passé en general (, )
     
Heel goed (, )
     
Prima! (, )
     
Uitstekend. Goed. (, )

Refresh this page to see other comments.

Also interesting

Enrollees for this training also took the following courses:


SESSION INFO AND ENROLMENT