Analytics Engineering with SQL and dbt

Index

Symbols

• 1NF (first normal form), The Data Normalization Process
• 2NF (second normal form), The Data Normalization Process
• 3NF (third normal form), The Data Normalization Process
• 4NF (fourth normal form), The Data Normalization Process
• 5NF (fifth normal form), The Data Normalization Process

A

• abstraction, modularization and, Building Modular Data Models
• ACID (atomicity, consistency, isolation, durability)
  • relational databases and, Types of Databases
• Airflow, Analytics Engineering, Using ETL Tools
• ALTER command (DDL), Creating and Managing Your Data Structures with DDL
• Amazon Redshift, Analytics Engineering
• Amazon Web Services (AWS), Analytics Engineering
• analyses folder, dbt, Analyses-Seeds
• analytic engineering
  • cloud computing and, Cloud Computing and Its Impact on Analytics Engineering-Cloud Computing and Its Impact on Analytics Engineering
  • databases and, Databases and Their Impact on Analytics Engineering-Databases and Their Impact on Analytics Engineering
• analytics engineer, The New Role of Analytics Engineer
  • data analysts and, The New Role of Analytics Engineer
  • data platform engineers and, The New Role of Analytics Engineer
  • responsibilities, Responsibilities of an Analytics Engineer-Responsibilities of an Analytics Engineer
• Apache Airflow, Analytics Engineering
• Apache Arrows, Data Manipulation with Polars
• Apache Spark, SQL for Distributed Data Processing
• Apache Superset, Analytics Engineering
• AWS (Amazon Web Services), Analytics Engineering

B

• backup and recovery, DBMS and, Database Management System ...