Skip to content

billwallis/sql-models

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

38 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Python uv pre-commit.ci status GitHub last commit


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:

About

Stand-alone SQL models.

Topics

Resources

Stars

Watchers

Forks

Contributors

Languages