Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
BEST
Programming

/

Database

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

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

(4.8) 278 reviews

4,147 learners

  • funcoding
Python
SQL
MySQL
DBMS/RDBMS
Data Engineering

Reviews from Early Learners

What you will learn!

  • Diverse Problem SQL Syntax Practice

  • Practical SQL Data Analysis: Real Database Practice

  • Python Automated MySQL Control Technology

From the basics to the use of databases
Here's a course you can learn in a short period of time! 📌

The lecture that Nekarakubae chose as an in-house lecture!
We're back with our third major renewal 🥳

This lecture is a special lecture based on the experience of teaching about 80,000 people online and offline for 8 years. It has been renewed three times to make it a better lecture by reflecting well-organized materials, detailed explanations, and previous feedback.

database,
Do I really need to learn it? 🧐

Whether you are creating a web/app service or learning data analysis/data science, understanding databases is essential. This is because all data is stored and managed in databases. In particular, there is a recent trend of non-developers directly analyzing data in databases.

There are many different types of databases, but the basic databases used by most companies all operate on the SQL language. The SQL language has various grammars. The key is the ability to create the SQL statements you want by utilizing various grammars .

This course starts with what a database is, and is designed to help you solve SQL problems with real business data so that you can develop the ability to create the SQL statements you want. In addition, it explains how to utilize a database, and how to utilize a database in terms of data analysis and development, so that you can solidify your database fundamentals .

Objectives of this lecture 📌

  • Build your SQL and MySQL fundamentals through a variety of exercises in a short period of time.
  • Learn techniques for controlling MySQL through programming to utilize the database.
  • Learn data analysis techniques using SQL.

Learn things like this 📚

The best way to learn SQL is to organize SQL grammar and practice combining various grammars to create SQL statements.

This course is designed to learn database technology with MySQL database , the most commonly used basic database. It starts with the basics of database for beginners, and teaches complex SQL through various practical problems, and is designed to help learn practical SQL-based data analysis and Python-based database utilization.

MySQL Database and SQL Basics

Practice various database-based SQL statements that can be used in practice.

How to automatically handle MySQL database with Python programming

📢 Please read before taking the class!

  • If you want to learn how to automatically handle MySQL databases with Python programming, you need to have prior knowledge of Python and crawling. If you do not have the relevant knowledge, we recommend taking the following lectures together.


Lecture Features ✨

#1.
OK even for beginners!

This course is designed so that even beginners can take it, assuming they have no knowledge of databases. It covers everything from the types of databases to the main SQL grammar that is essential when learning databases .

The practical SQL problems learned in this course are the ones that beginners can easily follow and are very satisfied with in offline lectures. Anyone can learn it if they think about it and repeat it. However, IT lectures are a very different field from using finished products, so you have to learn them seriously to be effective!

Let's start with installing the program!

#2.
Based on actual database
Practical lectures

This course provides a variety of code and data-based lectures by step/technology so that you can become familiar with database utilization technology in a short period of time.

#3.
Based on real DB
Problems and solutions

We'll help you get a feel for databases by practicing various SQL statements based on real databases that can be used in real companies.

#4.
Systematic
Presenting a roadmap

If you continue to the next lecture after this one, you will be able to acquire solid SQL skills.

Also, for those who are considering a backend or data analysis/science career after this lecture, we are opening up both the full stack roadmap and the data science roadmap so that you can learn systematically. You can check the entire related roadmap at the bottom of this detailed page.


Learning systematically
The Roadmap of Dave Lee's Residual Fun Coding 🔑

Developer, Data Analyst, and Data Scientist Career Roadmap!

From web/app development to data analysis and AI, we provide an A to Z roadmap that allows you to build a solid foundation in a short period of time. IT technologies are closely linked to each other, so they must be integrated to enable web/app services or data science. By gradually increasing the difficulty and mastering core technologies, you can learn efficiently and understand the system and data in general, and grow into a competitive developer or data expert. To this end, we have prepared a roadmap that systematically organizes core technologies in each field.

1. The fastest data-to-process roadmap

I have created a video that explains in detail about this roadmap and the entire data analysis/science process. If you refer to the video, you can easily learn the data process without trial and error in a short period of time on your own !

Wait! ✋
Click on the roadmap below for more details. If you purchase the roadmaps all at once, they are available at a discounted price! (The discount will be reduced soon.)

2. The fastest full-stack roadmap

I have created a video that explains in detail the roadmap and the fastest way to learn and implement web/app development on your own. If you refer to this video, you can implement web/app without trial and error in a short period of time.

Wait! ✋
Click on the roadmap below for more details. If you purchase the roadmaps all at once, they are available at a discounted price! (The discount will be reduced soon.)

3. Core computer science (CS) knowledge essential in development and data fields

This roadmap is a course that systematically organizes the essential knowledge of computer engineering (CS), which is the core IT theory that is the basis of development and data fields. Among these, we are opening lectures that can systematically learn the most important core subjects such as computer structure, operating system, and network.


Recommended for
these people

Who is this course right for?

  • Those who wish to master databases

  • Those who want to learn Data Science/Full Stack basics

  • Those wishing to learn practical SQL skills

  • SQL Learners: From Basics to Application

Hello
This is

32,189

Learners

2,228

Reviews

1,947

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

278 reviews

4.8

278 reviews

  • Jaeha Jung님의 프로필 이미지
    Jaeha Jung

    Reviews 2

    Average Rating 5.0

    5

    100% enrolled

    잘 들었습니다.

    • pjhji202803님의 프로필 이미지
      pjhji202803

      Reviews 1

      Average Rating 5.0

      5

      92% enrolled

      SQL의 기본을 단단히 채워주는 수강이여서 많은 도움되었습니다. 감사합니다!

      • 잔재미코딩 DaveLee
        Instructor

        앗 감사합니다~~~

    • Dash Choi님의 프로필 이미지
      Dash Choi

      Reviews 2

      Average Rating 5.0

      5

      84% enrolled

      지루한 이론적인 내용보다는 실무에서 어떻게 활용 및 사용해야 되는지를 많은 예제를 통하여 너무나도 차근차근 섬세하게 알려주셔서 많은 도움이 되었습니다!

    • jslee님의 프로필 이미지
      jslee

      Reviews 1

      Average Rating 5.0

      5

      31% enrolled

    • wkdtl345님의 프로필 이미지
      wkdtl345

      Reviews 8

      Average Rating 5.0

      5

      100% enrolled

    $53.90

    funcoding's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!