Transactions

Sharding vs Partitioning

Federation in Databases

Data Backup & Recovery

Indexing & Hashing

Normalization

Deadlocks

Concurrency Control

Storage Systems

Relation Modelling

Codd’s Rule

ER Modelling

Data Models & Database Schema

Introduction to Database & DBMS

ETL Process

Schemas

Data Modelling

Decision Support Systems (DSS)

Data Warehouses

OLAP VS OLTP

Sub Queries

Dynamic SQL

CTE & Recursive Queries

Segmentation & Partitioning

Functions

Triggers

Indexes

SQL Commands

Operators

Views & Joins

Schema Management

Keywords

Introduction to SQL and NoSQL Databases