Member-only story
An introduction to SQL for Data Scientists
UCL Data Science Society workshop 9: What is SQL, Selecting data, Querying data, Summary statistics, Grouping data and joining data
This year, as Head of Science for the UCL Data Science Society, the society is presenting a series of 20 workshops covering topics such as introduction to Python, a Data Scientists toolkit and Machine learning methods throughout the academic year. For each of these the aim is to create a series of small blogposts that will outline the main points with links to the full workshop for anyone who wishes to follow along. All of these can be found in our GitHub repository, and will be updated throughout the year with new workshops and challenges.
The ninth workshop in the series is an introduction to the SQL as the final workshop in the toolkit for Data Scientist series. In this workshop we introduce you to the basics of querying data in SQL, extracting summary statistics from data, grouping and joining datasets together. If you wish to code along you can find the full workshop on our GitHub here which contains information on how to set up a MySQL database on your system using a docker container, how to push the data to the database and how to interact with MySQL workbench.