I am

STEFAN
ARDELEANU

I am a database specialist. I am Romanian and I live in
Luxembourg for some years. I have two degrees, Math and
Philosophy. Most important, I am doing database development
for roughly 20 years.

My short history. In my first years, I was a Math teacher.
During this period, apart from teaching, I tried others things
like being a journalist, for example. I like to write! After my
30's, I started IT, I started a career in software development.
I felt in love with databases from the very beginning. My first
contact was with SQL Server, in the early 2000.

I quickly decided to focus on databases programming and I
did SQL development almost continuously from there
onwards. I had the chance to change projects and to work in
SQL Server, Oracle, later in DB2 and PostgreSQL. I developed
in classic, transactional OLTP systems as well as in data
warehouse, ETL systems.

I had been involved in data migration projects ( data as well
as metadata). I am also a database trainer, delivering in the
past database development courses in Oracle chain.

I am a published author. I wrote a book: relational database
programming: a set oriented approach, in Apress. The main
idea of the book is to show that, very often, the same
problem can be solved in many ways, and these ways are
mainly caused by the style of development.

This can be atomic, specific to application developers, or
holistic, specific to SQL developers. I showed many situations
in which the same data manipulation process can be
handled in two ways, and the difference is made in the style
of programming. I continue to see every day how the style of
development dramatically affects the performance.

I also have a book in Romania, Transact SQL. This site is
somehow a continuation of my activity. One of the main
topics on my site is related to this dualism between the two
opposite styles of development in a relational database.
However, is not the only one.

Social Media

I am

STEFAN
ARDELEANU

I am a database specialist. I am Romanian and I live in
Luxembourg for some years. I have two degrees, Math and
Philosophy. Most important, I am doing database development
for roughly 20 years.

Social media

 

My short history. In my first years, I was a Math teacher. During this period, apart from teaching, I tried others things like being a journalist, for example. I like to write! After my 30’s, I started IT, I started a career in software development. I felt in love with databases from the very beginning. My first contact was with SQL Server, in the early 2000.

I quickly decided to focus on databases programming and I did SQL development almost continuously from there onwards. I had the chance to change projects and to work in SQL Server, Oracle, later in DB2 and PostgreSQL. I developed in classic, transactional OLTP systems as well as in data warehouse, ETL systems.

I had been involved in data migration projects ( data as well as metadata). I am also a database trainer, delivering in the past database development courses in Oracle chain.

I am a published author. I wrote a book: relational database programming: a set oriented approach, in Apress. The main idea of the book is to show that, very often, the same problem can be solved in many ways, and these ways are mainly caused by the style of development.

This can be atomic, specific to application developers, or holistic, specific to SQL developers. I showed many situations in which the same data manipulation process can be handled in two ways, and the difference is made in the style of programming. I continue to see every day how the style of development dramatically affects the performance.

I also have a book in Romania, Transact SQL. This site is somehow a continuation of my activity. One of the main topics on my site is related to this dualism between the two opposite styles of development in a relational database. However, is not the only one.

Relational
Database
Programming

A Set Oriented Approach

Database performance through
set based development practices

by Stefan Ardeleanu

BUY BOOK ON AMAZON

Relational Database Programming

A Set Oriented Approach

Database performance through
set based development practices

Where do we simply practice SQL?

I will mainly cover SQL exercises from Oracle and SQL Server, but also from
PostgreSQL and MySQL and even some NoSQL.