SQL

 DDL -> Data Definition Language

Create, Drop , Alter, Truncate, Comments

DQL -> Data Query Language

Select, From, Where, Group by

DML-> Data Manipulation Language

Insert , Update, Delete

DCL -> Data Control Language

Grant, Revoke

TCL-> Transaction Control Language

Begin Tran, Commit , Rollback , Save point

Microservices Questions and Answer

 How the .NET core kestrel web server Works?

 Libuv manager I/O

Sagar Pattern

Breaks a transaction into a sequence of smaller local  transaction . If a step fails , They system executes compensating transactions to undo preceding changes

CQRS

Command Query Responsibility segregation

Command - one Microservices

Query - One Microservices 

Idempotency

• When same button pressed multiple time
• API header Need to add with Idempotency-key 
• IMemoryCache - will hold the key and handle id(Redis cache)

ConCurrency

     If a same resources in the requested multiple time

     Lock - Feature

Rate Limiter

• No. of request a client can make to your API in a time frame
• Middleware need to configure