SQL Joins – Part 2: Performance Tips and Tricks & Benchmark

This is the second article from SQL Joins series, you can find the first article here. It talks about the basic concepts of joins and compares between different types of inner and outer joins. If you aren't familiar with SQL Joins, kindly, read it first. Now, we are...

SQL Joins – Part 1: Difference between Inner Join and Outer Join

The concept of SQL joins is a must-have skill. Every developer should be able to use it in different use-cases with the best performance possible. This tutorial reveal the difference between Inner Join and Outer Join (Left Outer Join and Right Outer Join) in practical...

Abandoning CouchDB (NoSQL) in favor of SQL

In short, Use CouchDB if you are 100% sure you won't need any (complex) joins. This post won't go through any theoretical differences or benchmark scores, only different use cases that I find really important to consider before using CouchDB. CouchDB is the dream DBMS...

SQL Articles