/SQL_School_Tutorial

This repo contains the associated files for my tutorial series about MySQL at Towards Data Science

CraigDoesData

Building a Relational Database from scratch using MySQL

Learn to create, update and interrogate your own fully-functional relational database using SQL with free open-source software

Database building project to accompany these tutorials:

Project status - Complete

Introduction

This repository contains the files to accompany the series of tutorials I wrote which cover designing, implementing and interrogating a relational database from scratch. The code to go with the tutorial is contained in this .SQL file.

Methods used

  • Database Schema Planning
  • Entity Relationship Diagram Construction
  • Database Implementation
  • SQL Query creation, joins, nested queries, etc

Technologies used

Data Sources

Data was created to populate the database by me, Craig Dickson. Some participant names were created using Fake Name Generator.

Getting started

  1. Clone this repo (for help see this tutorial).
  2. Read the associated tutorials:

Contact

All feedback is warmly received. I can be contacted via my website craigdoesdata.de.