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

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. …


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

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. …


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 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. …


Using Python to (relatively) easily create an interactive heatmap showing avocado prices by location.

Image by Author — make it yourself following this blog post. Interactive version here.

This article can be seen as an extension of my earlier piece dealing with avocado pricing data (what can I say, I love avocados!) which you can find here. I recommend checking it out!

As Data Analysts / Data Scientists / other manipulators of data, we often find ourselves using…


Using pandas and Matplotlib to explore which district of Berlin is best for open-air swimmers.

Photo by Aleksandr Neplokhov from Pexels

I love swimming! Especially outdoors. In Summer in Berlin, there’s nothing I like better than heading to one of the nice lakes or rivers and cooling off in the water. This is something I particularly appreciate as it is possible much less often in my native Scotland. …


Using GeoPandas, GeoPy and Matplotlib to produce a beautiful choropleth map.

Photo by Peter de Vink from Pexels

I love avocados. They’re tasty and healthy and I enjoy eating them. I know that makes me a basic cliche millenial, but the heart wants what the heart wants! When I came across the Avocado Prices dataset posted by Justin Kiggins on Kaggle, I immediately wanted to have a look…

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