Databases.md

Databases

• Theory and concepts
  • Data types
  • Performance tuning
  • Migrations
  • 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
  • INSERT
  • UPDATE
  • DELETE
  • LIMIT
  • OFFSET
  • ORDER BY
  • GROUP BY
  • HAVING
  • EXISTS
  • JOIN
  • INNER JOIN
  • LEFT JOIN
  • RIGHT JOIN
  • UNION
  • DISTINCT
  • WHERE
  • LIKE
  • IN
  • BETWEEN
  • CREATE TABLE
  • ALTER TABLE
  • DROP TABLE
  • PRIMARY KEY
  • FOREIGN KEY
  • CHECK
  • DEFAULT
  • INDEX
  • UNIQUE
  • GRANT
  • REVOKE
  • DENY
  • EXPLAIN
• Engines
  • PostgreSQL
  • Oracle
  • MySQL
  • MariaDB
  • MS SQL Server
  • Redis
  • Rabbit
  • MongoDB
  • Memcached
  • Riak
  • DB2
  • SQLite
  • DynamoDB
  • Firebase
• Data engineering
  • Data warehousing
  • Business intelligence
  • Big data
  • Data analysis
  • AI tools
  • Cloud databases
  • Data Visualization