Intermediate-Advanced SQL and Practical Data Analysis: 101 Problem Solutions

Hello. This is Dave Lee from Janjaemi Coding.

The reason is that we have opened a new lecture and are sharing it with you briefly.

• Computer Science (CS Knowledge) Bootcamp for Beginners | Computer Architecture, Operating Systems, Networks (CS Knowledge Part 1)

This lecture systematically organizes the core of computer engineering (CS knowledge) that developers or data specialists preparing for careers or working in the field must know. Among the various subjects of computer engineering (CS knowledge) , three subjects were organized into one lecture so that you can efficiently learn the important computer structure, operating system, and network . In addition, to prepare for technical interviews, the core technical interview questions for each subject, special answer methods, and model answers were included.

Computer science knowledge is essential foundation knowledge in the development and data fields, but its importance is often overlooked. I also emphasize to my acquaintances and family that if you are preparing to become a developer or data specialist, you should definitely learn this theory, which is absolutely necessary in the mid- to long-term .

However, many people have difficulty organizing it into individual subjects because of the large volume. To solve this difficulty , the content has been neatly organized in the form of online lectures . While covering key concepts in depth, various explanation methods have been used to help with clear understanding .

This is a proven lecture that has been selected by tens of thousands of students and used as a training material for new employees by leading domestic IT companies, after being reworked several times over the past five years. This time, it has been reworked and improved and opened again. I hope it will be helpful.

We've also included a new opening discount.

thank you

Remnant fun coding dream

Hello. This is Dave Lee from Janjaemi Coding.

I am sharing the lectures lightly by renewing them. It is a continuation of the lectures that were renewed just before.

• [Renewal] Python Data Analysis for Beginners (Easy! Learn Preprocessing, Pandas, and Visualization) [Data Analysis/Science Part 1]

• [Renewal] Python Machine Learning Bootcamp for Beginners (Easy! Organize by Solving Real Kaggle Problems) [Data Analysis/Science Part 2]

The following lectures have been renewed.

• [Renewal] Introduction to Python Backend and Web Technology for Beginners (Intermediate Python, Basics of Backend and Web Technology with Flask) [Full Stack Part 1-1]

The existing Python Backend and Web Technology Bootcamp course titles have also been changed to match the purpose of the course, which is to organize the core web technology concepts, intermediate Python grammar, and backend basics that must be understood for full-scale development . The course content has been improved to reflect the latest trends and the fastest full-stack development architecture .

Through this course, you can effectively learn Python intermediate grammar (including intermediate object-oriented) essential for practical development, web/app core concepts, and the latest full-stack architecture. Those who have already taken the course can listen to it again. Updated videos are marked with (updated) in the chapter name, so that those who have already learned can check only the updated parts. We will continue to provide a satisfactory learning experience through continuous updates.

Just like this lecture, I will continue to improve other lectures in the future.

I hope the related lectures will be helpful to you.

thank you

Hello. This is Dave Lee from Janjaemi Coding.

I've renewed the lecture and am sharing it with you in a lighter way.

Following the lecture that was just renewed
[Renewal] Python Data Analysis for Beginners (Easy! Learn Preprocessing, Pandas, and Visualization) [Data Analysis/Science Part 1]

The following lectures have been renewed.

[Renewal] Python Machine Learning Bootcamp for Beginners (Easy! Solve actual Kaggle problems and organize them) [Data Analysis/Science Part 2]

We have improved the parts that seemed lacking in the existing lectures and improved them to match the latest libraries. We have also improved the lectures by adding stories from a more practical perspective. Those who have already taken the lectures can listen to them again.

Just like this lecture, I will continue to improve other lectures in the future.

I hope the related lectures will be helpful to you.

thank you

Hello. This is Dave Lee from Janjaemi Coding.

I've renewed the lecture and am sharing it with you in a lighter way.

This is a lecture that many people have taken and liked. We have renewed the following lecture, which contains functions for preprocessing, analyzing, and visualizing data based on Python. We have improved the parts that seemed lacking in the existing lecture, and in the data field, there are cases where the grammar is different depending on the library version. We have improved it to match the latest library. We have also improved the lecture by adding stories from a more practical perspective. Those who have already taken the lecture can listen to it again.

