Databases

1. Query Languages
   1. Structured Query Language (SQL)
      1. Data Definition Language (DDL)
         1. CREATE statements
            1. CREATE TABLE
            2. CREATE VIEW
            3. CREATE INDEX
         2. ALTER statements
            1. ALTER TABLE
            2. ALTER VIEW
            3. ALTER INDEX
         3. DROP statements
            1. DROP TABLE
            2. DROP VIEW
            3. DROP INDEX
      2. Data Manipulation Language (DML)
         1. SELECT statements
            1. Basic SELECT queries
            2. SELECT with WHERE clause
            3. SELECT with JOINs
            4. SELECT with GROUP BY and HAVING
            5. SELECT with ORDER BY
         2. INSERT statements
            1. Basic INSERT syntax
            2. INSERT with SELECT
            3. Bulk INSERT operations
         3. UPDATE statements
            1. Basic UPDATE syntax
            2. UPDATE with JOINs
            3. Conditional UPDATE operations
         4. DELETE statements
            1. Basic DELETE syntax
            2. DELETE with WHERE clause
            3. Truncate vs DELETE
      3. Data Control Language (DCL)
         1. GRANT statement
            1. Permissions types (SELECT, INSERT, etc.)
            2. Granting privileges to roles and users
         2. REVOKE statement
            1. Removing permissions
            2. Best practices for security
      4. Transaction Control Language (TCL)
         1. START TRANSACTION
         2. COMMIT
         3. ROLLBACK
         4. SAVEPOINT
         5. Transaction isolation levels
   2. Procedural Extensions to SQL
      1. Stored Procedures
      2. Functions
      3. Triggers
      4. Cursors
   3. ANSI SQL Standards
      1. SQL-86/SQL-87
      2. SQL-92
      3. SQL:1999 (SQL3)
      4. SQL:2003
      5. SQL:2006 and later updates
   4. NoSQL Query Languages
      1. MongoDB Query Language (MQL)
         1. BSON and JSON queries
         2. CRUD operations
            1. db.collection.find()
            2. db.collection.insert()
            3. db.collection.update()
            4. db.collection.delete()
         3. Aggregation framework
         4. Indexing and compound queries
      2. Cassandra Query Language (CQL)
         1. Keyspace management
         2. CQL Data Types
         3. Tables and Column Families
         4. SELECT and filtering
         5. INSERT, UPDATE, DELETE operations
      3. Graph Query Languages
         1. Gremlin
            1. Graph traversal language concepts
            2. Vertex and edge manipulation
            3. Gremlin pipelines and side effects
         2. Cypher (for Neo4j)
            1. MATCH and pattern matching
            2. CREATE and manipulation of nodes and relationships
            3. MERGE, SET, DELETE operations
            4. Using filters and aggregations
   5. Advanced Query Topics
      1. Recursive queries
      2. Query optimization techniques
         1. Use of indexes
         2. Execution plans
         3. Query rewriting and transformations
      3. Full-text search queries
      4. Geospatial queries and extensions