๊ฐ•์˜

๋ฉ˜ํ† ๋ง

์ปค๋ฎค๋‹ˆํ‹ฐ

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

1,131 learners

Level Intermediate

Course period 3 months

  • datarian
  • sunmiyoon
  • jaemin
SQL
SQL
SQL
SQL

Reviews from Early Learners

Reviews from Early Learners

4.9

5.0

ํ—ฌ๋กœ์›”๋“œ

100% enrolled

Why do I feel like it's not enough even though I've completed all the lectures.. When I spend time solving problems and looking at the explanations, I think, 'Wow, how did they come up with that method!?'ใ…  I'm looking forward to the next lecture.

5.0

๊ฐœ๋ฐœ์ž๋Š”๊ฐœ๋ฐœ

100% enrolled

Okay. If you listen to all the lectures, you can easily solve the SQL in Programmers. It really feels easy.

5.0

Juyeon

100% enrolled

I heard it so well~

What you will gain after the course

  • 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

23,249

Learners

2,731

Reviews

28

Answers

4.9

Rating

35

Courses

Experienced working analysts with solid practical backgrounds design the data analysis curriculum and teach the classes themselves.

If you want to learn more about Datarian

๐Ÿ‘‰ย https://datarian.io/

Curriculum

All

29 lectures โˆ™ (2hr 55min)

Published:ย 
Last updated:ย 

Reviews

All

50 reviews

4.9

50 reviews

  • john๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
    john

    Reviews 27

    โˆ™

    Average Rating 4.9

    5

    100% enrolled

    Why do I feel like it's not enough even though I've completed all the lectures.. When I spend time solving problems and looking at the explanations, I think, 'Wow, how did they come up with that method!?'ใ…  I'm looking forward to the next lecture.

    • rebuild29643122๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
      rebuild29643122

      Reviews 6

      โˆ™

      Average Rating 5.0

      5

      100% enrolled

      Okay. If you listen to all the lectures, you can easily solve the SQL in Programmers. It really feels easy.

      • jayjykim911898๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
        jayjykim911898

        Reviews 1

        โˆ™

        Average Rating 5.0

        5

        100% enrolled

        I heard it so well~

        • vinegun1366๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
          vinegun1366

          Reviews 5

          โˆ™

          Average Rating 5.0

          5

          100% enrolled

          I heard it so well.

          • kanghs๋‹˜์˜ ํ”„๋กœํ•„ ์ด๋ฏธ์ง€
            kanghs

            Reviews 5

            โˆ™

            Average Rating 4.8

            5

            100% enrolled

            I was able to get a feel for SQL just by solving the problems, and I liked that they presented a variety of problems.

            datarian's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!