Database for Software Developers

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

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

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: 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: 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: 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