강의

멘토링

커뮤니티

BEST
Data Science

/

Data Analysis

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

(4.8) 26 reviews

542 learners

Level Basic

Course period 4 months

  • hongpark
SQL
SQL
PostgreSQL
PostgreSQL
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
PostgreSQL
PostgreSQL
DBMS/RDBMS
DBMS/RDBMS

Reviews from Early Learners

Reviews from Early Learners

4.8

5.0

학운학운

100% enrolled

I feel like I learned a lot about SQL very easily and quickly, from the introduction to the application. Thank you. If I'm aiming to become a backend developer, how should I study more about SQL?

5.0

Taewook Kim

100% enrolled

This is a very suitable lecture for those who are new to databases. I recommend it!!!

5.0

97_jw

100% enrolled

The concepts are explained concisely with pictures, so it's easy to understand, and since it's a lecture focused on practice, it's a good lecture to learn the concepts on your own. It's very informative because it only covers the necessary content in a practical way, and even though I'm the type who doesn't listen to online lectures well, I enjoyed it ㅎㅎ ++ While creating a project with Spring Boot, I felt the importance of DB design, so I'm listening to it over and over again. This lecture is really a must-take lecture before studying Spring or Spring Boot.....

What you will gain after the course

  • How to extract Excel work in half a day with just a few lines of query!

  • Data split into tables, what connects where?

  • Scattered data, all in one!

  • Divide by feature and analyze by group!

  • Query results, back to query input!

Do it right, neatly and with sense!
Learn SQL data analysis quickly and easily 😎

Now is the age of data !

  • Data, a pillar of the 4th industrial revolution!
  • Data analysis capabilities demanded by many companies! 💪


Beyond SQL Basics, Now It's Time to Use It!

  • More practical SQL that is difficult to do in Excel!
  • Time is of the essence, how long should I wait? 😱
  • Even complex data, right at my fingertips!
  • Half a day of Excel work, just a few lines of queries!

SQL data analysis, from introduction to application , all in one series !

Hongpak's [Concept is easy, practice is intense] SQL data analysis consists of two parts.
This lecture is about utilizing SQL data analysis .


Just the essentials , straight from the heart! + Visualization learning!

  • No more boring lectures! Quick and easy, just the essentials!
  • Intuitive explanations through pictures and metaphors ! Magical process drawing! 🧙‍♂️

Practice -oriented! Don't hesitate to learn!

  • Can memorizing English vocabulary help you converse? Seeing is believing! Practice-based learning! 🏋
  • Learn the concepts and solve problems by applying those concepts right away!
  • Minimal learning, maximum impact! What would take an hour to study, done in 5 minutes!
  • Because your time is precious..! 💎


Q&A

Q. What database do you use for lectures?

PostgreSQL! 🔥

Q. There are many types of databases. Is it okay to study with PostgreSQL?

That guy is that guy, it's okay!
(If you can speak Seoul dialect, you can travel to the provinces with SSAP! 💪)

Q. Can non-majors also take the course?

Of course! 😉

Q. Are you learning table design?

No! This class is for data analysis, not data design!
But, I made a basic table myself! 🧑🏻‍💻

Q. Can I summarize the lecture content on my blog?

If you leave a source and link, it's OK!
(For non-commercial use only, to avoid copyright issues 🙏)

Q. What level do you expect to reach after learning everything?

Add Intermediate SQL to your resume! 🔥
Passed the SQL Coding Test! 🏋️


Are you curious about Hongpak 's other lectures ?

"Learn Java & HTML/CSS through Pictures" series!

Recommended for
these people

Who is this course right for?

  • Now that I've learned the basics, I'm going to try using SQL in earnest!

  • I learned the concept, but why is it difficult to apply it in practice?

  • I want to extract complex data with my own hands!

  • Practical rather than conceptual! Where can I find a problem-solving lecture?

  • SQL coding test, I want to express my thoughts in queries!

Need to know before starting?

  • Take the course "SQL Data Analysis, Introduction!"

Hello
This is

4,969

Learners

410

Reviews

186

Answers

4.9

Rating

6

Courses

A 🔥 YouTuber and venture 🧑🏻‍💻 developer who is passionate about spreading programming education. Based on diverse IT experience, he is dedicated to creating lectures that anyone can easily learn. His books include 📖 <Java, Please>, <Spring Boot 3>, and <Introduction to SQL and Databases>.

  • Current) Operating YouTube channel 👉 "Hongpark"

  • Current) Programming instructor and tutor

  • Current) Operator of CloudStudying

  • Former) Researcher at Korea Aerospace University Unmanned Aerial Vehicle MAV Lab.

  • Former) Teaching Assistant for Arduino lectures at Korea Aerospace University

  • Former) Development Team Lead at i-M-BOX

  • Former) Developer at ShiftW

List of Publications

Untitled.jpg.webp

Former Researcher at Korea Aerospace University UAV MAV Lab. Former Teaching Assistant for Arduino Lectures at Korea Aerospace University Former Head of Development Team at I AM BOX Former Developer at ShiftW List of Publications

Curriculum

All

54 lectures ∙ (3hr 50min)

Published: 
Last updated: 

Reviews

All

26 reviews

4.8

26 reviews

  • samgangjumak님의 프로필 이미지
    samgangjumak

    Reviews 8

    Average Rating 4.9

    5

    100% enrolled

    I feel like I learned a lot about SQL very easily and quickly, from the introduction to the application. Thank you. If I'm aiming to become a backend developer, how should I study more about SQL?

    • hongpark
      Instructor

      Practice designing tables by referring to various example diagrams (Google it). I recommend making them as small as possible but with a variety of options.

  • twooogiii1504님의 프로필 이미지
    twooogiii1504

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    This is a very suitable lecture for those who are new to databases. I recommend it!!!

    • 97jw1677님의 프로필 이미지
      97jw1677

      Reviews 9

      Average Rating 4.8

      5

      100% enrolled

      The concepts are explained concisely with pictures, so it's easy to understand, and since it's a lecture focused on practice, it's a good lecture to learn the concepts on your own. It's very informative because it only covers the necessary content in a practical way, and even though I'm the type who doesn't listen to online lectures well, I enjoyed it ㅎㅎ ++ While creating a project with Spring Boot, I felt the importance of DB design, so I'm listening to it over and over again. This lecture is really a must-take lecture before studying Spring or Spring Boot.....

      • hongpark
        Instructor

        A sincere review..💎 Thank you..💕

    • rnwnsgud907278님의 프로필 이미지
      rnwnsgud907278

      Reviews 10

      Average Rating 5.0

      5

      100% enrolled

      Hongpak's lectures are easy to understand with concise explanations and easy-to-read PPTs, and are suitable for checking whether you have understood and moved on with various practice problems and training. I was having trouble writing SQL on my own, but thanks to you, I am learning well.

      • hongpark
        Instructor

        Junhyung's precious first review..! 💎 I will gratefully accept it 😉

    • tlbdlsad3993님의 프로필 이미지
      tlbdlsad3993

      Reviews 1

      Average Rating 5.0

      5

      100% enrolled

      This is my first time taking a solid Inflearn course! It's not easy for beginners to imagine what the table will look like when they're put together, but I think my understanding of table structures has really improved while listening to Hongpak's course. I thought I was going to faint when I used the last three joins... but I think I'll be able to use things like this later on, right? Haha. Thanks to you, I learned a lot! Thank you! (ps. Please open a Python data analysis course too. I'll spend money..)

      $27.50

      hongpark's other courses

      Check out other courses by the instructor!

      Similar courses

      Explore other courses in the same field!