Latest Post

Recursive Queries with TeamSQL

In many relational database models, we have recursive data structures; it’s true that the relational data model is not oriented to support recursive data structures, and is also true that SQL, (as a query language) doesn’t have a healthy way to manage this recursive structures. However, every database engine has a particular clause to maintain the ...

Most Popular

THE SEVEN TYPES OF SQL JOINS

It’s unlikely that you’ll be working exclusively with data from one table, so you’ll need to be able to grab data from multiple tables. One of the ways to do this is by using joins, and in relational databases, joins are what make relational databases relational. This post provides a quick refresher of the four main types of SQL Joins and three of ...

Posts by Categories

Categories