강의

멘토링

로드맵

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

1,702 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,408

Learners

2,817

Reviews

23

Answers

4.9

Rating

37

Courses

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

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

👉 https://datarian.io/

Curriculum

All

22 lectures ∙ (2hr 12min)

Published: 
Last updated: 

Reviews

All

139 reviews

4.9

139 reviews

  • rakanishu님의 프로필 이미지
    rakanishu

    Reviews 6

    Average Rating 4.7

    5

    100% enrolled

    Thay vì giải thích vấn đề, tôi thích giải thích cách giải quyết vấn đề từng bước một. Nó khiến tôi nghĩ rằng mình cần phải giải quyết nhiều vấn đề hơn. Cảm ơn

    • sunmiyoon
      Instructor

      Tôi nghĩ rằng bằng cách giải quyết vấn đề, bạn có thể phát triển một cách tự nhiên khả năng nhìn nhận vấn đề một cách có cấu trúc. Chiến đấu!

  • swiftworld님의 프로필 이미지
    swiftworld

    Reviews 11

    Average Rating 5.0

    5

    100% enrolled

    Tôi rất thích bài giảng~!

    • vinegun1366님의 프로필 이미지
      vinegun1366

      Reviews 5

      Average Rating 5.0

      5

      100% enrolled

      Tôi nghe rõ lắm. Cao cấp cũng được mong đợi.

      • jomg05071738님의 프로필 이미지
        jomg05071738

        Reviews 2

        Average Rating 5.0

        5

        100% enrolled

        Thật tuyệt. Tôi cũng sẽ học lớp nâng cao.

        • juneoh님의 프로필 이미지
          juneoh

          Reviews 6

          Average Rating 5.0

          5

          100% enrolled

          Nó rất hữu ích vì chúng tôi có thể cùng nhau giải quyết nhiều vấn đề khác nhau.

          $13.20

          datarian's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!