SQL – Databases

A database is the top-level container in a relational database management system (RDBMS). It holds tables, views, indexes, stored procedures, and more — all logically grouped under one roof. A company might have separate databases for their application data, analytics warehouse, and audit logs.

Think of a database like a filing cabinet: inside are multiple folders (tables), and inside each folder are individual documents (rows). The database management system (MySQL, PostgreSQL, SQLite) is the cabinet itself — the software that organizes, stores, and retrieves everything efficiently.

Database hierarchy

Database Server (MySQL, PostgreSQL)
└── Database: "codescompiler_academy"
    ├── Table: students
    ├── Table: courses
    ├── Table: enrollments
    └── View: top_students_view

Try It Yourself — Interactive SQL Editor

Edit the query below and click Run Query ▶ to see live results powered by SQLite running directly in your browser.

Key Points

• A database groups related tables, views, and indexes together
• Different databases on the same server are fully isolated
• SQLite stores an entire database in a single .db file
• Most RDBMS allow multiple databases per server instance

Pro Tip from CodesCompiler: The best way to learn SQL is to break things intentionally — modify the query above, change the WHERE conditions, try different columns. Every error teaches you something the docs cannot.

In the next lesson, we continue exploring SQL’s powerful feature set to build your database mastery.