강의

멘토링

커뮤니티

BEST
Programming

/

Database

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

Through this course, you can learn SQL and database fundamentals, SQL syntax, database design for practical applications, database utilization through programming, and data analysis use cases.

(4.8) 310 reviews

4,262 learners

Level Basic

Course period Unlimited

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

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

  • SQL syntax learned and practiced through various problems

  • Hands-on SQL Data Analysis Practice with Real Databases

  • Techniques for automatically controlling MySQL with Python

Here's a course where you can learn from database fundamentals to practical application
in a short time! 📌

The lecture chosen by top tech companies for their in-house training!
Now back with a major 3rd renewal 🥳

This is a special course created based on 8 years of teaching experience with approximately 80,000 students both online and offline. With well-organized materials, detailed explanations, and significant incorporation of previous feedback, we've renewed it three times to make it an even better course.

Database,
Do I really need to learn it? 🧐

Whether you're building web/app services or learning data analysis/data science, understanding databases is essential. This is because all data is stored and managed in databases. Especially recently, even non-developers are trending towards directly analyzing data in databases.

While there are various types of databases, the basic databases used by most companies all operate with SQL language. SQL language has various syntax, and the key competency is being able to create the SQL statements you want by utilizing various syntax.

This course is designed to start from what a database is and enable you to actually use SQL, solving SQL problems with actual business data to develop the ability to create the SQL statements you want. In addition to this, we explain how to utilize databases, covering database utilization from both data analysis and development perspectives to solidify your database fundamentals.

Goals of this course 📌

  • Build a strong foundation in SQL and MySQL through various exercises in a short amount of time.
  • Learn techniques to control MySQL through programming for database utilization.
  • Learn data analysis techniques using SQL.

What You'll Learn 📚

The best way to learn SQL is to organize SQL syntax, practice combining various syntax patterns, and do plenty of exercises creating SQL statements.

This course teaches database technology with MySQL database, the most widely used basic database. Designed for beginners, it starts with database fundamentals, progresses through various practical problems to learn complex SQL, and covers real-world SQL-based data analysis and Python-based database utilization.

MySQL Database and SQL Basics

Practice various SQL statements based on databases that can be used in practical work

How to automatically handle MySQL databases with Python programming

📢 Please note before taking the course!

  • If you want to learn how to automatically handle MySQL databases with Python programming, you'll need prior knowledge of Python and web crawling. If you don't have the relevant knowledge, we recommend taking the course below together with this one.


Course Features ✨

#1.
Beginners welcome!

This course is designed for beginners to start with the assumption that they have no knowledge of databases. It covers everything from types of databases to the essential SQL syntax needed when learning databases.

The practical SQL problems you'll learn in this course are ones that even beginners followed well in offline classes and were very satisfied with. Anyone can master them if you think through them and practice repeatedly.However, IT courses are very different from using finished products, so you need to study seriously to see results!

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

#2.
Real Database-Based
Practical Work-Oriented Course

This course provides step-by-step and technique-based lectures with various code examples and materials to help you become proficient in database utilization skills in a short time.

#3.
Practical DB-based
Problems and Solutions

Practice various SQL statements based on real databases that are actually used in companies, helping you get a feel for databases.

#4.
Systematic
Roadmap Provided

If you continue with the next course after this one, you will be able to build solid SQL skills.

Additionally, for those considering a career in backend development or data analysis/science after this course, we have opened both full-stack and data science roadmaps to help you learn systematically. You can check the complete related roadmaps below on this detailed page.


Learn Systematically
Janjaeми Coding Dave Lee's Roadmap 🔑

Developer, Data Analyst, and Data Scientist Career Roadmap!

We provide an A to Z roadmap that allows you to build a solid foundation in a short time, from web/app development to data analysis and AI. IT technologies are closely interconnected, and integrating them is essential for web/app services and data science. By gradually increasing the difficulty level and mastering core technologies, you can learn efficiently, understand systems and data comprehensively, and grow into a competitive developer or data professional. To achieve this, we have prepared a roadmap that systematically organizes the core technologies in each field.

1. The Fastest Complete Data Roadmap

We've created a video that explains this roadmap, data-related careers, and the entire data analysis/science process in detail. If you refer to this video, you can easily learn the data process in a short time without trial and error, even on your own!

Wait! ✋
Click on the roadmap below to see more details. If you purchase the roadmap all at once, it will be offered at a discounted price! (The discount rate will be reduced soon.)

2. The Fastest Full-Stack Roadmap

We've created a detailed video explaining this roadmap and how to learn and implement web/app development on your own in the fastest way possible. By referring to this video, you can implement web/apps in a short time without trial and error.

Wait! ✋
Click on the roadmap below to see more details. If you purchase the roadmap all at once, it will be offered at a discounted price! (The discount rate will be reduced soon.)

3. Essential Computer Science (CS) Core Knowledge Required for Development and Data Fields

This roadmap is a course that systematically organizes essential Computer Science (CS) knowledge, which is the core IT theory that forms the foundation of development and data fields. Among these, we are opening lectures where you can systematically learn the most important core subjects, especially computer architecture, operating systems, and networks.


Recommended for
these people

Who is this course right for?

  • Those who want to master databases

  • For those who want to learn the fundamentals of data science/full-stack

  • People who want to learn skills for using SQL in practical work

  • Those who want to learn SQL from basics to practical application

Hello
This is

33,511

Learners

2,459

Reviews

1,949

Answers

4.9

Rating

13

Courses

Janjemi Coding, Dave Lee

  • About Janjaemi Coding Introduction Blog [Click]

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

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

  • Key Development History: Samsung Pay, E-commerce search services, RTOS compiler, Linux Kernel Patch for NAS

  • Books: Linux Kernel Programming, Understanding and Developing Linux Operating Systems, IT Core Technologies for Everyone to Read and Understand, Python Programming Primer for Absolute Beginners

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

  • This site shares free resources related to full-stack development, data science, and AI.

  • Others: Fun-Coding YouTube Channel [Click]

    • I'm starting to share tips and short free lectures little by little to help with IT learning!

For eight years, I have been consistently creating solid full-stack, data science, and AI courses while balancing my work in the industry with teaching IT.

I am gradually starting to share my lectures. Balancing my current industry experience with teaching, I have been consistently creating solid full-stack, data science, and AI courses for 8 years.

Curriculum

All

42 lectures ∙ (8hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

310 reviews

4.8

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

    • suahlove899252님의 프로필 이미지
      suahlove899252

      Reviews 2

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

    • 1ddssaa님의 프로필 이미지
      1ddssaa

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

    • yeonwoo98141546님의 프로필 이미지
      yeonwoo98141546

      Reviews 1

      Average Rating 5.0

      5

      62% enrolled

    $59.40

    funcoding's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!