Databases.md

Databases

• Theory and concepts
  • Data types u
  • Performance tuning u
  • Migrations u
  • Schema versioning u
  • Backup and recovery u
  • Database scalability u
  • Relational databases u
  • Key-value store u
  • Tuple store u
  • Graph databases k
  • Object databases u
  • Column databases k
  • Navigational databases k
  • Hierarchical databases k
  • In-memory databases u
  • Inverted index k
  • Data control language (DCL) u
  • Data definition language (DDL) u
  • Data manipulation language (DML) u
  • Data query language (DQL) u
• Relational
  • Entity-Relationship Diagram k
  • Normal forms u
  • Indexing u
  • Primary keys u
  • Foreign keys u
  • Transactions u
  • Views u
  • Subqueries u
  • Stored procedures u
  • SQL functions u
  • Materialized views k
  • Replications k
  • Virtualization h
• SQL
  • SELECT u
  • INSERT u
  • UPDATE u
  • DELETE u
  • LIMIT u
  • OFFSET u
  • ORDER BY u
  • GROUP BY u
  • HAVING u
  • EXISTS u
  • JOIN u
  • INNER JOIN u
  • LEFT JOIN u
  • RIGHT JOIN u
  • UNION u
  • DISTINCT u
  • WHERE u
  • LIKE u
  • IN u
  • BETWEEN u
  • CREATE TABLE u
  • ALTER TABLE u
  • DROP TABLE u
  • PRIMARY KEY u
  • FOREIGN KEY u
  • CHECK u
  • DEFAULT u
  • INDEX u
  • UNIQUE u
  • GRANT u
  • REVOKE u
  • DENY u
  • EXPLAIN u
• Engines
  • PostgreSQL u
  • Oracle k
  • MySQL k
  • MariaDB k
  • MS SQL Server k
  • Redis u
  • Rabbit k
  • MongoDB u
  • Memcached u
  • Riak h
  • DB2 h
  • SQLite k
  • DynamoDB u
  • Firebase u
• Data engineering
  • Data warehousing k
  • Business intelligence h
  • Big data k
  • Data analysis k
  • AI tools u
  • Cloud databases u
  • Data Visualization u