Databases.md

Databases

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