Tag Archives: sql

SQL Joins: Some Basics

Joining tables in SQL is an essential part of many digital services and products. Joins let you answer questions such as which customers bought which products? How many staff work at a particular location? Which students are in which classes at a school? Joining in SQL becomes even more important when your data are stored… Read More »

UK University Locations

The UK has around 160 universities, located around the country. Here is a map of UK University Locations, made using Folium.   Download the UK university locations data [csv] Access the list of UK universities Python Code For UK University Locations How to convert postcodes to coordinates

Convert Postcode Coordinates

It’s common to have the postcode of an address and need to plot this on a map. In this post I show you two options for how to convert postcode coordinates using an online tool or data available for free online. Option 1. Use an Online Conversion Tool Often the easiest way to convert postcode… Read More »