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] Advanced SQL problem solving for data analysis

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

(4.9) 47 reviews

1,058 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 use subqueries, window functions, and regular expressions covered in the advanced class .
Try to solve difficult problems.

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] Advanced SQL for Data Analysis Lecture

Hello
This is

32,990

Learners

2,898

Reviews

23

Answers

4.9

Rating

40

Courses

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

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

👉 https://datarian.io/

Curriculum

All

29 lectures ∙ (2hr 55min)

Published: 
Last updated: 

Reviews

All

47 reviews

4.9

47 reviews

  • 헬로월드님의 프로필 이미지
    헬로월드

    Reviews 27

    Average Rating 4.9

    5

    100% enrolled

    모든 강의 완강했는데도 왜 부족하다고 느끼는 것인가.. 시간 쏟아 문제 풀어보고 해설 보면 '와 어떻게 저런 방법을 생각했지!?'하는 생각이 드네요ㅠ 다음 강의 기대하겠습니다

    • 개발자는개발님의 프로필 이미지
      개발자는개발

      Reviews 6

      Average Rating 5.0

      5

      100% enrolled

      좋아요. 강의를 다 들으면, 프로그래머스에 있는 SQL은 쉽게 풀수있다고 했는데. 정말로 쉽게 느껴지네요.

      • Juyeon님의 프로필 이미지
        Juyeon

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        너무 잘 들었습니다~

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

          Reviews 5

          Average Rating 5.0

          5

          100% enrolled

          너무 잘 들었습니다.

          • 강형석님의 프로필 이미지
            강형석

            Reviews 5

            Average Rating 4.8

            5

            100% enrolled

            문제 풀이만으로도 어느정도 SQL에 대해 감 잡을 수 있었고 다양한 문제 제시해주셔서 좋았습니다.

            $15.40

            datarian's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!