💻
System Design
  • System Design
  • System Design Overview
  • Basic Concepts
    • Memory Levels
    • Functional vs Non-Functional Requirements
  • Key Concepts and Definations
    • Scalability
    • Performance
    • Availability
    • Reliability
    • Consistency
    • Stateless vs Stateful Servers
    • CAP Theorem
    • Data Storage and Retrieval
    • Consistent Hashing
    • Rate Limit
    • Networking and Communication
    • Security and Privacy
  • Building Blocks
    • REST APIs
      • HTTP Request
    • Authentication and Authorisation
    • Caching
      • Caching with Redis + Python
      • LRU Caching Implementation
      • Caching: Case Study
    • Database
      • DBMS
      • SQL
      • NoSQL
      • Properties
      • Database
        • Elasticsearch
        • Neo4j
        • Redis
        • OrientDB
      • Use Cases
    • Message Queue
      • Kafka
      • Pulsar
      • Celery
      • Rabbimq
      • Redis
    • Deployment
      • Docker
        • Distroless
      • Kubernetes
      • CI - CD Pipeline
    • CDN
    • Nginx
      • Reverse Proxy
      • Load Balancer
      • Caching
    • Web Scrapper and Automation
    • Parallel Processing
    • Scheduling
      • Airflow
      • Azure Logic App
    • Networking Fundamentals
    • Cloud Services
      • AWS
        • Dynamic Website on AWS
      • Google Cloud
        • Dynamic Website on GCP
      • Azure
  • Miscellaneous
  • Git
    • Interesting Repos
      • Quantitative Finance
  • Visualization
    • Power BI
    • Kibana
    • Redash
  • rocksdb and Python
  • Python Framework
    • Python Concepts
      • miscellaneous Concepts
      • OOP
      • Built-in Class Attributes
      • Built-in Functions
      • Python Clean Code
      • Async io
      • Concurrency vs Parallelism
      • Client-Server Model
    • Flask
    • FastAPI
    • Tornado
    • Django
  • Java Script
    • Node js
    • Express js
  • Operating System
  • Big Data
    • Spark
      • Pyspark Working
    • EDW
      • EDW Concepts
    • GraphQL
    • Map Reduce
  • Search
  • UI UX
    • Figma
  • Logging in Python
  • Communication in Python
  • Hashing
  • Sample Application Structure
  • Data Transfer over Network
    • jwt Authentication
  • Rough
    • Authentication and Authorization
    • Pyspark Kubernetes Operator
    • Pulsar vs Kafka
    • Storage vs Compute Server
    • Bigdata Storage Server
    • Bigdata Storage + Compute Servers
    • Stream Data Storage
    • Columnary vs Row based
    • Big data Processing
    • Stream data Processing
    • Metadata and usage
    • Data Cataloging and Usage
    • Iceberg vs Hive
    • Page 1
  • SQL - A Complete Guide
    • SQL Queries
  • Data Engineer Interview
  • Elasticsearch
  • Lambda Architecture
  • Technology Stack
  • Machine Learning
    • Learning rate warm-up
  • System Designs
    • Thinking Mental Model
    • Design Fundamental Systems
      • Design Rate Limiter
      • Design Key-Value Store
      • Design a Web Crawler
      • Design Logging and Monitoring System
    • Design Spotify
    • Design ChatGPT
    • Design Tinder
    • Design Twitter
    • Design Hotel Booking System
    • Design Calender Management System
    • Design Reddit
    • Design Whatsapp
    • Design Youtube
    • Design Instagram
    • To Read
Powered by GitBook
On this page

Was this helpful?

  1. SQL - A Complete Guide

SQL Queries

PreviousSQL - A Complete GuideNextData Engineer Interview

Last updated 9 months ago

Was this helpful?

References

https://www.youtube.com/watch?v=HXV3zeQKqGY&t=7604s