[Renewal] Python Data Analysis for Beginners (Easy! Learn Preprocessing, Pandas, and Visualization) [Data Analysis/Science Part 1]

Just like this lecture, the next lecture is also scheduled to be renewed by the end of this month, and we will continue to improve other lectures in the future.

Beginner Python Machine Learning Bootcamp (Easy! Organize by Solving Real Kaggle Problems) [Data Analysis/Science Part 2]

I hope this will be helpful to those who are interested in related lectures.
thank you

Hello. This is Dave Lee from Janjaemi Coding.

Although it's late, Happy New Year. I heard that many non-majors are wondering what direction they should prepare for data-related careers (data analysts, data scientists, etc.).

So, I created a YouTube video on the fastest way to prepare for each situation for non-major workers, college students (new hires, 3rd or 4th year students), and graduates (job seekers).

Personally, I think that the data field is a good field to prepare for not only a data career, but also AI agent-based AI service development, which has recently become a hot topic. If you are interested, I hope the related video will be helpful.

thank you

Hello, this is Dave Lee from Janjaemi Coding.

In relation to the newly shared SQL learning roadmap, we have prepared a small event that can enhance the learning effect. Since it is a small event, the deadline is the end of November.

• SQL Ending (w/Fun Coding) :https://www.inflearn.com/roadmaps/6724

We have prepared dedicated GPTs to help you deeply understand SQL and organize it systematically. These GPTs provide detailed explanations and additional examples based on the main contents of the two lectures, and support more in-depth learning through lectures and customized answers. We hope that it will be a useful tool for learning SQL.

Participating in the event is simple. If you found the lecture helpful, please leave a review for each lecture and send an email to dream@fun-coding.org . We will share the GPTs link within two days, excluding weekends. ChatGPT free users can also log in and use it. There may be some restrictions on the number of questions in the free plan, but it is sufficient for learning. Paid users can use it without restrictions.

• [2024 Renewal] Beginner SQL and Database (MySQL) Bootcamp [From Introduction to Utilization]

• [2024 New Lecture] Intermediate-Advanced SQL and Practical Data Analysis 101 Problem Solving [Data Analysis/Science Part 1]

I hope this will be a good learning opportunity for anyone who wants to organize SQL systematically.

thank you

Hello, this is Dave Lee from Janjaemi Coding.

This time, we've prepared a new roadmap for learning SQL and are sharing it with you!

• SQL Ending (w/Fun Coding) :https://www.inflearn.com/roadmaps/6724

SQL is an essential tool in both data and development. Recently, SQL coding tests are increasing, but many people find it difficult to write the desired query by combining various grammars and concepts as they thought. The fastest way to effectively master SQL is to solve real problems and gain experience writing various queries.

This roadmap covers everything from basic database concepts to basic and intermediate SQL grammar, and is designed to help you systematically organize SQL through 101 practical problems. The following two lectures are bundled together and have a 30% discount, so we recommend them to anyone who wants to solidify their SQL.

• [2024 Renewal] Beginner SQL and Database (MySQL) Bootcamp [From Introduction to Utilization]

• [2024 New Lecture] Intermediate-Advanced SQL and Practical Data Analysis 101 Problem Solving [Data Analysis/Science Part 1]

I hope this will be helpful to those who want to organize SQL systematically.

thank you

Hello. This is Dave Lee from Janjaemi Coding.

I have updated the material as there is a minor data update.

When using ORDER BY in SQL's window function , the basic frame is RANGE as the default. Therefore, as explained in the lecture, RANGE is the default. However, there was a part in the data where I made a mistake and wrote ROWS as the default. Thanks to the person who reported it, I was able to confirm the relevant part. Thank you.

I have also updated the relevant materials. If there are any issues since it is still early, please let me know at dream@fun-coding.org and I will check. However, I am currently on a business trip abroad, so I will check by the end of this week.

thank you

Remnant fun coding Dave Lee Dream