📖
System Design
  • Home
  • Learn System Design Daily
  • System Design Steps
  • List of design questions:
  • My System Design Interview Checklist
  • CheatSheet
  • Programming Language Jargons
  • Scaleable Design
  • Agile Scrum
  • Uber
  • Gmail System Design
  • Distributed Rate Limiting
  • Audio Search Engine
  • Code Style and Review
  • Calling App Design
  • Low Level Design: Payment Tracking App
  • Machine Coding :Cache
  • Interview Advice
  • URL Shortner
  • Unique ID in Distributed Systems
  • Load Balancing Algorithm
  • API Architecture
  • Desgin Practise for Rest API
  • Performance Practise for API
  • API Gateway
  • API Security Hacks
  • Distributed Design Patterns
  • Fault Tolerance in Distributed Systems
  • Microservice Communication Design Patterns
  • Zipping /Compression
  • Database
  • Mongo DB
  • SQL
  • PostgreSQL
  • Database Designs
    • Designing a location based database
  • Building Database
  • Design Patterns
    • Microservice Architecture 10 Design Patterns
    • Interaction Patterns
  • Locale.ai
  • Version Control
  • Caches / Caching
  • High Level Design
  • Low Level Design
  • Containers, Docker
  • Docker
  • Linux Directories
  • Design Pattern for Software Architect
  • S.O.L.I.D Principles
  • Monitoring and Telemetry for Production System
  • C4 model
  • LRU Cache
  • VSCode
  • Chatbot Architecture
  • Streaming API Repsonse
  • Latency in System Design
  • Cloud
    • Azure
    • AWS
  • Builds
    • Jenkins
Powered by GitBook
On this page
  • Traditional way of storing the data before the database
  • Structure of Database Sheet
  • Creating the SQL database standard
  • Interactive Learning
  • Reference

Was this helpful?

SQL

PreviousMongo DBNextPostgreSQL

Last updated 3 years ago

Was this helpful?

Traditional way of storing the data before the database

  • Sequential Master update in a single file and sort timely for the faster update, done on magnetic data drives

  • Random access data , stored in the disk drives and faster access but sorting not feasible , disks were easy to do update and read

  • Structured query language came as a standard to read and interact with database from different vendors

  • SQL is most powerful non procedural language

Structure of Database Sheet

Interactive Learning

Reference

Creating the SQL database standard
https://sqlbolt.com/
Anomaly Detection using simple SQL
Speeding up SQL queries by orders of magnitude using UNION
Practical SQL for Data Analysis
HOW TO INTERPRET POSTGRESQL EXPLAIN ANALYZE OUTPUT
Thinking in Events: From Databases to Distributed Collaboration Software
Recursion in SQL