Database

  1. SQL
    • Introduction
    • RDBMS Concepts
    • Type of Databases
      • MySQL
      • MS SQL Server
      • Oracle
      • MS Access
    • Commands
      • DDL
      • DML
      • DCL
      • TCL
  2. Oracle
    • Create Database
    • Data Types
      • Character
      • Numeric
      • Date/Time
      • Binary
      • Large Object (LOB)
      • Miscellaneous
    • Operators
      • Arithmetic
      • Comparison
      • Logical
    • Expressions
      • Boolean
      • Numeric
      • Date
    • Drop Database
    • Select Database
    • Create Table
    • Rename Table
    • Drop Table
    • Truncate Table
    • Alter Table
    • Insert Query
    • Select Query
    • Where Clause
    • Update Query
    • Delete Query
    • AND Clause
    • OR Clause
    • Like Clause
      • Wildcard Operators
    • Top/Limit/RowNum Clause
    • Order By
    • Group By
    • Distinct Keyword
    • IN
    • NULL
    • Constraints
      • NOT NULL Constraint
      • DEFAULT Constraint
      • UNIQUE Constraint
      • PRIMARY Constraint
      • FOREIGN Constraint
      • CHECK Constraint
      • INDEX Constraint
    • Joins
      • INNER Join
      • LEFT Join
      • RIGHT Join
      • FULL / FULL OUTER Join
      • CARTESIAN / CROSS Join
      • SELF Join
    • Operators
      • Union
      • Except
      • Intersect
    • Auto Increment
    • Sub Query
    • Duplicate Table
    • Having
    • Aliases
    • View
    • Transaction
  3. NoSQL
    • Overview
  4. MongoDB 
    • Overview
    • Installation
    • Create DB
    • Drop DB
    • Create Collections
    • Drop Collections
    • Insert Documents
    • Query Documents
      • AND OR Conditions
    • Update Document
    • Delete Document
    • Projection
    • Limit
    • Skip
    • Sort
    • Indexing
    • Aggregation
    • Backup
    • Restore 
  5. SQLite 
    • Overview
    • Installation
    • Create Database
    • Create Table
    • Insert Data
    • Select Data
    • Update Data
    • Delete Data
    • Where Clause
    • Order By
    • Limit Clause
    • Primary Key
    • Foreign Key
    • Joins
      • INNER Join
      • LEFT Join
      • RIGHT Join
      • FULL / FULL OUTER Join
      • CARTESIAN / CROSS Join
      • SELF Join
    • Drop Table
    • Drop Database
  6. Recipes
    • Populate data in a table using another table
    • Find Nth highest salary
    • Interview Questions
      • MySQL
      • Oracle
      • MongoDB
      • SQLite