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

Philip Wilkinson, Ph.D.
Towards Data Science
7 min readDec 16, 2021

--

Photo by Jan Antonin Kolar on Unsplash

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.

--

--

Towards Data Science
Towards Data Science

Published in Towards Data Science

Your home for data science and AI. The world’s leading publication for data science, data analytics, data engineering, machine learning, and artificial intelligence professionals.

Philip Wilkinson, Ph.D.
Philip Wilkinson, Ph.D.

Written by Philip Wilkinson, Ph.D.

Specialist Software Engineer at McLaren Racing Limited. 500,000+ views. Connect on: www.linkedin.com/in/philip-wilkinson1

No responses yet