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

Hello. This is Dave Lee from Janjaemi Coding.

With the opening of the FLUTTER lecture, we will also update and share the existing lectures. Once you take the lecture, you can continue to listen to the updated content at any time.

Introduction to Python and Crawling Bootcamp

• While crawling based on actual sites, there were cases where the code provided did not work properly because the actual sites changed frequently. I updated the lecture so that you can practice crawling based on a site that I can control directly.

• We have also updated the functionality for handling Excel with Python.

• We've made the overall difficulty level slightly higher than before, so that you can learn more functions.

From SQL/DB (MySQL) basics to Python/data analysis!

• Recently, SQL writing skills are becoming more important, to the point where SQL coding tests are even included in job applications.

• So, to practice SQL, I created a SQL problem based on the Sakila database that was used in an actual business and the database that I collected for data analysis.

• It is structured so that you can practice various SQL exercises.

• Python crawling + pymysql is explained with examples so that it can be used quickly with more concise patterned code.

I hope that these two lectures will be better lectures, and that they will be truly helpful and impressive lectures.
Additionally, the Mongodb lecture will be updated soon. I will share it with you again once the update is complete.

thank you