Welcome to the MYSQL course

What is RDBMS & Why MYSQL?

Getting Started

What is Database?

Introduction to RDBMS

Chapter I:  Introduction to Databases

Databases and DBMS

SQL databases

NoSQL databases

SQL vs NoSQL databases

Database Replication

Indexes

Normalization and Denormalization

ACID and BASE consistency models

CAP theorem

PACELC Theorem

Transactions

Distributed Transactions

Sharding

Consistent Hashing

Database Federation

Chapter II

N-tier architecture

Message Brokers

Message Queues

Publish-Subscribe

Enterprise Service Bus (ESB)

Monoliths and Microservices

Event-Driven Architecture (EDA)

Event Sourcing

Command and Query Responsibility Segregation (CQRS)

API Gateway

REST, GraphQL, gRPC

Long polling, WebSockets, Server-Sent Events (SSE)

Chapter III

Geohashing and Quadtrees

Circuit breaker 

Rate Limiting

Service Discovery

SLA, SLO, SLI

Disaster recovery

Virtual Machines (VMs) and Containers

OAuth 2.0 and OpenID Connect (OIDC)

Single Sign-On (SSO)

SSL, TLS, mTLS

Chapter IV

System Design Interviews

URL Shortener

WhatsApp

Twitter

Netflix

Uber

Chapter V

Next Steps

References

Appendix

Learn how to work realtime on Mysql database in production Environment

Learn Mysql