Tetris-SQL

A complete implementation of Tetris in a SQL query.

One thing I wish I had understood better earlier on in my experience with PostgreSQL is how transactions and locks can be used together to provide serializable logic. 

Practice SQL Interview and Data Science Interview questions 

Since 1999, SQL is not limited to the relational model anymore.
Back then ISO/IEC 9075 (the “SQL standard”) added arrays, objects and recursive queries. In the meanwhile the SQL standard has grown five times bigger than SQL-92. In other words: relational SQL is only about 20% of modern SQL.0 

Top 8 Free, Open Source SQL Clients 

A join is a lookup
A join is a nested loop over rows
A join is a nested loop over columns
A join is compatible alternate realities
A join is flatMap
A join is the solution to the N+1 problem
A join is paths through a graph
A join is a minimal model
A join is typechecking
A join is an operation in the Set monad
A join is the biggest acceptable relation
A join is a…join
A join is a ring product
 

Relational Databases Explained
How Relational Databases Work. This post talks about how indexes and transactions work on the inside of relational databases. 

Awesome SQL Code Review Tools for Developers

Today we are going to look into some of the tools that can help you in reviewing SQL code. These tools will assist in a variety of domain that is related to SQL such as code analysis, formatting, refactoring, and code documentation.