/sql-models

Stand-alone SQL models.

Primary LanguagePython

Python Poetry tests coverage GitHub last commit

code style: prettier code style: black Imports: isort pre-commit.ci status Sourcery


SQL Models

Stand-alone SQL models.

These can be used to enhance existing databases, or as reference material for training and learning.

Some are created by me, and others are from various sources which are credited below.

Contents

Date Dimension

Almost all data models can be improved by adding a calendar table which has dates over a range with useful info and such, such as weekday names.

This model extends this by including holidays and additional columns.

The Euro 2016 football tournament.

This was built by w3resource and can be found at:

Human Resources

Employees, departments, and salaries.

This was built by w3resource and can be found at:

Loans and balances for a B2B bank.

School

A typical school.

This was built by Microsoft and can be found at:

Website Backend

A simple website with users and events.


Additional databases can be found at: