# 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|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 ```dataview list from #Topic/Dev/DataScience AND -"Templates" AND -"MOCs" AND -"Changelog" ``` ### Links to this File ```dataview list from [[Data Engineering]] AND -"Changelog" ```