Databases.md

Databases

Backlink: KaaS

Databases Map of Content houses all notes related to Databases in general.

Related MOCs

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

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

Links to this File

list from [[Databases]] AND -"Changelog"