inflearn logo

SQL: Mastering the Essentials the Easy Way

Skip the complex theories and concepts, and jump right into writing, practicing, and following along with SQL syntax!

(5.0) 1 reviews

41 learners

Level Beginner

Course period Unlimited

SQL
SQL
MySQL
MySQL
SQL
SQL
MySQL
MySQL

What you will gain after the course

  • Basic concepts of databases and schemas

  • General theory and format of SQL

  • Securing SQL capabilities through the use of various functions

  • Practical SQL application skills using AI

SQL Essential Syntax + Core Competencies, Quickly 💯

SQL for Databases,
Use only the core essentials easily and quickly!

In Maso Campus's "SQL Mastery: Core Concepts Made Easy", you can develop the following skills.

A concept you absolutely cannot avoid if you are learning SQL!

We briefly explain core terms and concepts such as DB, schema, table, key, DBMS, and relationships, and learn about the types and licenses of DBML (Database Markup Language).

We provide the most concise and friendly guide to the entire process, from downloading to configuration, so that you can freely install MySQL 8.0 Community Edition—an essential tool for SQL practice—whenever you need it.

Let's upload an Excel file to the DB server!

The main purpose of SQL is to freely extract the desired data from a database. After a brief and quick overview of theoretical explanations such as creating schemas and tables, and individually inserting, deleting, and modifying data, we will follow the process of uploading 3,000 pieces of customer information and 25,000 sales records contained in an Excel file to a DB server.

You can apply the same method to real-world data suited to your specific situation and utilize it in your work at any time.

Let's learn and use the core syntax of SQL!

It covers the core syntax of SQL, including extracting and selecting the data you want and applying various conditions.

Focusing on SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT, we teach only the essential skills needed for real-world tasks, such as applying conditions, aggregating, and limiting data.

Subqueries + Joins to handle complex conditions all at once!

SQL within an SQL statement? We will practice combining multiple tables and outputting complex conditional statements using subqueries—which involve putting a query inside another query—and inner joins that merge various data into one.

At this time, we will examine various common error scenarios that anyone can make and learn together what to look out for in practical work.


Check out the features of
this course.

💡 By taking this course step-by-step, you will master the essential syntax of SQL and gain sufficient practical skills to extract and organize the data you need from a company database. Furthermore, at the end of the course, we will introduce tips on how to better utilize SQL using AI services, helping you identify deeper SQL applications and methods for optimizing SQL performance to handle big data according to your individual situation.

STEP 1. Is SQL very different from Excel?

Not at all! With SQL, you can easily and quickly perform repetitive Excel tasks using queries, and because it utilizes databases, you can rapidly extract only the data you need even when dealing with large volumes. We will guide you step-by-step, starting from the core concepts and operating principles of SQL. As you listen, you'll find yourself falling for the charm of SQL, which can be even easier than Excel.

STEP 2. Upload files to the DB and extract only the data you want!

If you have ever felt bored or frustrated with having to create pivot tables and filters every time you want to extract specific data in Excel for work or daily life, try using SQL! With the core syntax that we will use repeatedly in this course, you can easily and quickly extract only the data you need.

STEP 3. When you need to create a query with complex conditions but can't think of how, use AI!

"Write a query for someone who lives in Seoul, is a woman in her 30s, is very interested in data analysis, and is taking a Miso Campus course!" Did such a request leave you feeling overwhelmed? If so, just ask AI! Have you heard of the incredibly popular ChatGPT? By utilizing ChatGPT, you can easily create even the most difficult query syntax.


After completing the entire lecture,
you will be able to acquire these skills.

After completing the "Mastering the Essentials of SQL with Ease" course, you will be able to acquire the following skills., bạn sẽ có được những năng lực sau đây.

  • ✅ Understanding core terminology and operating principles to properly utilize SQL
  • ✅ The ability to upload files to a DB and extract data
  • ✅ The ability to find insights from large amounts of data
  • ✅ Securing practical skills using various conditions and aggregations

From the definition and terminology of databases to core practical applications, we will teach you all the essential information you need for SQL without leaving anything out. Master this course and become a true professional by fully utilizing SQL in your work!

데이터베이스 간단하게 이해하기
MySQL 설치하기
스키마, 테이블을 만들고 데이터 입력하기
파일에 담긴 자료를 DB에 넣기

Easily Create SQL Queries with AI


Q&A 💬

Q. Is prior knowledge of SQL required?

Not at all. You don't need any prior knowledge of SQL. The instructor has designed the course to help you get a feel for it—covering everything from a basic understanding of databases to SQL installation and hands-on practice—so you don't have to worry.

Q. Are there any requirements or prerequisites for taking the course?

Since this is a practice-oriented course, it is recommended to have a dual monitor or an extra device to separate the lecture screen from the practice screen. Additionally, as the exercises are based on Windows OS, we recommend taking the course in a Windows environment.

💾 Please check before taking the course!

  • Since this is a practice-oriented course, it is recommended to prepare a dual monitor or an extra device so that you can separate the lecture screen from your practice screen.
  • The practice sessions are conducted based on Windows OS, so we recommend taking the course in a Windows environment.
  • Lecture materials and practice files are attached in the <0. Textbook Download Center> section.

Recommended for
these people

Who is this course right for?

  • Those who are interested in data and data analysis

  • Those who want to try data analysis using tools other than Excel

  • Those who want to build a solid foundation by learning databases, which are the basis of SQL.

  • Those who want to extract only the necessary data by writing SQL statements themselves

Hello
This is Masocampus

11,101

Learners

1,593

Reviews

136

Answers

4.7

Rating

108

Courses

"I will grow more than yesterday. And, I will help those who strive to grow more than yesterday."

With Actionable Content that embodies the sincerity and aspirations of Maso Campus,

100 million cumulative hours of lectures shared online and offline since 2013!

This precious experience and time are always the source of growth for both Maso Campus and our students.

The Miso Campus team strictly adheres to two principles for the growth of us all. 1. Actionable Content that can be put into practice immediately after learning. 2. Respecting the time and effort of participants.

The Miso Campus team strictly adheres to two principles for the growth of us all.

1. Actionable Content that you can actually use after learning 2. Time-Saving Curriculum that respects the participant's time and effort Grow with Miso Campus's Actionable and Time-Saving Curriculum

1. Actionable Content that you can surely use once you learn it

2. Time-Saving Curriculum that respects the time and effort of participants

We hope you will walk the path of growth together with Masocampus's Actionable and Time-Saving Curriculum.

We hope you will walk the path of growth together with Maso Campus's Actionable and Time-Saving Curriculum.

More

Curriculum

All

15 lectures ∙ (5hr 30min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • yongmi4480님의 프로필 이미지
    yongmi4480

    Reviews 2

    Average Rating 5.0

    5

    93% enrolled

    • masocampus
      Instructor

      Thank you for leaving a review😊 Maso Campus will always do its best!

Masocampus's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$16.40

25%

$26.40