SQL problem solving for data analysis (Advent of SQL 2024)
Solve 25 SQL problems of various difficulty levels. This is the Advent of SQL 2024 explanation lecture. Upon finishing the lecture, you can complete the Advent calendar and obtain a badge.
887 learners
Level Intermediate
Course period Unlimited
News
5 articles
Hello, Datarian has prepared an appreciation event to celebrate its 5th anniversary.
At the SQL Data Analysis Camp, where you can learn the most commonly used data analysis frameworks in practice through SQL, you can enroll at a 50% discount if you apply now.
If you've been thinking that you can no longer put off applying data analysis to your work!
Enroll now and learn directly from data analysts who have worked at Coupang, Ridi, and JobPlanet.
Go to SQL Data Analysis Camp (50% discount, until midnight tonight)
SQL Data Analysis Camp | After taking this package, you will be transformed like this
✔ Why did our company's sales drop? You can analyze it yourself using SQL.
✔ You can perform RFM customer segmentation analysis by identifying customers who have made large or frequent purchases in our service.
✔ You can perform funnel analysis to see how users entered through marketing and what purchase conversions were made.
✔ You can obtain and check user retention rate data through retention analysis.

Hello, Datarian has prepared an appreciation event to celebrate its 5th anniversary.
At the SQL Data Analysis Camp, where you can learn the most commonly used data analysis frameworks in practice through SQL, you can enroll at a 50% discount if you apply now.
If you've felt that you can no longer put off applying data analysis to your work!
Sign up now and learn directly from data analysts who have worked at Coupang, Ridi, and JobPlanet.
Go to SQL Data Analysis Camp (50% discount, ~4/30)
SQL Data Analysis Camp | After taking this package, you will be transformed like this
✔ Why did our company's sales drop? You can analyze it yourself using SQL.
✔ You can perform RFM customer segmentation analysis by identifying customers who have purchased a lot or frequently from our service.
✔ You can perform funnel analysis to see how users entered through marketing and what purchase conversions were made.
✔ You can obtain and check user retention rate data through retention analysis.

I need to build a portfolio, but where on earth can I get actual user data?
For those who have heard that you can collect and analyze user data yourself in GA4, but are getting stuck right from the installation stage,
We have prepared a free hands-on seminar where you can personally go from 'GA4 installation to data verification' in just 2 hours.
✔ Possible to install GA4 without development knowledge
✔ Configure a data collection environment with just a few clicks
✔ Check data after connecting to Tistory
📅 4/14 (Tue) 7 PM - 9 PM, ZOOM Online
If you have any friends or acquaintances who might need this seminar, please share the news with them :)


The Data Next Level Challenge (Data Level Challenge), a challenge for reading and recording recommended books related to data analysis, has returned for its 5th cohort.
This recommended book is the 12th Brunch Award 🏆 winner "UX Emerged After Data Struggles."

This book is a secret manual that generously shares the know-how of working in a data-driven way from a 17-year veteran product designer—insights that can only be provided by someone who has directly experienced hands-on work in the field.
Less than 50 days left in 2025! If you want to spend it meaningfully and productively, join us with Devel Challenge 🥰
📚 DevChall 5th Cohort Recommended Books
∙ 『UX Emerged After Data Struggles』 _ Written by Lee Mi-jin (Ranran)
✔ We recommend this challenge for these people
∙ Those curious about why designers, planners, and marketers need to understand data∙ Those who want to know specific methods for working in a data-driven way
∙ Those who want to spend the remaining 2025 meaningfully📌 How to Apply for the Challenge (Free, Application Deadline 11/23)
∙ https://dub.sh/5Qy11p6If you have colleagues or friends around you who want to start studying data analysis, please share the news about this challenge.
I'd like to share information about the free GA4 Hands-On Seminar that will be held next Tuesday evening.
I've prepared this for those who have resolved to learn GA4 this year but haven't started yet.

In just 2 hours at the seminar, you can install GA4 on your blog and check real-time data yourself.
✔ GA4 can be installed without development knowledge
✔ Hands-on, hands-on training with simple setup in just a few clicks
✔ Install GA4 on your Tistory blog and check real-time data
✔ You can ask practitioners directly about your GA4-related questions in the Q&A session.
📅 Seminar Information
• Event Date: 7/15 (Tue) 7:00 PM - 9:00 PM
• Location: Zoom Online
• Cost: Free
If you have a teammate or acquaintance who might need a seminar, please share the news with them :)

