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:

• Designing a Relational Database and Creating an Entity Relationship Diagram (SQL Part 1).
• Coding and Implementing a Relational Database using MySQL (SQL part 2).
• Data Analysis in MySQL — Operators, Joins and More in Relational Databases (SQL part 3).

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

• MySQL Community Server
• PopSQL
• Lucidchart

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:

• Designing a Relational Database and Creating an Entity Relationship Diagram (SQL Part 1).
• Coding and Implementing a Relational Database using MySQL (SQL part 2).
• Data Analysis in MySQL — Operators, Joins and More in Relational Databases (SQL part 3).

Contact

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