강의

멘토링

커뮤니티

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) 309 reviews

4,258 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,496

Learners

2,457

Reviews

1,949

Answers

4.9

Rating

13

Courses

잔재미코딩, Dave Lee

  • About 잔재미코딩 소개 블로그 [클릭]

  • 주요 경력: 쿠팡 수석 개발 매니저/Principle Product Manager, 삼성전자 개발 매니저 (경력 약 15년)

  • 학력: 고려대 일어일문 / 연세대 컴퓨터공학 석사 (완전 짬뽕)

  • 주요 개발 이력: 삼성페이, 이커머스 검색 서비스, RTOS 컴파일러, Linux Kernel Patch for NAS

  • 저서: 리눅스 커널 프로그래밍, 리눅스 운영 체제의 이해와 개발, 누구나 쓱 읽고 싹 이해하는 IT 핵심 기술, 왕초보를 위한 파이썬 프로그래밍 입문서

  • 운영 사이트: 잔재미코딩 (http://www.fun-coding.org) [클릭]

  • 풀스택/데이터과학/AI 관련 무료 자료를 공유하는 사이트입니다.

  • 기타: 잔재미코딩 유투브 채널 [클릭] 

    • IT 학습에 도움이 되는 팁/ 짧은 무료 강의를 공유하고자, 조금씩 시작하고 있습니다~

최신 현업과 IT 강의를 병행하며, 8년째 꾸준히 견고한 풀스택, 데이터과학, AI 강의를 만들고 있습니다.

 

Curriculum

All

42 lectures ∙ (8hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

309 reviews

4.8

309 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!