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 for data analysis

Datalian's advanced SQL lecture with over 10,000 cumulative students and rich online/offline lecture experience. Learn advanced SQL theory and solve practice problems together.

(4.8) 308 reviews

3,367 learners

SQL

Reviews from Early Learners

What you will learn!

  • Importing data with SQL

  • The third lecture in the SQL Basics series that even people who have never coded before can understand!

There are many SQL theory lectures,
Why aren't there any courses that allow you to develop real skills while solving 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 📝

Welcome to the advanced class after completing the SQL basics and intermediate classes!

👏👏(clap clap clap)👏👏



If you have learned the basic syntax of SQL (joining multiple tables, group operations, etc.),
From here on, we'll cover various SQL features to help you solve more complex and challenging problems.

Through advanced lectures, you can acquire the skills to efficiently handle various calculations required in practice.
You can also learn more in-depth by using the additional materials provided during or at the end of the lecture.

Thank you to all the students who took the class from beginner to advanced level!


You no longer have to bother sending emails.
Download it now from Inflearn!

Now you have completed all the advanced SQL courses.
In the last lecture , 'Completion Commemorative Gift_SQL Cheatsheet (Advanced)'
Click the [Class Materials] button on the top right
You can download the CheatSheet
( see image below) .

(While not required, thoughtful reviews and questions are always welcome!)

Things to prepare before attending the lecture ✔️

The lecture is available on HackerRank ( hackerrank.com ) and leetcode ( leetcode.com ) sites.
The curriculum is structured based on the problems.
Before attending the lecture, we recommend that you visit the website above, register as a member, and then take a look around the website.

Things to study together ✔️

Programmer's SQL High Score Kit
https://programmers.co.kr/learn/challenges?tab=sql_practice_kit

✔️ Course Roadmap

Rewatch the last lecture 🔖

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

  • Anyone who wants to start learning SQL without any plan!

  • People who want to become data analysts

Need to know before starting?

  • Take a SQL Basics Course for Data Analysis

  • Take an intermediate SQL course for data analysis

Hello
This is

32,990

Learners

2,898

Reviews

23

Answers

4.9

Rating

40

Courses

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

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

👉 https://datarian.io/

Curriculum

All

32 lectures ∙ (4hr 54min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

308 reviews

4.8

308 reviews

  • 세바스찬 주니어 3세님의 프로필 이미지
    세바스찬 주니어 3세

    Reviews 15

    Average Rating 4.7

    5

    97% enrolled

    현재 현업에서 SQL을 사용하고 있는 중이고, 개념을 전반적으로 다시 정리하기 위해 기초반부터 고급까지 전 강의 정주행 하였습니다. 먼저 강의 내용 자체는 정말 알차고 여러모로 큰 도움이 된 것 같습니다. 다만, 각각의 강의 영상 별로 볼륨 크기가 계속 차이가 난다던가 영상 도입 및 마감부에서 편집이 깔끔하지 못했던 부분들은 강의의 퀄리티 및 완성도 측면에서 조금은 아쉬운 부분인 것 같기도 합니다. 또한 이번 고급 강의처럼 기초/중급 레벨에도 강의 자료가 별도로 첨부되어 있었으면 각 레벨 별로 완강 이후 복습을 할 때 좀 더 효율적일 것 같습니다. 해당 개선점들에 대한 의견은 주관적인 부분이라 앞으로 강의 제작해주실 때 가볍게 참고해주셨으면 합니다. 좋은 강의 만들어주셔서 진심으로 감사드리고, 앞으로 새롭게 신설될 강의들도 기대하겠습니다!

    • 선종연님의 프로필 이미지
      선종연

      Reviews 6

      Average Rating 5.0

      5

      100% enrolled

      초보 실무자에게 매우 도움이 되는 강의였습니다.

      • 김선영님의 프로필 이미지
        김선영

        Reviews 5

        Average Rating 5.0

        5

        100% enrolled

        명강의 감사합니다~

        • jkblaxk님의 프로필 이미지
          jkblaxk

          Reviews 1

          Average Rating 5.0

          5

          100% enrolled

          좋은강의 잘듣고 갑니다. 감사합니다.

          • 데릭로님의 프로필 이미지
            데릭로

            Reviews 71

            Average Rating 5.0

            5

            100% enrolled

            기초반, 중급반 듣고 강의가 괜찮아서 고급반까지 듣네요. 강의가 좋습니다.

            • 윤선미
              Instructor

              로날루영님, SQL 시리즈 완주 중이시군요. 감사합니다!

          $42.90

          datarian's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!