All Courses

Database Course Contents

Here are the some resources to help you learn about databases:

• Data Modeling

  • What is Data Modeling
  • Levels of Data Modeling
  • Data Modeling Process Guide
  • Best Practices in Data Modeling

• ERD (Entity Relationship Diagram)

  • Introduction to ER Models
  • Entities, Attributes, Relationships
  • Degree, Cardinality, Participation
  • Participation
  • Relationship Attributes in ER Diagram
  • Weak Entity Example
  • Weak Entity Example (Banking)

• Functional Dependency

  • Functional Dependency in DBMS
  • Inference Rules for Functional Dependencies
  • Attribute Closure & Armstrong Axioms
  • Closure of Attribute Sets

• Normalization

  • Introduction to Normalization

  • First Normal Form (1NF)

  • Second Normal Form (2NF)

  • Third Normal Form (3NF)

  • Boyce-Codd Normal Form (BCNF)

  • Higher Normal Forms (4NF, 5NF)

  • Convert Employee Project Table to 2NF

  • Employee Table 3NF Solution

  • Relational Model Introduction

  • Relations, Tuples, Attributes

  • Relational Database Keys Explained

  • Relational Integrity Constraints

  • Best Practices: ER to Relational Model

  • Best Practices: ER Diagram to Relational Model

---

System Design Course Contents

• Complete System Design Guide

• Day 0: Mastering System Design

• Day 1: Introduction to System Design

• Day 2: Requirements Gathering in System Design

• API Gateway

  • Introduction to API Gateway
  • API Gateway Usage, Benefits & Examples
  • Advantages & Disadvantages of API Gateway

• Bloom Filters

  • Introduction to Bloom Filters
  • Bloom Filter Applications
  • Bloom Filter Variants & Extensions
  • Bloom Filters Benefits & Limitations

• Caching

  • Introduction to Caching & Web Performance
  • Cache Coherence & Consistency Models
  • Cache Invalidation Strategies
  • Cache Performance Metrics Guide
  • Cache Read Strategies
  • Cache Replacement Policies Explained
  • Caching Challenges & Solutions

• CDN (Content Delivery Network)

  • CDN Explained: Simple Guide
  • CDN Architecture & Optimization Guide
  • Origin Server vs Edge Server
  • Push vs Pull CDN

• Characteristics of Distributed Systems

  • Concurrency & Coordination
  • Fault Tolerance vs High Availability
  • High Availability in Distributed Systems
  • Improve Latency & Performance
  • Monitoring vs Observability
  • Resilient Distributed Systems & Error Handling
  • Scalability: Horizontal vs Vertical Scaling

• Checksum

  • What is Checksum?
  • Top Uses of Checksum

• Data Partitioning

  • Introduction to Data Partitioning

  • Benefits of Data Partitioning

  • Data Partitioning Strategies

  • Data Sharding Techniques Explained

  • Data Partitioning Problems & Solutions

  • ACID Properties of Database Transactions

  • ACID vs BASE Database Comparison

  • ACID vs BASE Database Examples

  • BASE Properties in NoSQL Databases

  • Data Replication vs Mirroring

---

System Design Interview Course Contents

• 📚 Complete Course Overview

• Interview Basics

  • The Steps to Solve System Design Interviews
  • Functional vs Non-Functional Requirements
  • Back-of-the-Envelope Estimations
  • Things to AVOID in System Design Interviews

• Core Concepts Glossary

  • Key Characteristics of Distributed Systems
  • Load Balancing
  • Caching
  • Data Partitioning (Sharding)
  • Database Indexes
  • Proxy Servers - Forward vs Reverse
  • Redundancy & Replication
  • SQL vs NoSQL
  • CAP Theorem & PACELC
  • Consistent Hashing
  • Polling vs Long Polling vs WebSockets vs SSE
  • Bloom Filters
  • Quorum
  • Leader and Follower Pattern
  • Heartbeat - Failure Detection
  • Checksum - Data Integrity

• Trade-offs

  • Why Trade-offs Matter
  • Strong vs Eventual Consistency
  • Latency vs Throughput
  • ACID vs BASE
  • Read-Through vs Write-Through Cache
  • Stream vs Batch Processing
  • Load Balancer vs API Gateway
  • API Gateway vs Direct Server Access
  • API Gateway vs Reverse Proxy
  • SQL vs NoSQL (Trade-off Focus)
  • Primary-Replica vs Peer-to-Peer Replication
  • Data Compression vs Deduplication
  • Server-Side vs Client-Side Caching
  • REST vs gRPC
  • Polling vs Long Polling vs WebSockets vs Webhooks
  • CDN vs Direct Server Serving
  • Stateful vs Stateless Architecture
  • Serverless vs Traditional Server-Based
  • Hybrid Cloud vs All-Cloud Storage
  • Read-Heavy vs Write-Heavy Systems

---

Low Level Design Course Contents

• OOP (Object Oriented Programming)

  • Object Oriented Programming Basics Guide
  • Object Oriented Analysis & Design UML
  • Association, Aggregation, Composition in OOP (Java)
  • Cohesion vs Coupling vs Delegation in OOP
  • Generalization vs Specialization in OOP
  • Mastering Abstraction in Java OOP
  • Mastering Encapsulation in OOP
  • Mastering Inheritance in OOP
  • Mastering Polymorphism in Java OOP
  • Types of Inheritance in Java OOP
  • UML Unified Modeling Language Basics
  • UML Activity Diagram & Workflow Modeling
  • UML Sequence Diagram Guide
  • UML Use Case Diagram Guide
  • What is Class Diagram UML

• SOLID Principles

  • Single Responsibility Principle (SRP) Guide
  • Open Closed Principle (OCP) Guide
  • Mastering Liskov Substitution Principle
  • Mastering Interface Segregation Principle
  • Master Dependency Inversion Principle
  • SOLID Principles TypeScript Examples