강의

멘토링

커뮤니티

Programming

/

Database

The final step for SQL coding test

As you work through more difficult Leetcode SQL problems, you'll learn how to apply multiple grammar rules to a single problem.

(5.0) 4 reviews

95 learners

Level Intermediate

Course period Unlimited

  • Gemma
Coding Test
Coding Test
SQL
SQL
MySQL
MySQL
Coding Test
Coding Test
SQL
SQL
MySQL
MySQL

Reviews from Early Learners

Reviews from Early Learners

5.0

5.0

김주아

88% enrolled

I took this course because I liked the previous one so much. The teacher was very thorough, so it was very helpful. I highly recommend taking these two courses if you are preparing for a SQL coding test 😊😊

5.0

이승렬

100% enrolled

As an extension of the pre-lecture, I think it helped me a lot in solving more difficult problems.

5.0

미나리

14% enrolled

I took the beginner level, but I liked the teacher's teaching style, so I completed the intermediate level! I was about to take a coding test, and this lecture was good because I was able to solve a lot of problems. It would be more useful for those who are taking it before the test or want to apply it right away in real life.

What you will gain after the course

  • Implementing SQL logic

  • Using SQL functions

  • Use various SQL syntax at once

SQL coding test problem solving,
From various functions to logic implementation, all in one place!

Why the SQL Coding Test Was Difficult
Even complex solutions are explained clearly!

SQL coding tests aren't limited to a single grammar question! This course will help you solve challenging problems that mix multiple grammar questions .

SQL closely related to data jobs

SQL is a programming language that helps you uncover insights and trends hidden in vast amounts of data. You can also extract and examine only the specific data you need. Because it uses a limited syntax, implementing clear logic and using the right functions is crucial.

Therefore, SQL is the first language you encounter before joining an IT company, especially if you're in a data-related position, even during the coding test. It remains an essential language even after joining the company.

Player course

For those who don't know where to start preparing, I recommend taking the First Steps to SQL Coding Test course first.

In this pre-course, we'll follow Leetcode 's SQL Easy difficulty problems to help you cover the general SQL problem types in a short amount of time.

This lecture

This course, consisting of Leetcode 's Medium-difficulty SQL problems (with Korean translations) , presents comprehensive problems that blend all aspects of grammar and function. Rather than focusing solely on single-logic problems, you'll practice organically connecting SQL grammar to solve problems that mix multiple logics.

To reduce the burden and increase efficiency.

🙋‍♀️ Job seekers preparing for coding tests

🙋‍♀️ Those who want to refer to SQL solutions and apply them to their work

🙋‍♀️ For those who find learning through examples more effective than theory


Take your skills to the next level
The final step of the SQL coding test

Setting up the environment for SQL queries and backups

The SQL you can query in the LeetCode prompt is limited. To improve your skills, it's essential to directly verify the data your queries produce. Therefore, before solving the problems, we'll install MySQL and set up the environment to query SQL in Workbench.

We'll also set up an environment that integrates with GitHub. Uploading code to GitHub allows you to access it anytime, anywhere, from any device, making it a great backup solution. This GitHub integration is incredibly useful, as it can be used not only for SQL but also for other programming languages!

Provides detailed SQL problem types and homework

Leetcode offers two difficulty levels, Easy and Hard. We'll start with the Easy difficulty level.

In addition to difficulty, we've categorized SQL questions by type. These range from logic-related questions like CASE WHEN and GROUP BY to function-related questions like LAG, LEAD, and RANK. We've organized the questions so you can see at a glance how each type of question will be presented.

We also provide theory lecture PPTs for areas requiring additional conceptual explanation. Interval homework and solutions are also provided for independent practice. Test your SQL skills for yourself!

Detailed Curriculum

The lecture is largely divided into two parts.

Part 1. Function-related types

Solve function-related problems by type (e.g. rank, dense_rank, lag, lead, etc.).

After querying the SQL step by step with MySQL Workbench, we derive the final query.

Part 2. Logic-related types

Solve logic-related problems by type (e.g., having, limit, sum, not in, case when, etc.).

After querying the SQL step by step with MySQL Workbench, we derive the final query.


Q&A 💬

Q. What makes this course different?

  • Leetcode problems are provided by type .
  • Solve complex, difficult problems that mix all the grammar and functions.
  • We provide environment settings that allow you to directly check intermediate SQL results while installing MySQL Workbench .
  • By installing Github together, we provide an environment setting that can back up not only the SQL of this lecture but also other programming languages in the future.

Q. Can I listen without prior related knowledge?

No, this course is intended for those who have already taken the prerequisite course, " First Steps to the SQL Coding Test ." It's also an effective course for those just starting out in data science.

Q. What level can I reach after completing the course?

The actual SQL coding test isn't that difficult, so just attending the preparatory lectures should be sufficient. However, if you want to apply various grammar techniques to a single problem or practice organically connecting different logics, this course will help you level up.

Recommended for
these people

Who is this course right for?

  • Computer Engineering Major

  • Job seekers preparing for coding tests

  • Data Analyst

Need to know before starting?

  • SQL

Hello
This is

943

Learners

118

Reviews

40

Answers

4.9

Rating

5

Courses

I'm Gemma, a data analyst who started in mathematics, moved into a developer career, and eventually settled into my current role after studying statistics. In data analysis, the most important thing is identifying fresh insights and trends within the overflowing sea of big data. That’s easier said than done, right? However, if you can utilize the right analysis tools and methods, anyone is capable of discovering valuable gems. I would like to share these methodologies with you.

  • (Current) Data Analyst at LINE Plus

  • (Former) NAVER Data Analyst

  • MS in Applied Statistics, Politecnico di Milano, Italy

  • Bachelor of Science in Mathematics, Ewha Womans University (Double Major in Computational Science, Minor in Computer Science)

  • https://blog.naver.com/italian-lesson

    (Personal Blog)

    MS in Applied Statistics, Politecnico di Milano BS in Mathematics, Ewha Womans University (Double Major in Computational Science, Minor in Computer Science) https://blog.naver.com/italian-lesson (Personal Blog)

Curriculum

All

14 lectures ∙ (1hr 50min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

4 reviews

5.0

4 reviews

  • ss606444110님의 프로필 이미지
    ss606444110

    Reviews 2

    Average Rating 5.0

    5

    88% enrolled

    I took this course because I liked the previous one so much. The teacher was very thorough, so it was very helpful. I highly recommend taking these two courses if you are preparing for a SQL coding test 😊😊

    • iceicebear님의 프로필 이미지
      iceicebear

      Reviews 3

      Average Rating 5.0

      5

      100% enrolled

      As an extension of the pre-lecture, I think it helped me a lot in solving more difficult problems.

      • minaly939103님의 프로필 이미지
        minaly939103

        Reviews 2

        Average Rating 5.0

        5

        14% enrolled

        I took the beginner level, but I liked the teacher's teaching style, so I completed the intermediate level! I was about to take a coding test, and this lecture was good because I was able to solve a lot of problems. It would be more useful for those who are taking it before the test or want to apply it right away in real life.

        • ansgus8293님의 프로필 이미지
          ansgus8293

          Reviews 1

          Average Rating 5.0

          5

          21% enrolled

          Thank you so much, it helped me a lot

          $17.60

          Gemma's other courses

          Check out other courses by the instructor!

          Similar courses

          Explore other courses in the same field!