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