inflearn logo
inflearn logo

Mastering MySQL Database: From SQL Basics to Real-world Practice

This course is designed to help you learn MySQL databases and SQL step-by-step, from the absolute basics to a professional level. It covers database concepts, relational models, SQL syntax, queries, conditions, sorting, functions, joins, subqueries, and indexes, with a focus on practical examples. The curriculum is structured so that you can understand concepts many students find difficult (such as joins, subqueries, and group functions) by following along directly. With a flow of Theory → Practice → Summary, this course ensures you can complete it until the end without getting stuck. Whether you are new to SQL or want to brush up on the basics, you will gain database skills that can be applied immediately in the workplace.

1 learners are taking this course

Level Beginner

Course period Unlimited

SQL
SQL
MySQL
MySQL
database-design
database-design
data-analysis
data-analysis
SQL
SQL
MySQL
MySQL
database-design
database-design
data-analysis
data-analysis
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

What you will gain after the course

  • I can understand and explain the structure of MySQL databases and the relational data model.

  • I can freely write core SQL queries such as SELECT, WHERE, ORDER BY, and GROUP BY.

  • You can solve complex data retrieval problems using JOINs and subqueries.

  • You can insert, modify, and delete data, as well as directly create and manage tables, views, and indexes.

  • You can apply SQL patterns frequently used in practice to data analysis and backend development.

MySQL Database Mastery: From SQL Basics to Practical Application

This course is designed to help you learn how to design, query, and manage databases using MySQL and SQL
step-by-step, from the basics to a professional level.

MySQL and SQL are core technologies widely used in various industries and roles, such as backend development, web services, data analysis, and software development.

Seeing many learners struggle with JOINs, subqueries, and database concepts,
I designed this course so that you can understand the principles and follow along directly rather than just relying on simple memorization.
By the end of the course, you will gain the confidence to write SQL on your own and solve problems independently.

What You’ll Learn

Section (1): Core Keywords

MySQL Basics · Database Concepts · SQL Querying

In this section, you will build a solid foundation in the core basics of databases and SQL.

What You’ll Learn:

  • Understanding the concepts of Database and DBMS, and the structure of MySQL

  • The evolution of databases and various database types

  • Data Modeling and Relational Data Models

  • Data retrieval using SELECT statements

  • Data filtering using WHERE conditions

  • Understanding SQL Operators and Sorting Methods

Section (2): Core Keywords

Advanced SQL · Joins · Subqueries · Data Management

This section focuses on SQL techniques used directly in practice.

Learning Content:

  • Utilization of numeric, string, date, and aggregate functions

  • Data grouping using GROUP BY

  • Multi-table lookup using JOIN

  • Understanding subqueries and nested queries

  • Data insertion, modification, and deletion (INSERT, UPDATE, DELETE)

  • Creating and managing tables, views, and indexes

  • Writing SQL queries with performance in mind

Before You Enroll

Prerequisites & Notices

  • No prior knowledge is required
    Everything is explained from the basics so that even those new to databases or SQL can take the course.

  • 🎧 Audio and Video Quality
    You can focus on your learning with clear sound quality and high-resolution screen recordings.

  • 📚 Recommended Learning Method
    After watching the lectures, it is recommended to practice by directly typing SQL in MySQL.

  • 💬 Questions and Updates
    You can ask questions through the course Q&A, and the course may be updated as needed to reflect MySQL and SQL trends.

  • ⚖️ Copyright and Intellectual Property Notice
    All videos and materials in this course are protected by copyright.
    Unauthorized reproduction, distribution, recording, and reuse are prohibited.

Recommended for
these people

Who is this course right for?

  • A beginner learning SQL and databases for the first time who feels overwhelmed and doesn't know where to start.

  • Learners who need MySQL for backend development, data analysis, and web service development

  • Those who know basic SQL syntax but often get stuck on joins, subqueries, and aggregate functions.

  • Those who want to improve their skills by writing actual queries, not just learning theory.

Need to know before starting?

  • ❌ No prior knowledge is required. Anyone with basic computer skills can take this course, and SQL and database concepts will be explained step-by-step from the very basics.

Hello
This is Kim Min-Joon

Curriculum

All

20 lectures ∙ (11hr 30min)

Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

Kim Min-Joon's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

Limited time deal

$74,250.00

10%

$63.80