강의

멘토링

로드맵

SQL Made Easy with HEARTCOUNT

This is an introductory course for those who want to start SQL for the 'first' time. It covers only the essential concepts you must know and the core content frequently used in practice.

(5.0) 1 reviews

9 learners

Level Beginner

Course period Unlimited

SQL
SQL
MySQL
MySQL
sql-query
sql-query
SQL
SQL
MySQL
MySQL
sql-query
sql-query

What you will gain after the course

  • You can build foundational knowledge of databases.

  • You will learn basic SQL syntax.

  • You can extract and process data using SQL functions.

✔️ Getting Started with SQL Easily with HEARTCOUNT

It's okay even if you have zero base!

Start your journey step-by-step with HEARTCOUNT and Instructor Sungwook Kang, and begin applying it directly to your practical work.

⚠️ This course is exclusively available to 'HEARTCOUNT Premium Users.'

  • Please do not leak the details page of this lecture (the page you are currently viewing) or the discount coupon code without authorization.

  • Please use the same email address for your Inflearn ID as your HEARTCOUNT ID.

If unauthorized use of the coupon is suspected, measures such as student removal will be taken.

Why should you learn SQL?

  • It is establishing itself as an essential skill in all fields and all job roles.


    As data grows across various fields and businesses, the ability to query and analyze data on one's own is becoming essential, even for non-data roles such as marketing and planning.

  • It is a language with a very high return on investment.
    Now, if you are proficient in just SQL, you can query almost any data through mapping solutions.

  • You can directly extract, aggregate, and utilize the data you need as information.


    If you know how to use SQL, you can effectively search for the information you want from a database and increase work productivity. Additionally, by writing simple queries, you can manage data quality and sort or aggregate it for easy use without having to ask an expert.

Unique Advantages of This Course

  • No prior knowledge is required.
    Anyone with a PC can take this course. Start learning SQL with friendly, beginner-level explanations.

  • Created for non-majors and those in non-data roles.
    It is packed with highly practical content for the workplace, explained step-by-step in easy-to-understand language for beginners.

  • We have balanced theory and practice with a proven instructor.


    Through the explanations of Instructor Sungwook Kang, a SQL expert and author of <Do it! SQL>, you can clearly understand essential concepts. To ensure you can make the theories you've learned your own, we have included mandatory practice sessions in each part.

  • Access the specific content you want, for a lifetime.
    For those who need to acquire knowledge urgently, we have prepared a granular curriculum so you can quickly pick and choose only what is necessary for your practical work. Easily learn the functions and syntax you need, whenever you need them.

  • You can learn and grow further by communicating with community members
    Meet other students through the HEARTCOUNT community Slack channel, and share knowledge and information by communicating with practitioners interested in data.
    HEARTCOUNT Community Official Page>

Instructor Introduction

🧑‍🏫 Introducing Instructor Sungwook Kang!

  • Current) AWS Sr. Solutions Architect
    Former) NHN Global SRE team Manager
    Former) Principal Database Engineer
    Former) 2012 ~ 2022 Microsoft Data Platform MVP


  • Expert Instructor in the Field of SQL


  • Author: <Do it! SQL 입문>


Lecture Preview

From MySQL tool usage to data querying, table joins, functions, and programming

I will explain it to you kindly and in detail.

After completing the entire curriculum, you will find yourself becoming familiar with SQL before you even know it.

👀 A preview of the theoretical lecture

👀 Preview of the practice lecture

✔️  Please refer to the lecture practice environment!

  • Practices are conducted using MySQL's Workbench, an open-source tool commonly used in corporations.

  • MySQL Workbench can be installed and used on Windows, Linux, and Mac OS.

  • You can install MySQL Workbench at this link.

  • I will provide a thorough explanation of how to use the MySQL Workbench tool within the lecture.

  • We provide the script used in the lecture practice.

  • In the lecture, practice sessions will be conducted in a Windows operating system environment.

If you subscribe to HEARTCOUNT Premium

All data lectures from HEARTCOUNT

take for 'free' for a lifetime with the coupon we provide.


From 90,000 KRW per year ~

[HEARTCOUNT's Data Lectures by Topic]

  • SQL & Database Introduction by Instructor Kang Sung-wook

  • Excel & Data Preprocessing by Instructor Jaewan Choi

  • Python & Data Preprocessing by Instructor Gil-seung Ahn

  • GA4 Introduction and Core Practical Application by Instructor Dongwoo Kim

More will continue to be added in the future :)


🖱 Go to Subscribe to HEARTCOUNT Premium

What is HEARTCOUNT?

HEARTCOUNT, a tool that enables data analysis, visualization, and insight discovery without expert knowledge

From individual record-level visualization to automated chart interpretation, factor analysis, and discovery of optimization rules.
With HEARTCOUNT, anyone can become an analyst.


🖱 Visit the website now

💸 How to use the HEARTCOUNT user-exclusive coupon

  1. Log in to HEARTCOUNT (Continue with Google)

  2. Click the 'Upgrade' button to subscribe to HEARTCOUNT Premium (Starting from 90,000 KRW per year ~)

  3. Check your inbox for the 'Free Data Course Coupon'

  4. Access Inflearn > 'My Page' > 'Coupons' > 'Enter Discount Coupon Code'

  5. Using the coupon on the payment page after applying for the course

※ Coupon expiration dates are announced via email. Coupons cannot be used after the specified date, so please use them within the period.
※ For related inquiries, please contact the person in charge via email (support@idk2.co.kr).

Recommended for
these people

Who is this course right for?

  • Database and SQL beginners

  • Non-majors or non-data professionals who want to utilize SQL in their work

  • Those who want to quickly become familiar with writing SQL queries

  • Those who know basic query statements but want to establish a firmer grasp of the concepts.

  • Those who want to apply it to their work immediately

Hello
This is HEARTCOUNT

3,050

Learners

82

Reviews

4.8

Rating

16

Courses

HEARTCOUNT is an AI data analysis tool that allows anyone to easily become an analyst with just an Excel dataset and a few questions.

We create a variety of data education content for working professionals.


Try HEARTCOUNT now 👉 HEARTCOUNT Homepage

More data content 👉 HEARTCOUNT Community

Curriculum

All

50 lectures ∙ (5hr 45min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • joyhee2010님의 프로필 이미지
    joyhee2010

    Reviews 1

    Average Rating 5.0

    5

    64% enrolled

    HEARTCOUNT's other courses

    Check out other courses by the instructor!

    Similar courses

    Explore other courses in the same field!