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

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