SQL Tutorial Course from Craig Dickson

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

Image for post
Image for post
An Entity Relationship Diagram (ERD) for our International Language School database

This is part 3 of a 3-part series taking you through the process of designing, coding, implementing and querying a relational database using MySQL, starting from zero. See part 1 (Designing a Relational Database and Creating an Entity Relationship Diagram) here, and part 2 (Coding and Implementing a Relational Database using MySQL) here.

All the code and information for this tutorial can be found on the associated GitHub repository. I used Lucidchart to make the diagrams shown in the article.

In parts 1 and 2 of this series, we have gone through the steps of designing our database, implementing it in MySQL and populating it with our data. It’s a good idea to read those before going into this article, but the SQL code to get you caught up is all contained in the associated GitHub repository if you feel like skipping ahead to this analysis section. …


SQL Tutorial Course from Craig Dickson

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

Image for post
Image for post
The Entity Relationship Diagram (ERD) for the International Language School database

This is part 2 of a 3-part series taking you through the process of designing, coding, implementing and querying a relational database, starting from zero. See part 1 (Designing a Relational Database and Creating an Entity Relationship Diagram) here, and part 3 (Data Analysis in MySQL — Operators, Joins and More in Relational Databases) here.

All the code and information for this tutorial can be found on the associated GitHub repository. I used Lucidchart to make the diagrams shown in the article.

In part 1 of this series, we covered going from conception of the database to making a plan, and finally creating an Entity Relationship Diagram spelling out the relationships that we will need to model using our SQL code. We covered the basics of Relational Database theory, and talked about primary keys, foreign keys, cardinality and a lot of other really useful material. …


SQL Tutorial Course from Craig Dickson

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

Image for post
Image for post
Image by mcmurryjulie from Pixabay | License

This is part 1 of a 3-part series taking you through the process of designing, coding, implementing and querying a relational database, starting from zero. See part 2 (Coding and Implementing a Relational Database using MySQL) here, and part 3 (Data Analysis in MySQL — Operators, Joins and More in Relational Databases) here.

All the code and information for this tutorial can be found on the associated GitHub repository. I used Lucidchart to make the diagrams shown in the article.

When I first started using databases at work and writing SQL queries, I was always slightly terrified that I would accidentally delete all of the production data that my company relies on. As a result, I was very tentative about which queries I made and what I did. Over time, I learned more about how to use and interact with databases using some different flavours of Structured Query Language (SQL to its friends). …

About

Craig Dickson

Data Scientist, based in Berlin, Germany. Python, SQL, R, Tableau. He / him. I’m the one on the left in the photo. http://www.craigdoesdata.de

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store