# Databases *Backlink: [[README|KaaS]]* *Databases* [[2-Areas/MOCs/_README|Map of Content]] houses all notes related to Databases in general. ## Related MOCs *[[2-Areas/MOCs/_README|Maps of Content]]* - [[Software Development]] - [[Development]] - [[Data Engineering]] - [[Data Science]] - [[Software Development]] - [[Web Development]] - [[Actuarial Science]] ## Database Engines - [[SQL Server]] - [[PostgreSQL]] - [[MySQL]] - [[MongoDB]] - [[SQLite]] ## Conceptual Topics - [[Data Definition Language]] - [[Database Design Best Practices]] - [[Primary Key Constraints in Relational Databases]] - [[Foreign Key Constraints in Relational Databases]] - [[CHECK Constraints in Relational Databases]] - [[Unified Architecture Framework]] - [[SQL Stored Procedures Best Practices]] - [[Fact Table Structure]] - [[ETL]] - [[ELT]] - [[ELT Architecture in Azure Cloud]] - [[Data Warehousing Roadmap]] - [[Data Warehousing Concepts and Definitions]] - [[Data Warehouse]] - [[Data Warehouse for Insurance]] - [[Data Versioning]] - [[Data Engineering and Its Main Concepts]] - [[Data Engineering Master List of Resources]] - [[The Kimball Lifecycle]] - [[SQL Stored Procedures Best Practices]] - [[Kimball Techniques for Data Warehousing]] - [[ETL Data Warehousing Best Practices]] - [[Data Warehousing Concepts and Definitions]] ### Actuarial Related - [[Property Casualty Data Model]] - [[Data Warehousing for Insurance Data]] - [[Actuarial Property Casualty Data Thoughts]] ## Tools ### GUI Interfaces - [[SQL Server Management Studio]] - [[DBeaver]] - [[BeeKeeper]] - [[PgAdmin]] - [[Dbgate]] ### Documentation - [[dbDiagram]] - [[dbdocs]] - [[dbDiagram]] - [[SQL Server - DBA MultiTool#sp_doc]] ### CLI Tools - [[psql]] - [[pgcli]] - [[bcp]] - [[sqlcmd]] - [[dbdocs]] ### Cloud Tools and Services - [[Azure SQL Database]] - [[Google Cloud BigQuery]] - [[AWS DynamoDB]] - [[AWS Redshift]] - [[AWS RDS]] - [[Snowflake]] ### PowerShell Modules - [[PowerShell Module - dbatools]] - [[PowerShell Module - SqlServer]] - [[PowerShell Module - Azure]] ### Data Pipeline Services - [[dbt]] ### SQL Server - [[SQL Server List of Tools and Scripts]] - [[bcp]] - [[sqlcmd]] - [[SQL Server - DBA MultiTool]] ### R - [[R Package - RPostgreSQL]] - [[R Package - DBI]] - [[R Package - dbx]] - [[R Package - pool]] - [[R Package - sqlmlutils]] - [[R Package - dbplyr]] - [[R Package - config]] - [[R - Connect Shiny to PostgreSQL Database]] ### Python - [[3-Resources/Tools/Python/Python Packages 1/Python Package - SQLAlchemy]] ## People - [[Ralph Kimball]] - [[Bill Inmon]] ## Dataviews ### Tagged as *Topic/Dev/Databases* ```dataview list from #Topic/Dev/Databases AND -"Templates" AND -"MOCs" AND -"Changelog" ``` ### Links to this File ```dataview list from [[Databases]] AND -"Changelog" ```