SQL: string matching, ranking and partitioning

{ databases, sql } // 30.04.2014

Database Recovery (theory)

{ database theory, databases } // 20.04.2014

Database Concurrency Control

{ concurrency, database theory, databases } // 19.04.2014

Database Normalization: theory and practice

{ database theory, databases } // 17.04.2014

Databases: Functional Dependencies and Candidate Keys

{ database theory, databases } // 14.04.2014

SQL snippets: entries with different values on the same attribute

{ databases, sql } // 11.03.2014

SQL: dealing with NULLs and Coalesce

{ databases, sql } // 20.02.2014

SQL: Join, Semi Join, Left Join and ON vs WHERE clauses

{ databases, sql } // 17.02.2014

SQLite and Python basic syntax

{ databases, python, sql } // 26.01.2014