Database

1. SQL
• Introduction
• RDBMS Concepts
• Databases
• Syntax
• Data Types
• Operators
• Expressions
• DDL, DML and DCL
• Create Database
• Drop Database
• Select Database
2. Oracle
• Create Table
• Drop Table
• Insert Query
• Select Query
• Where Clause
• AND & OR Clauses
• Update Query
• Delete Query
• Like Clause
• Top Clause
• Order By
• Group By
• Distinct Keyword
• Sorting Results
• Truncate
• Alter
• IN
• NULLs
• Constraints
• NOT NULL Constraint
• DEFAULT Constraint
• UNIQUE Constraint
• PRIMARY Constraint
• FOREIGN Constraint
• CHECK Constraint
• INDEX Constraint
• Joins
• INNER Join
• LEFT Join
• RIGHT Join
• FULL Join
• Cartesian Join
• SELF Join
• Union
• Except
• Intersect
• Auto Increment
• Sub Query
• Duplicate Table
• Temporary Tables
• Wildcard Operators
• Transaction
• Having
• View
• Index
• Aliases
3. NoSQL
• Overview
4. MongoDB 
• Overview
• Installation
• Create & Drop DB
• Create & Drop Collections
• Insert Documents
• Query Documents
• AND OR Conditions 
• Update Document
• Delete Document  
• Projection
• Sort, Skip, and Limit 
• Indexing
• Aggregation
• Backup and Restore 
5. SQLite 
• Overview
6. Recipes
7. Interview Questions
• SQL