강의

멘토링

커뮤니티

BEST
Data Science

/

Data Analysis

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

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

(4.9) 918 reviews

5,275 learners

SQL

Reviews from Early Learners

What you will learn!

  • Importing data with SQL

  • SQL Basics that even people who have never coded before can learn

📢 [Course Update Notice] Course updates are scheduled for the month of November.
The curriculum, course materials, etc. will be completely changed, so please keep this in mind for your studies.

Course Introduction

There are many SQL theory lectures, but why aren't there any courses that can help you build real skills by combining them with problem-solving practice?

Just as studying English grammar alone won't improve your conversational skills without actual practice,
you can't properly use SQL by only studying its syntax.

For those who want to immediately apply SQL in their work and for those preparing for SQL coding tests, this is a helpful course.

If you complete both the basic and intermediate SQL courses, you'll be able to easily solve problems at the level of Programmers' SQL High Score Kit.

You don't need to bother sending emails anymore.
Download directly from Inflearn!

Now that you have completed all the SQL Intermediate course lectures
and reached the final lecture
'Course Completion Gift_SQL Cheatsheet',
you can download the CheatSheet by clicking
the [Materials] download button in the upper right corner
(refer to the image below).

(Not required, but heartfelt reviews and questions are always welcome!)

What you need to prepare before taking the course

This course curriculum is structured based on problems from HackerRank(hackerrank.com) and leetcode(leetcode.com) websites.
Before taking the course, we recommend visiting the above websites, signing up for membership, and exploring the sites once.

Things that would be good to study together

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

# To create a better learning environment, we are working on Korean subtitle support.
Subtitles will be added to videos in the order that subtitle work is completed, so please keep this in mind when using the service.

# The enrollment period for this course is 3 months. This period has been set with the hope that all students will complete the course, so we strongly recommend checking the enrollment period before starting the course.

✔️ Course Roadmap


Previous Lecture & Follow-up Lecture Guide 🔖

[Practice Makes Perfect] Basic SQL for Data Analysis
Learn basic SQL syntax and solve real problems
[Practice Makes Perfect] Advanced SQL for Data Analysis
Learn various features for advanced SQL utilization
[Practice Makes Perfect] Advanced SQL Problem Solving for Data Analysis
Improve your query writing skills through various problem-solving exercises

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 start learning SQL without any preparation

  • People who want to become data analysts

Need to know before starting?

  • Take a basic SQL course for data analysis

Hello
This is

32,953

Learners

2,873

Reviews

23

Answers

4.9

Rating

37

Courses

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

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

👉 https://datarian.io/

Curriculum

All

23 lectures ∙ (4hr 15min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

918 reviews

4.9

918 reviews

  • the27920609님의 프로필 이미지
    the27920609

    Reviews 13

    Average Rating 5.0

    5

    100% enrolled

    Following the beginner level, the intermediate level was also very good. It's the same as the beginner level review, but it's a shame that the course period is too short for this price.

    • decaf20214656님의 프로필 이미지
      decaf20214656

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      I'm hooked on HackerRank. It's really fun. Thank you for rekindling my passion as a data analyst.^^

      • jaecheollee님의 프로필 이미지
        jaecheollee

        Reviews 2

        Average Rating 5.0

        5

        100% enrolled

        This lecture is very helpful for my work. Thank you.

        • hjheo님의 프로필 이미지
          hjheo

          Reviews 3

          Average Rating 4.0

          5

          100% enrolled

          It was a lecture that gave me a sense of accomplishment because the concepts that I was confused about became a little clearer. I think I still have a lot to learn, so I need to listen to it a few more times, but I was very satisfied. Thank you for the great lecture!

          • jookg5446님의 프로필 이미지
            jookg5446

            Reviews 2

            Average Rating 5.0

            5

            100% enrolled

            I think my skills have improved a bit as I have been studying step by step with the teacher! I am proud and happy that SQL, which was vague, has become familiar. Thank you for the great lecture. My email address is aksuxn2@naver.com

            $29.70

            datarian's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!