Introduction to Data Analysis Using SQL

(1) Course Outline

 We often hear about big data in recent years as various data are accumulated year by year. In order to utilize this big data for various research periods and businesses, it is important to construct a data infrastructure to format and store the data. The knowledge and skills to construct this data infrastructure are considered important in various fields, as is the existence of the job title of data engineer, and it is one of the knowledge that students should learn. In this lecture, students will learn a series of data application flows using SQL through hands-on activities in five sessions, and learn the basics for promoting data application in the future as well as the usefulness of data application.

(2) Content of each session (up to 10 sessions)

Basically, each session will provide an opportunity to talk in groups.

Session 1: Introduction to SQL Practice 1 10/12

In the first half of the class, we will start from what is data utilization in the first place. The first half of the class will begin with an explanation of what is data utilization in the first place, followed by a light explanation of data handling and the construction of an analytical infrastructure. In addition, we will explain what SQL is, which we will cover in future classes. After that, students will learn and practice the basic forms of SQL: SELECT, FROM, and WHERE.

Session 2: Introduction to SQL Practice 2 10/19

Students will review the exercises of the first session and continue to learn how to use data as in the first session. After that, students will learn how to use aggregate functions in SQL, which are also used in Excel and are commonly used in any form of SQL. Then, students will learn and practice GROUP BY for grouping, ORDER BY for sorting, and other essential knowledge to use aggregate functions.

Session 3: Introduction to SQL Practice 3 10/26

Data in the world is not formed by a single table alone. In the third lesson, after reviewing the first and second lessons, you will learn how to join new data and data, how to use many tables at the same time, how to view data when using many tables, how to simplify data extraction, and how to use special SQL functions such as Limit, Having, and so on. In addition, participants will learn how to use SQL for special situations such as Limit, Having, etc., and practice using them.

Session 4: Data Utilization Practice Elementary Data Infrastructure Construction 11/2

In the data utilization flow explained in the first lecture, students will practice building a data infrastructure for analysis using sample data. In the lecture, the flow of building a data infrastructure using SQL learned in the first through third lectures will be practiced, and hands-on training will be conducted while simultaneously executing and explaining sample code using Python distributed at the same time.

Session 5: Data Visualization and Utilization (Beginner’s Level) 11/9

Based on the data infrastructure created in the 4th lecture, participants will practice data visualization and utilization. Participants will experience the flow of data visualization and fully utilize SQL learned in the first three sessions to visualize data using SQL.