강의

멘토링

로드맵

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,098 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,075

Learners

2,773

Reviews

23

Answers

4.9

Rating

37

Courses

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

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

👉 https://datarian.io/

Curriculum

All

29 lectures ∙ (2hr 55min)

Published: 
Last updated: 

Reviews

All

47 reviews

4.9

47 reviews

  • john님의 프로필 이미지
    john

    Reviews 27

    Average Rating 4.9

    5

    100% enrolled

    Dù đã học qua hết các bài giảng nhưng tại sao tôi vẫn cảm thấy chưa thỏa đáng? Khi tôi dành thời gian giải các bài toán và đọc phần giải thích, tôi nghĩ, 'Làm thế nào mà họ nghĩ ra được phương pháp đó!?' Tôi mong chờ bài giảng tiếp theo

    • rebuild29643122님의 프로필 이미지
      rebuild29643122

      Reviews 6

      Average Rating 5.0

      5

      100% enrolled

      Tuyệt. Họ nói rằng nếu tôi nghe tất cả các bài giảng, tôi có thể dễ dàng giải SQL trong Lập trình viên. Nó cảm thấy thực sự dễ dàng.

      • jayjykim911898님의 프로필 이미지
        jayjykim911898

        Reviews 1

        Average Rating 5.0

        5

        100% enrolled

        Tôi nghe hay quá~

        • vinegun1366님의 프로필 이미지
          vinegun1366

          Reviews 5

          Average Rating 5.0

          5

          100% enrolled

          Tôi nghe nó rất hay.

          • kanghs님의 프로필 이미지
            kanghs

            Reviews 5

            Average Rating 4.8

            5

            100% enrolled

            Tôi có thể cảm nhận được SQL ở một mức độ nào đó chỉ bằng cách giải quyết các vấn đề và thật tuyệt khi họ đưa ra nhiều vấn đề khác nhau.

            Limited time deal

            $328,786.00

            21%

            $15.40

            datarian's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!