강의

멘토링

로드맵

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) 24 reviews

540 learners

  • hongpark
SQL
PostgreSQL
DBMS/RDBMS

Reviews from Early Learners

What you will learn!

  • 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,894

Learners

392

Reviews

186

Answers

4.9

Rating

6

Courses

프로그래밍 교육 전파에 진심인 🔥 유튜버 및 벤처 🧑🏻‍💻 개발자. 다양한 IT경험을 토대로, 누구나 쉽게 배울 수 있는 강의 제작에 힘쓰고 있다. 저서로는 📖 <자바를 부탁해>, <스프링부트3>, <SQL, 데이터베이스 입문>이 있다.

  • 현) 유튜브 채널 👉 "홍팍" 운영

  • 현) 프로그래밍 강사 및 튜터 활동

  • 현) 클라우드스터딩 운영

  • 전) 한국 항공대 무인 항공기 MAV Lab. 연구원

  • 전) 한국 항공대 아두이노 강의 조교

  • 전) 아이엠박스 개발팀장

  • 전) 시프트더블유 개발자

 

저서 목록

Untitled.jpg.webp

 

Curriculum

All

54 lectures ∙ (3hr 50min)

Published: 
Last updated: 

Reviews

All

24 reviews

4.8

24 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!