Live Class 1: Relational (MSSQL) | MSSQL Server Installation

Live Class 2: Key-Value (Redis) | Document (MongoDB)

Live Class 1: ERD to DB Schema - Entity | ERD to DB Schema - Attributes | ERD to DB Schema - Recap | ERD to DB Schema - Relations One to Many | ERD to DB Schema - Relations One to Many - with attribute | ERD to DB Schema - Relations Many to Many | ERD to DB SchemaRelations Many to Many - with Attribute | Fine-tune the Schema | Data Types

Live Class 2: Modify The Schema Updating Tables | Modify The Schema Dropping Things | Random Sample Data | Normalization In Database Schema Design | First Normal Form (1NF) | Second Normal Form (2NF) | Third Normal Form (3NF) | Designing a Book Database for rent book

Project: Design Schema for a Library Management System

Live Class 1: Data Integrity | Primary threats to Data Integrity | Types of Data Integrity | Entity Integrity | Referential Integrity | Domain Integrity | User-defined Integrity | Constraints

Live Class 2: The UNIQUE Constraint | Where to ensure integrity Front-end, Backend or Database | How JOIN Works | Types Of Join | Left Join | RIGHT Join | INNER Join

Project: Enforcing Data Integrity in an Online Booking System

Live Class 1: What is an Index | Index in Database | Why Use Indexes | Types of Index | PRIMARY KEY | Secondary KEY | PRIMARY KEY Data actually stored in this tree | PRIMARY KEY What should be the Data-Type | Planning Indexes | Using Indexes | FULLTEXT Index

Live Class 2: What is Query optimization | Optimization techniques | DOs & DON’Ts

Project: Optimize Query Performance Using Indexes

Live Class 1: Stored Procedure | How to make a Stored Procedure | Execute Stored Procedure | Variables | Stored Procedure With Parameters | Managing Stored Procedures

Live Class 2: What is a Trigger | Get Some Hands-on Experience | How to define Triggers | The point of Execution | What triggers can do | Accessing subjected record | Trigger Use Cases | Creating change logs | Some points to remember

Project: Implement Triggers and Stored Procedures in an Inventory System

Live Class 1: Requirement collection & analysis | Conceptual data model | Logical data model | Entity | Weak entity | Entities - type and set | Attributes | Attributes - simple vs composite | Attributes - single-valued vs multi-valued | Attributes - complex | Attributes - derived vs stored | Attributes - key attributes | Attributes - null values

Live Class 2: Relationship | Relationship - degree of relationship | Relationship - cardinality ratio | Relationship - participation constraints | Relationship - associative / intersection entity | Entity - generalization | specialization | Relational Schemas | Automatically Convert ER Diagrams to Relational Schemas | Export SQL

Project: Design a Relational Database for an E-commerce Website

Live Class 1: Combining Multiple Conditions | Combining Multiple Conditions Order of Precedence | Sorting Record Filtering Records | Operators of WHERE Clause | Sorting by Multiple Fields | Getting a Slice of Records | Creating New Record | Handling Special Characters | String Literals Quoting Strings | String Literals Escaping Other Special Characters | Creating a Bookstore | Inserting, Updating & Deleting Records

Live Class 2: Handling Data-Type and Length Mismatch | Exceeding String Length | Errors and Warnings Finding issues in the last query | CREATE TABLE | Inserting records | Deleting records | String Literals | Quotations in string | Length and type mismatch | Investigating Errors and Warnings

Project: Retrieve Data for Reporting in a School Management System

Live Class 1: Built in Functions | String Manipulation | Numeric Calculations | Date and Time | Control Flow

Live Class 2: Aggregation | Aggregation with Filtering | Aggregation with Grouping | Usages of DISTINCT | Aggregation with Conditional Value

Project: Generate Sales Reports Using Grouping and Aggregation

Live Class 1: Subquery | SubQuery - Filtering Results | SubQuery - Dependent aggregation | SubQuery - Filtering by aggregated result | SubQuery for UPDATE/DELETE | SubQuery VS Multiple Query | SubQuery - When to consider

Live Class 2: Views | How to create | How to Use | How to Remove | Inspect View | Things to remember | Updating View | Insert View

Project: Create a Complex Query with Subqueries and Views

Live Class 1: Execution Plan | Operators | Reading an Execution Plan

Live Class 2: Query Store | Enabling Query Store | Identifying under-performing queries