Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
BEST
Data Science

/

Data Analysis

[A hundred words are not as good as seeing once] Intermediate SQL problem solving for data analysis

Datalian's SQL intermediate problem-solving lecture with over 10,000 cumulative students and rich online/offline lecture experience. We will solve several problems together to practice the SQL intermediate theory.

(4.9) 132 reviews

1,650 learners

3시간 만에 완강할 수 있는 강의 ⏰
SQL

Reviews from Early Learners

What you will learn!

  • Importing data with SQL

  • Develop your query writing skills by solving various problems!

Seeing is believing! Take your SQL learning to the next level.
Solve the problem yourself with Datalian.

SQL, how should I study?

There are many SQL theory lectures,
Why aren't there any courses where you can really develop your skills by solving a lot of problems ?

Just as no matter how much you study English grammar, your English conversation skills will not improve if you don't actually have conversations,
You can't use SQL properly just by studying the grammar.

Lecture Introduction 📝
Level up your SQL learning through problem solving!

So I'm back with another lecture that's all about problem solving !

In this lecture, we will learn about GROUP BY, CASE, JOIN, etc. covered in the intermediate class.
We'll be leveraging a few new functions at a similar level:
Solve problems of varying difficulty.

(Problems covered in the advanced class , such as subqueries, can be found in the advanced problem-solving class scheduled to open soon.)

I recommend this course to anyone who wants to practice writing queries for work or SQL coding tests !


Things to prepare before attending the lecture ✔️

This lecture will combine HackerRank ( hackerrank.com ) and LeetCode ( leetcode.com ) problems. Before attending the lecture, we recommend registering for both sites and browsing through them first.


✔️ Course Roadmap


Rewatch the last lecture 🔖

Intermediate SQL for Data Analysis
Learn intermediate SQL grammar and solve real-world problems.
Advanced SQL for Data Analysis
Learn various functions for advanced SQL use.

Recommended for
these people

Who is this course right for?

  • People who have learned SQL theory but feel they lack practical experience

  • People preparing for SQL coding tests

  • People who need a problem-solving-focused SQL lecture

  • People who want to become data analysts

  • People who want to learn SQL for work

Need to know before starting?

  • [#100 Questions are Better Than One Thing] Basic SQL for Data Analysis Lecture

  • [#100 Questions are Better Than One Thing] Intermediate SQL for Data Analysis Course

Hello
This is

32,992

Learners

2,898

Reviews

23

Answers

4.9

Rating

40

Courses

실무 경험이 탄탄한 현업 분석가들이 데이터 분석 교육을 기획하고, 직접 강의합니다.

데이터리안에 대해서 더 알아보고 싶다면

👉 https://datarian.io/

Curriculum

All

22 lectures ∙ (2hr 12min)

Published: 
Last updated: 

Reviews

All

132 reviews

4.9

132 reviews

  • 김락슈님의 프로필 이미지
    김락슈

    Reviews 6

    Average Rating 4.7

    5

    100% enrolled

    문제에 대한 해설보다도, 어떤 방식으로 단계적으로 문제를 풀어나아가야 하는지에 대한 설명이 좋았습니다. 더 많이 문제를 풀어봐야겠다고 생각하게 되네요. 감사합니다.

    • 윤선미
      Instructor

      문제를 풀다보면 자연히 어떤 문제를 구조적으로 바라보는 힘을 기를 수 있게 되는 것 같아요. 화이팅입니다!

  • goddios님의 프로필 이미지
    goddios

    Reviews 10

    Average Rating 5.0

    5

    100% enrolled

    강의 잘 들었습니다~!

    • Jinwook Kim님의 프로필 이미지
      Jinwook Kim

      Reviews 5

      Average Rating 5.0

      5

      100% enrolled

      잘 들었습니다. 고급도 기대됩니다.

      • 조민정님의 프로필 이미지
        조민정

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        최고에요 고급반도 들을게요

        • Jieun Oh님의 프로필 이미지
          Jieun Oh

          Reviews 6

          Average Rating 5.0

          5

          100% enrolled

          여러가지 문제를 함께 풀어볼 수 있어 도움이 됐습니다.

          $13.20

          datarian's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!