[Renewal] First-time SQL and Database (MySQL) Bootcamp [From Beginner to Application]

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.

This time, we are sharing a new lecture that we opened on Infraon.

• Intermediate-Advanced SQL and Real-World Data Analysis 101 Problem Solving ( https://inf.run/3PUZ2)

This course is designed to help you learn intermediate and advanced SQL grammar that can be used immediately in the workplace, and to strengthen your practical skills through solving various problems using actual business data. We have reconstructed the online course by including only the core contents that received good feedback from students in the data analysis boot camp and offline lectures conducted over the years. Since most of the existing students have improved their skills to the point where they can immediately perform real-world projects as data experts, it will be of great help to those who want to improve their practical SQL skills.

We opened at a low price so that many people can take the course without burden, and we also applied a 30% discount to commemorate the opening.

Recommended for:

- People who want to learn SQL data analysis in the field

- Those who want to develop solid SQL skills

- People who want to solve various problems in preparation for SQL coding tests

- For those who want to solidify SQL for advanced development

Advantages of the course:

- Acquire intermediate to advanced SQL grammar

- Learn various intermediate to advanced SQL grammar, including function utilization, subqueries, set operations, transactions, VIEW and WITH clauses, and window functions.

- Strengthening capabilities through practical problems

- Develop problem-solving skills by combining various SQL grammars through a total of 101 practical problems .

- Practice writing queries, starting from simple one-line queries to complex queries of nearly 100 lines.

This will help you acquire the level of SQL data analysis skills required in the field, and will also be of great help in preparing for SQL coding tests.

The most widely used data analysis technology in the field is SQL . This is because in order to efficiently handle large amounts of data, SQL is often used to directly analyze the database.

This lecture has been added to the fastest data full course roadmap (https://www.inflearn.com/roadmaps/66) roadmap to help you further strengthen your capabilities as a data analyst and scientist. As it has been added to the roadmap, we have also applied a discount so that you can purchase related lectures at a discounted price.

If you take this lecture after taking the lecture below, you can further solidify your SQL skills.

• Beginner SQL and Database (MySQL) Bootcamp [From Beginner to Utilization] (Updated) (https://inf.run/4Sku)

I hope that this lecture and its related roadmap will be helpful to those who are learning about the data field and will be a great help in achieving your goals.

thank you

Remnant fun coding Dave Lee Dream