Prerequisites / Tools

Databases Engines and Tools to install

Introduction to SQL

• DDL Basics - Data Types - Table creation - Alter tables: Class 1

• DDL Exercises: Class 2

• Simple Queries - ER diagram: Class 3

• Table Variables and Set Operators - Exercises: Class 4

• Sub-queries in WHERE: Class 5

• Sub-queries Exercises: Class 6

• Sub-queries in FROM and SELECT - Exercises : Class 7

• Aggregations : Class 8

• Aggregations (Cont.md) : Class 9

• Join Operators : Class 10

• Aggregations - Join and Misc Exercises: Class 11

Database Design

• Normalization Overview : Class 12

Advanced SQL

• Data Modification Statements - Exercises: Class 13

• Functions - Exercises: Class 14

• Views - Exercises: Class 15

• Constraints and Triggers - Exercises: Class 16

• Indexes - Exercises: Class 17

• Stored Procedures: Class 18

  • Multiple Returns & Conditional: Class 18_1
  • Loop in Stored Procedures: Class 18_2
  • Error Handling: Class 18_3
  • MySQL Stored Function: Class 18_4
  • Exercises: Class 18_5

• MySQL Administration: Class 19

Mongo DB

• How to install mongo in your pc (ubuntu or dockerized.md)
• Mongo Queryset
• Mongo Exercises

Key Value DB

• Redis

OLAP

• Dimensional Model

• Vertica DB