[Problem Solving Class] 50 SQL Queries Determined to Solve (Part 1) - Coding Test Prep

hello
My name is Joe and I work as an Inflearn knowledge sharer.

It seems like the days are getting warmer. Are you taking care of your health?
I have been avoiding writing long articles using the excuse that I am not very good at writing, but today I would like to say hello under the pretense of promoting the release of a new lecture.

This email is sent through Inflearn's student mailing list, so those of you reading this are likely those who have registered for one of my courses.

Suddenly, I checked when I opened my first lecture on Inflearn, and it turned out that I opened my first SQL lecture in the winter of December 2020. I've been running lectures for five years, so some people might not remember my nickname, or they might have registered for the lecture last month and are looking into it. But it's all okay. I'm grateful to them all, and I'm curious about how they're developing.

I have no doubt that students have experienced many changes, but the past five years have also brought about many changes for me. In the past five years, my engineer identity has become stronger than before, a book I wrote myself has been published, I have moved three times, and the company I have worked for has changed. I have created lectures, but I have also become a student of other knowledge sharers, and I think I have thought about what capabilities I should further develop.

It was probably the same when I first gave the lecture, but I didn't have high expectations at the beginning. At first, I thought I could just make the lectures that were being given offline online and organize them, but I didn't know it would last this long. I guess you never know what will happen with people.

After that, it became an opportunity for the book <Planner's SQL> to be published without a hitch, and it also gave me the strength to create other lectures. Although there were times when I stopped working for a while, I was able to continue my activities for five years thanks to the students who registered for my lectures.

What are you interested in these days, students? These days, I am interested in the changes brought about by AI. However, as I started making online lectures for the past five years, I am worried about what kind of knowledge will still be valid in the era of advanced AI. I still don't know the right answer, but I think that fundamental knowledge will continue to survive in the future. Since this is an era where questions are important, I think that the basic knowledge for asking questions will still be alive.

I'm still making lectures that I want to make, and the lecture I brought this time is a lecture that briefly explains the basics of Python grammar and uses the AI code generation IDE, Cursor, to create code directly . I think it would be good for beginners to quickly see the basics without much expectation, as it is 2 hours long, and I plan to continuously update the use cases in the future. To commemorate the release of the lecture, we are also holding a 90% discount for exactly one month, so please refer to it if you need it.

Link: https://inf.run/4HYsY

I will continue to work on finding topics that I can do well in the future and developing lectures that are easy and contain only the necessary parts. As we approach the full-blown summer, please be careful of the heat, and I will always support you so that you can gradually achieve your goals for this year.

thank you
Joe Dream

PS -1
We are planning a lecture completion challenge. If you would like to receive challenge notifications, please sign up for the waiting list below to receive notifications more quickly.

PS -2
Have you ever wanted to create a lecture?
I am thinking about running a challenge where I can help people who want to experience creating lectures. If you are interested in creating lectures, please register on the waiting list below.

Register for the challenge waiting list:

https://forms.gle/E3gCL3onxjdh6YDr9

hello.

This is Joe, running a data lecture.

Today, in the irregular newsletter, I am sharing with you the information I found out after seeing the emergence of AI and the recent active research on libraries such as Text-To-SQL, wondering , "What is the overseas data scene doing now?"

This article is a translation and summary of Datacamp's Data & AI Trends & Predictions 2025 White Paper.

2025, 5 Key Trends in Overseas Data Scene AI & Data

1. The boundaries between data professions are blurred.

As AI automates SQL and data analytics tasks, the traditional role distinctions between data analysts, engineers, and data scientists are blurring.

Now, all professions must be able to handle data, and data literacy (the ability to read and utilize data) is becoming more important.

2. AI research continues to advance, but actual adoption is slow

AI models are becoming more powerful, but actual adoption of AI within enterprises remains slow

It is predicted that more than 30% of Generative AI projects will be abandoned by 2025 (Gartner)

The key task is not simply to improve AI model performance, but how to link it with actual business processes.

3. The differentiating point of AI tools will be the user experience (UX).

As the performance gap between AI models narrows, user experience (UI/UX) and actual usability become more important competitive factors.

AI research labs are thinking about how to make it more intuitive and easier to use.

The goal is to make AI an essential tool for business operations, not just a technology.

4. AI & Data Skills Gap is still a major issue

The gap in AI and data utilization capabilities remains a major issue within companies

For companies, educating employees to handle AI and data is becoming a more urgent task than introducing AI.

5. In an era where AI writes SQL instead, data literacy becomes important.

As AI-based Text-to-SQL technology advances, data extraction through SQL becomes easier

However, this does not mean that you do not need to know SQL, but rather that the ability to interpret and utilize SQL has become more important.

AI generates and interprets SQL, but it’s still up to humans to plan what data to analyze

source:

https://www.datacamp.com/report/data-trends-predictions-2025

Thank you for reading.

Joe Dream

@Thread: https://www.threads.net/@breachers_data

@Instagram: https://www.instagram.com/breachers_data

hello!

I'm Joe, running a data course at Inflearn.

“Are there people who are worried that they won’t be able to finish the lecture if they listen to it alone?”

If there are people who have applied for the problem-solving class (Part 1) and are wondering when to take it,

How about solving a problem with other students this January to welcome the new year?

Please refer to the information below to apply for the Moon-Pulp Study Group and have a great January!

1. Instructions for the 1st term of the Moon-Pulp Class Progress Management Study (Applications accepted until ~1.4)

   1. Recruitment target: Learners who have applied for the problem-solving lecture

   2. Study Objective: Solve all the problems in the Problem Solving Lecture (Part 1) during the 4th session and complete the certification!

   3. Verification method: Verification within a set period of time in a private study group channel in Discord (verification method will be announced later)

   4. Schedule: A total of 4 times (Monday, January 6 - OT, Monday, January 13, Monday, January 20, Monday, January 27, Certification standard date and time 22:00)

      1. After the application deadline, applicants will be individually informed of the details before the start (details are subject to change)

   5. How to apply: Apply through the link below

      1. Application link: https://forms.gle/KTfTUbezJGh6ceMY8

2. Community Opening Guide

   1. We've prepared a Discord server for study and lecture-related communication!

      1. Link: https://discord.gg/V6HTP66G

   2. Information sharing, etc. will take place in the new Discord community. (The existing Slack community will be shut down.)

thank you

Joe Dream