SERGIO TOMASBack to portfolio
Get in touch

Databases · Tool

MySQL

The open-source relational workhorse.

Used at
  • Tugarê
01Overview

MySQL is one of the most widely used relational databases. I've used it to back websites and web systems, and I apply the same relational fundamentals across every SQL engine.

02Key concepts

What anyone working with it needs to understand

  1. 01

    Relational modeling

    Tables, keys and normalization.

  2. 02

    SQL & joins

    Querying related data efficiently.

  3. 03

    Indexes

    B-tree indexes, EXPLAIN and query optimization.

  4. 04

    Transactions

    ACID, isolation levels and InnoDB.

  5. 05

    Replication

    Read replicas and high availability.

  6. 06

    Backup & security

    Users, privileges and recovery strategies.

03In practice
Database behind the websites and web systems I built with PHP and WordPress at Tugarê | CDM São Paulo.
04Related