<aside> 📚 Notes from: SQL Ultimate Course by Data With Baraa — PDF 01

</aside>

What is SQL?

SQL (Structured Query Language) — pronounced 'SeQueL' — is the standard language used to communicate with relational databases.

• Databases can store 30M+ rows of data securely and in an organized way
• SQL lets you ask questions (queries) and get answers from that data
• Without SQL: scattered Excel files, text files, notebooks — slow and hard to search

What is a Database?

A database is a secure, organized collection of data stored on disk as files. Data is organized in tables (rows and columns).

• Much better than spreadsheets for large-scale data (millions of rows)
• Accessible 24/7 through a DBMS

DBMS — Database Management System

Software that sits between the database (on the server) and its users/applications. It handles all SQL requests.

• Users, applications (App </>), and BI tools (Power BI) all send SQL → DBMS → Database
• Runs 24/7 on a server (cloud or on-premise)

Types of Databases

Relational (SQL)