Databases and SQL

Major Database Servers/Solutions

  • MySQL (Oracle) / MariaDB
  • SQL Server (Microsoft)
  • PostgreSQL
  • Redis – 38.4k – In-memory database that persists on disk.
  • CockroachDB – 16.9k
  • MongoDB – 16.6k
  • Cassandra (Apache)
  • CouchDB (Apache)
  • Oracle
  • IBM DB2

Learn SQL

Database Management

MySQL/MariaDB Commands/SQL

Serverless Database Solutions

  • MySQL (Oracle) / MariaDB
  • SQL Server (Microsoft)
  • SQLite
  • PostgresSQL
  • MongoDB
  • Cassandra (Apache)
  • CouchDB (Apache)
  • RethinkDB
  • Firebird
  • Oracle
  • IBM DB2

Concepts

  • CRUD
  • Relational Databases
  • Normalization
  • Data Modeling
  • Entity Relationship Modeling
  • ACID
  • Tables
  • Views
  • Stored Procedures
  • Triggers
  • User Defined Types
  • Indexes
  • Object-Relational Mapper (ORM)

Serverless Database Solutions

Other DB Solutions

  • Firebird
  • RethinkDB