Cover Image for Solving mysteries with SQL
Cover Image for Solving mysteries with SQL
Avatar for Journocoders
Presented by
Journocoders
We are a community group of journalists and others working in news. Together, we aim to learn and share ✨technical skills✨ for use in our reporting.
25 Going

Solving mysteries with SQL

Register to See Address
London, England
Registration
Welcome! To join the event, please register below.
Registration closes  .
About Event

This month we'll be learning how to solve mysteries with SQL.

SQL is a special language for communicating with databases using clear, readable commands. Well, fairly readable. And why would you have a database to begin with? Databases are used where the data is complex, interconnected, or just really massive beyond what can be held in a spreadsheet.

For example, Google's BigQuery database lets you work with tens of millions of rows of data with SQL. One of the biggest cryptocurrency analysis platforms uses SQL. And SQL is also the way you access some academic and statistical datasets. So it's a useful skill to have.

​In this session we'll be following a tutorial that teaches you SQL concepts step-by-step as part of a story-based interactive game where you solve puzzles to figure out what’s going on. Along the way it covers how to select the data we need, join datasets together, and summarise it in ways that answers particular questions.

​​​​​​​All of our events are suitable for beginners, and no programming experience is required. Bring a laptop along as this a practical, hands-on workshop. Please also sign up for a Dropbox account if you don't already have one so you can edit the shared doc we'll be using during the event.

​​​​​​​Schedule
7:00 🚪 Doors open
7:30 🗣 Show and tell
7:40 💻 Tutorial
9:00 🍺 Drinks at the Prince Arthur

​​​​​​​If you can't make the main event, you're also welcome to just join us in the pub!

​​​​​​​Our events do often fill up, but if it's full please do join the waitlist as spaces do typically become available. And if you find you can no longer make it, please update your registration so someone else can take your spot.

Location
Please register to see the exact location of this event.
London, England
Avatar for Journocoders
Presented by
Journocoders
We are a community group of journalists and others working in news. Together, we aim to learn and share ✨technical skills✨ for use in our reporting.
25 Going