SQL 101 Writeup 2021

SQL101, the 2nd workshop in this year’s 3 part DA101 series, was conducted by Zi Kai and Jake. The workshop sought to introduce SQL, short for Structured Query Language, which is a language that is primarily used to communicate with databases; more specifically, relational databases.

Relational databases are the most widely used form of database in the world. As such, SQL is a very important tool for all aspiring Data Scientists/Analysts/Engineers!

 

The curriculum for SQL101 was created with the beginner in mind. We hope that through SQL101, participants would pick up the basic concepts and commands of the language, and use that to further their SQL journey!

 

This year, SQL was conducted on Mode, which is a platform that can be used to practice SQL without having to download anything. We experienced our highest ever turn out this year for SQL101 workshops, a testament to the growing interest in Data Science in SIM!

 

Part 1: Introduction to databases and SQL by Jake

We started off the workshop introducing the concept of a database. Most people might have an intuition as to what a database is, but many do not know how a database actually works. We first introduced what databases are, the different types of databases used in industry, and how it differs from Excel, which is what most people typically use to store simple data.

Flowchart

We then explained what a relational database is, and how SQL is a language that is used to manage and query relational databases.

This is the heading

Part 2: SQL Commands by Zi Kai

In this next segment, we introduced SQL commands. We started off with basic commands such as SELECT and FROM, before proceeding to slightly more challenging commands like GROUP BY, where the concept of aggregating data by specific groups were introduced.

We then had participants go into breakout rooms, where they were given 5 questions to solve, using the commands that we had taught. Our Analysts were stationed in the breakout rooms to guide the participants whenever necessary.

Finally, we ended off by introducing a couple more intermediate level SQL commands, before giving our participants 2 more bonus take home questions, which were optional but highly encouraged to attempt. We then released the solutions an hour later, via our DAC Community Telegram chat.

We would like to thank all our participants for their support and attention. We were pleased to see many fellow data enthusiasts take their first step in learning SQL, and we hope that SQL101 inspired you to go further on this journey.