ETL (Extract, Transform, Load)
The process of pulling data from various sources, cleaning it, and loading it into a destination.
Example: Apache Airflow, dbt (data build tool).
Parquet
A columnar storage file format that is highly optimized for reading large datasets efficiently.
Context: Used in "Data Lakes" instead of CSVs for speed.
Data Pipeline
A series of automated steps that move data from a source to a destination.
Example: Pulling daily sales from Shopify ⇒ Cleaning ⇒ Updating a Dashboard.
SQL (Structured Query Language)
The standard language used to communicate with relational databases.
Example: PostgreSQL, MySQL, SQLite.
CI/CD (Continuous Integration / Deployment)
A set of practices that automate the testing and deployment of code, ensuring that updates to data pipelines are reliable and seamless.
Example: GitHub Actions, GitLab CI.
Hypervisor
Software that creates and runs virtual machines (VMs), allowing one physical server to host multiple isolated operating systems.
Example: KVM (Kernel-based Virtual Machine), LXD/Incus (container hypervisor).