Birgitta Hauser

Independent Database and Software Architect

SQL Queries – Do you know you can do this with SQL? 

Today SQL is not only used for ad-hoc queries, but replaces more and more native. Moving business logic into data base and reducing the source code is one of the main goals when we talk about application modernization. The first step for realizing this goal is the ultimate use of the SQL SELECT statement which may be much more powerful than you may imagine. Currently SQL provides around 180 scalar functions and 30 aggregate functions. Besides various ways of joining tables or views, data from multiple tables can be merged. All kinds of sub- and grand totals and even rolling totals can be built. Recursive Data can be analysed … In this workshop you will learn multiple ways for solving your requirements by using a “simple” SQL Select Statement