[A hundred words are not as good as seeing once] Intermediate SQL for data analysis

Lecture introduction

There are many SQL theory lectures, but why aren't there any lectures that allow me to develop real skills while solving problems?

Just as no matter how much you study English grammar, your English conversation skills will not improve if you don't actually have conversations,
You can't use SQL properly just by studying the grammar.

This course is helpful for those who want to immediately use SQL in their work and those who are preparing for SQL coding tests .

If you take all the SQL basics and intermediate courses, you will be able to easily solve problems at the level of Programmers' SQL High Score Kit.

You no longer need to bother sending emails.
Download it directly from Infraon!

Now you have completed all the intermediate SQL courses.
In the last lecture, 'Completion Commemorative Gift_SQL Cheatsheet'
Click the [Data] download button at the top right
You can download the CheatSheet ( see image below) .

(Not required, but thoughtful reviews and questions are always welcome!)

What to prepare before attending the lecture

The lecture is available on HackerRank ( hackerrank.com ) and leetcode ( leetcode.com ) sites.
The curriculum is structured based on problems.
Before attending the lecture, we recommend that you visit the website above, register as a member, and then take a look around the website.

Things that would be good to study together

Programmers SQL High Score Kit: https://programmers.co.kr/learn/challenges?tab=sql_practice_kit

# We are currently providing Korean subtitles to create a better learning environment .
Please note that subtitles will be uploaded to the videos in the order in which the subtitle work is completed.

# The course can be taken for 3 months. This period has been set in hopes that students will complete the course, so we recommend that you check the course period before starting to take the course.

✔️ Course Roadmap

Information on past lectures & follow-up lectures 🔖

[A hundred words are not as good as seeing once] Basic SQL for data analysis
Learn basic SQL grammar and solve real problems

[A hundred words are not as good as seeing once] Advanced SQL for data analysis
Learn various functions for advanced SQL use

[A hundred words are not as good as seeing once] Intermediate SQL problem solving for data analysis
Solve various problems using several functions

[A hundred words are not as good as seeing once] Advanced SQL problem solving for data analysis
Improve your query writing skills by solving various problems