The Data Bible¶

A searchable wiki for Data Administrator (DBA), Data Engineer (DE), Analytics Engineer (AE), Data Analyst (DA). Along with SQL and Python lecture.

Database Administrator — database design, indexing, partitioning, replication, scalability, backup & recovery.
Data Engineer — ETL/ELT, data ingestion, pipeline tools, dbt.
Analytics Engineer — foundations, data modeling, ELT process, dbt, version control, ADLC.
Data Analyst — DAP, Python, visualization, AI for DA, tools, soft skills.
SQL — fundamentals, optimization, snippets.
Resources — glossary, templates, cheatsheets, books, tutorials, datasets.

Quick navigation¶