Category Archives: Databases
Why would you use Common Table Expressions?
Introduction In this article I suppose that you have a good understanding of SQL already. I will introduce some concepts very briefly before moving on to Common Table Expressions. Below you can find the relevant database diagram of the database … Continue reading
What is the role of the database?
Introduction Most non-trivial applications will use a database to store data. This database can be relational or not, but some data store will be needed. Most modern database management systems (DBMS) can do much more than just storing data, and … Continue reading
Database Normalization
Introduction After I published last week’s article somebody asked me why I stated that (in this case) the problem didn’t originate in having a function with logic, but merely having to work with a database that is not normalized. So let’s talk … Continue reading
MSDev.pro blog 