inflearn logo

[Renewed] First-Time SQL and Database (MySQL) Bootcamp [From Beginner to Practical Applications]

Through this course, you will learn about SQL and databases, SQL syntax, database design for practical use, how to use databases through programming, and real-world applications of data analysis.

(4.8) 325 reviews

4,351 learners

Level Basic

Course period Unlimited

Python
Python
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
Data Engineering
Data Engineering
Python
Python
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
Data Engineering
Data Engineering

Reviews from Early Learners

4.8

5.0

최보옥 (Amy)

62% enrolled

I attended without any SQL knowledge at all, but I was able to follow the class without any problems, which is great! Before taking the class, I thought it would be really difficult, but now I feel confident that I can complete the entire course!

5.0

화리둥절

81% enrolled

This is a very sufficient lecture to learn how to use basic SQL! If you want to do coding tests or solve more in-depth problems, I recommend moving on to the intermediate-advanced SQL lecture!

5.0

검냥이

100% enrolled

This is a lecture that I learned a lot from because you explained the definition systematically and fundamentally. After completing the course, I immediately applied for the Intermediate and Advanced SQL and Practical Data Analysis 101 Problem Solving [Data Analysis/Science Part1]. Thank you.

What you will gain after the course

  • Learn and practice SQL syntax through a variety of problems

  • Practical SQL Data Analysis Practice with a Real Database

  • Technology for automatically controlling MySQL with Python

Recommended for
these people

Who is this course right for?

  • Those who want to conquer databases

  • Those who want to learn the fundamentals of data science/full-stack development

  • Those who want to learn practical SQL skills.

  • Those who want to learn SQL from the basics through practical applications

Hello
This is funcoding

Inflearn Verified

Career Verified

34,479

Learners

2,592

Reviews

1,952

Answers

4.9

Rating

13

Courses

Janjemi Coding, Dave Lee

  • About Janjaemi Coding Introduction Blog [Click]

  • Key Experience: Coupang Senior Development Manager/Principal Product Manager, Samsung Electronics Development Manager (Approx. 15 years of experience)

  • Education: BA in Japanese Language and Literature, Korea University / MS in Computer Science, Yonsei University (A complete mix)

  • Key Development Experience: Samsung Pay, E-commerce Search Service, RTOS Compiler, Linux Kernel Patch for NAS

  • Books: Linux Kernel Programming, Understanding and Developing the Linux Operating System, IT Core Technologies That Anyone Can Easily Read and Understand, Python Programming Primer for Absolute Beginners

  • Operating Site: Fun-Coding (http://www.fun-coding.org) [Click]

  • This is a site that shares free materials related to full-stack development, data science, and AI.

  • Others: Fun-Coding YouTube Channel [Click]

    • I am starting little by little to share tips and short free lectures that are helpful for IT learning~

While working in the industry, I have been consistently creating solid full-stack, data science, and AI courses for 8 years.

 

More

Curriculum

All

42 lectures ∙ (8hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

325 reviews

4.8

325 reviews

  • suahlove899252님의 프로필 이미지
    suahlove899252

    Reviews 4

    Average Rating 5.0

    5

    84% enrolled

    Rather than boring theoretical content, it was very helpful that it explained in detail and step-by-step with many examples how to utilize and use it in practice!

    • funcoding
      Instructor

      Thank you for your valuable opinions and reviews~^^

  • analyticsstory3557님의 프로필 이미지
    analyticsstory3557

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    I heard it well.

    • pjhji2028034636님의 프로필 이미지
      pjhji2028034636

      Reviews 1

      Average Rating 5.0

      5

      92% enrolled

      This course helped me a lot by giving me a solid foundation in SQL. Thank you!

      • funcoding
        Instructor

        Oh thank you~~~

    • sdjdr878416님의 프로필 이미지
      sdjdr878416

      Reviews 1

      Average Rating 1.0

      1

      100% enrolled

      - The lecture was boring because it covered the basic concepts. - The lecture uses various programs, but the programs used in the previous lecture, current lecture, and next lecture are different from each other, so there is an inconvenience of having to open multiple programs at once. - Python uses an Interpreter, but the lecture misunderstood that it uses a Compiler, which was confusing. - The lecturer kept advertising Python lectures, which was confusing. - When crawling the Gmarket best-seller page, the internal structure of best_item has changed, but the lecture video uses the old code, which did not match the initial statement that "continuous updates will be made", so it was unreliable. - The misunderstanding that NaN and Null are the same was confusing.

      • funcoding
        Instructor

        Hello, this is Answer Helper. Soyun, this is a real site, so changes may occur frequently. I really wanted to give you a more realistic explanation with the real site. Also, we are updating the changed parts as quickly as possible with the data. Of course, the program must run mysql and the editor, but Python-based lectures only use Jupyter Notebook. We do not use different tools without special reasons. Most people know that Python is an Interpreter, so it seems difficult to understand this part. This lecture is for those who do not know MySQL, so it seems right to structure the lecture so that you can understand it from the beginning. However, if you do not know Python, the latter part may be difficult, so we have provided separate guidance for Python lectures for those who do not know Python. I think we should not make SQL lectures assuming that you know SQL to some extent like Soyun. Many people have already taken this lecture, so if there are any issues, the feedback may not have been good, so if there are any actual issues, please let me know and I will update it right away. This lecture is a continuation of the main lecture and the more complex machine learning deep learning lecture, so if the difficulty is adjusted step by step and the basic techniques are explained incorrectly, it would have been an issue since several years ago. If you have any difficulties, we will do our best to help you, so please do not misunderstand it too much.

    • generalcode님의 프로필 이미지
      generalcode

      Reviews 21

      Average Rating 4.4

      1

      100% enrolled

      It was generally good, but I was disappointed that it only covered easy content. I wish it had been a lecture that systematically covered normalization, denormalization, and design, even if it raised the price. There was nothing worth learning about normalization, denormalization, and design. But other than that, it was helpful.

      • funcoding
        Instructor

        Yes! I will update it after referring to your opinion.

    funcoding's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!

    25% off for new members

    $49.40

    25%

    $59.40