big-data infrastructure coding-sql
Creating a Big Data cluster with SQL Server 2019

SQL Server 2019 came out in preview a while ago, and the new features announced are just wonderful! A one-to-go-tool for all your big data…

Xavier Geerinck

coding coding-sql
SQL - Part 5 - Common Table Expressions

CTE’s (Common Table Expressions) are mostly used when creating recursive queries, creating temporary views (instead of subqueries…

Xavier Geerinck

coding coding-sql
SQL - Part 4 - JOIN + Simulating Functions

When creating JOIN queries in SQL we have to realize that we are going to combine every result from the result set with the result set…

Xavier Geerinck

coding coding-sql
SQL - Part 3 - Analytical Functions (Ranking, Rows, Over, ...)

Analytical Functions Analytical functions are brought into existence to solve the problems that we have with Aggregate functions. The…

Xavier Geerinck

coding coding-sql
SQL - Part 2 - Aggregate Functions (GROUP BY, CUBE, ROLLUP, ...)

Aggregate Functions Aggregate functions are functions that are going to aggregate data from columns, or rows. Some of these functions are…

Xavier Geerinck

coding coding-sql
SQL - Part 1 - Advanced CASE Selecting

While I was studying the course Databases at the University of Ghent, we encountered some special queries that we were not being thaught in…

Xavier Geerinck

Xavier Geerinck © 2020

Twitter - LinkedIn