home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
C
All CoursesbalkjeGeneral » Introduction to HW & SW » Soft skills » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » 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 » 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 advanced course

Objectives

Applications are becoming more demanding than before in their use of relational database systems like DB2, Oracle, SQL Server, PostgreSQL, ... Also the SQL used by data warehouse BI tools (e.g. Business Objects) and ERP solutions (e.g. SAP, Siebel) is becoming more advanced.

Questions that arise in this context are:

  • How will we cope with these - often dynamic - SQL statements?
  • How to write SQL queries which are as readable and as maintainable as possible?
  • Can we take advantage of relatively new standard SQL features, which could provide interesting possibilities?
  • Learn using unknown SQL-syntactic features that can simplify existing SQL code, or make it more readable and more efficient.

Do you accept the challenge? By using very concrete SQL examples and exercises, we show that the possibilities and the impact of the extended SQL tool set may have an important positive impact.

Main topics

  • Overview of the reference material for the SQL standard and of the different RDBMS platforms
  • Nested Selects, Common Table Expressions ("WITH" clause), and correlated references in a nested select
  • Clever ways to combine inner and outer joins
  • Time travel queries
  • Where clause: predicates, regular expressions, and some unexpected side effects of NULL values
  • A first encounter with OLAP functions (for a.o. ranking and aggregation)
  • Possible applications of the Order By and Fetch First clauses; pagination
  • Select from Insert, Update, Delete
  • Update and Delete with correlated subqueries
  • The Merge statement
  • Recursive SQL
 

Intended for

This presentation is intended for users and developers of RDBMS systems like e.g. Oracle, DB2, SQL Server, MySQL, MariaDB, PostgreSQL, ...

Background

A good knowledge of SQL is required (see SQL workshop) and also active experience with one of the major RDBMS systems (see e.g. DB2 for LUW fundamentals course, DB2 for z/OS fundamentals course, Oracle fundamentals course). You can test for yourself to see if you have enough background by printing and filling out the self-test (PDF file - 56 KB).

Training method

Using several examples and giving lots of exercises, you will be guided step by step through this material.

Course leader

Peter Vanroose.

Duration

1 day.

Schedule

You can enrol by clicking on a date
datedur.lang.  location  price
17 Nov1ELeuven  (BE)500 EUR  (excl. VAT) 
20 Dec1NWoerden  (NL)500 EUR  (exempt from VAT) 

Global score

   
4.0/5 (based on 190 evaluations)

Reviews

     
Goede inhoud, beter spreiden over 2 dagen (, )
     
Goede opbouw en verderzetting van de onderwerpen. Duidelijk uitgelegd. (, )
     
goed, te weinig tijd (, )
     
Prima, zet de laatste puntjes op de I. (, )
     
Alles goed uitgelegd binnen de beschikbare tijd, met genoeg voorbeelden/oefeningen. (, )
     
Te veel stof in te korte tijd. Het is nu meer een overview. Wel een heel nuttige overview overigens! (, )
     
Goed, uitleg tijdens de oefeningen vond ik zeer nuttig. (, )
     
Goed. Er wordt veel praktijk situaties gegeven en de stof is volledig, bepaalde zkaen die minder relevant zijn wordt kort besproken (, )
     
Goed tempo hoog (, )
     
veel inhoud, tempo van presentatie lag erg hoog. (, )

Refresh this page to see other comments.