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¶
-
MySQL
-
MongoDB
-
AWS DynamoDB
-
Azure SQL Database
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¶
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:
Topic/Dev/DataScience
list from #Topic/Dev/DataScience AND -"Templates" AND -"MOCs" AND -"Changelog"
Links to this File¶
list from [[Data Engineering]] AND -"Changelog"