DATABASE

  1. What is Database?
  2. Type of Databases
    • Relational 
    • Document
    • Graph
  3. SQL Databases
    • Overview
    • DBMS Concepts
      • ACID Properties
      • Relationship
      • Normalization/Denormalization
      • ER Model
    • Type of Databases
      • MySQL
      • MS SQL Server
      • Oracle
      • MS Access
    • Statements
      • DDL
      • DML
      • DCL
      • DQL
      • TCL
  4. Oracle
  5. SQLite 
  6. NoSQL Databases
    • Overview
    • Type of NoSQL Databases
      • Key-value stores
      • Wide-column stores
      • Document databases
      • Graph databases
  7. MongoDB 
  8. Columnar Databases
    • Overview
  9. ClickHouse
    • Overview
    • Installation
    • Databases
    • Table
  10. Times Series Databases
    • Overview
  11. Influx
    • Overview
    • Installation
    • Databases
    • Table (Measurements)
    • Columns ( Fields)
    • Inserting Data
    • Querying Data
    • Deleting Data
    • Tags
    • Group By
    • Format 
    • Retention Policies
  12. Prometheus
    • Overview
  13. Graph Databases
    • Overview
  14. Recipes
    • Populate data in a table using another table
    • Fetch records that are present in one table but not in another table
    • Remove duplicate rows from table
    • Find the second highest salary of Employee
    • Find the 3rd highest salary from a table with/without top or limit keyword
    • Find Max Salary from each department