[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,352 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

A course where you can learn everything from database fundamentals to practical applications
in a short time is here! 📌

The course chosen for in-house training by Naver, Kakao, Line, Coupang, and Baemin!
Back with a major third revamp 🥳

This special course was created based on eight years of experience teaching approximately 80,000 people both online and offline. We revamped it three times, incorporating well-organized materials, detailed explanations, and extensive feedback from previous versions to make it an even better course. 

Databases,
Do you really need to learn them? 🧐

Whether you are building web or app services or learning data analysis/data science, understanding databases is essential. This is because all data is stored and managed in databases. In particular, even non-developers have recently begun analyzing data in databases themselves.

Although there are various types of databases, the basic databases used by most companies all operate with the SQL language. SQL has a variety of syntax, and the key is developing the ability to use various syntax to create the SQL statements you want.

Starting with what a database is, this course is designed to help you actually use SQL by solving SQL problems with real business data and developing the ability to create the SQL statements you want. In addition, it explains how to use databases from both data analysis and development perspectives, helping you firmly build a foundation in databases.

The Goal of This Course 📌

  • Build a solid foundation in SQL and MySQL through a variety of exercises in a short amount of time.
  • Learn how to control MySQL through programming to make use of databases.
  • Learn data analysis skills using SQL.

You'll learn these things 📚

The best way to learn SQL is to organize SQL syntax, combine various syntax elements, and practice creating SQL statements extensively.

This course teaches database technologies using the MySQL database, one of the most widely used basic databases. Designed for beginners, it starts with the fundamentals of databases, progresses to complex SQL through a variety of practical problems, and covers practical SQL-based data analysis as well as Python-based database utilization.

MySQL Database and SQL Basics

Practice various database-based SQL statements that are likely to be used in real-world work.

How to automatically manage a MySQL database using Python programming

📢 Please note before enrolling!

  • To learn how to automatically work with MySQL databases using Python programming, you need prior knowledge of Python and web scraping. If you don’t have relevant knowledge, we recommend taking the following course alongside this one.

Course Features ✨

#1.
Beginners are welcome!

This course is designed to be accessible to beginners, starting from the assumption that you have no prior knowledge of databases. It covers everything from the types of databases to the essential SQL syntax you need to learn databases.

The practical SQL problems covered in this course were well received by beginners in the offline classroom, who were able to follow along and were highly satisfied. Anyone can learn them with enough thought and repetition. However, since IT courses are very different from simply using a finished product, you need to study seriously to see results!

프로그램 설치부터 함께해요!

#2.
Based on a real database
A hands-on, practical course

This course provides lectures based on various code examples and materials, organized by level and technology, so you can become familiar with database usage techniques in a short time.

#3.
Real-world DB-based
problems and solutions

By practicing various SQL syntax using real-world databases that can be used in actual companies, we’ll help you develop a feel for databases.

#4.
A systematic
roadmap

If you continue with the following courses after this one, you can develop solid SQL skills.

Additionally, for those considering careers in backend development or data analysis/science after completing this course, we have also made both the Full-Stack Roadmap and the Data Science Roadmap available so that you can learn systematically. You can find the complete relevant roadmaps below on this course detail page.


Learn systematically
Dave Lee's roadmap from Fun Coding

Following this course, AI, development, data, and computer science roadmaps you can learn according to your goals

IT technologies are interconnected.
By selectively learning connected technologies and adding AI to the mix, you can reach your goals much faster.

Every roadmap covers how to connect and use technologies together,
is designed to increase in difficulty from beginner level to expert level, and
is continuously updated over the years.

It is also more discounted than taking the courses individually.

3. Fundamentals of development and data, and core computer science (CS) knowledge

From computer architecture, operating systems, networks, system software, software engineering, and architecture to data structures and algorithms

← Swipe left and right to explore the CS courses and the full roadmap →

View the full computer science roadmap in detail

4. The Most Reliable Ultimate AI Utilization Roadmap (2026)

From Claude Code workflow automation to vibe coding, Codex, OpenClaw, Claude Code–based data analysis, advanced Claude Code techniques such as agentic, harness, and loop engineering, and AI agent development

← Swipe left and right to explore AI courses and reference courses →

View the most reliable and powerful AI utilization roadmap (2026) in detail

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,485

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~^^

  • 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~~~

  • analyticsstory3557님의 프로필 이미지
    analyticsstory3557

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    I heard it well.

    • 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.

    • 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.

    funcoding's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!