Data Engineering.md

Data Engineering

Data Engineering Map of Content houses all notes related to Data Engineering in general.

Notes

Concepts

• Data Engineers
• Data Cataloging
• Databases
• Data Warehouse
• Dimensional Modeling
• Data Lake
• Data Mart
• Business Intelligence
• Data Science
• Modeling
• **Data Transformation

Data Modeling

• Features of a Data Warehouse
• Fact Table Structure
• Dimensional Modeling
• Data Warehousing Roadmap
• Data Warehousing for Insurance Data

Databases

• SQL Server

• PostgreSQL

• MySQL

• SQLite

• MongoDB

• AWS DynamoDB

• AWS Redshift

• Google Cloud BigQuery

• Azure SQL Database

• SQL

• T-SQL

• PLPGSQL

• 2-Areas/MOCs/Python

Data Lineage and Processing (ETL)

• SQL Stored Procedures Best Practices
• Stored Procedures - SQL Server
• ETL Data Warehousing Best Practices
• ELT
• ETL
• SQL - PostgreSQL ETL Function Template

People

• Ralph Kimball
• Bill Inmon

Tools

• SQL Server Management Studio
• Azure Data Studio
• dbt - Data Build Tool
• R Package - dbx
• Excel, Excel VBA, and Power Query / Power Pivot
• Power BI, Tableau, AWS QuickSight

Lists

• SQL Server List of Tools and Scripts
• R - Database Packages List
• R - Data Validation Packages List
• Learn to Code Platforms Master List
• Data Engineering and Its Main Concepts
• Data Engineering Master List of Resources
• Querying Data from PostgreSQL Database
• SQL Stored Procedures - Cursors
• SQL - Window Functions
• Modern Data Pipeline Complexities
• Data Warehousing Concepts - Slowly Changing Dimensions
• Data Pipelines
• Data Pipeline Architecture
• PostgreSQL Tools List
• PostgreSQL Triggers
• Excel VBA Resource List

---

Appendix: Links

Backlinks:

• Development
• Databases
• Data Science
• Software Development
• Web Development
• Actuarial Science

Topic/Dev/DataScience

list from #Topic/Dev/DataScience AND -"Templates" AND -"MOCs" AND -"Changelog"

Links to this File

list from [[Data Engineering]] AND -"Changelog"