First steps to SQL coding test

By solving Leetcode SQL problems, you can understand problem types and improve your SQL implementation skills in a short period of time.

(5.0) 수강평 14개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

Coding Test
Coding Test
SQL
SQL
MySQL
MySQL
Coding Test
Coding Test
SQL
SQL
MySQL
MySQL

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

5.0

5.0

김주아

83% 수강 후 작성

It was great to review the basics of SQL because you explained the concepts that come up in SQL coding tests in detail.

5.0

이승렬

100% 수강 후 작성

At first, I didn't have a feel for it, so I just watched the lecture and followed along, but as I went through the lessons, I started solving the problems before watching the lectures and asked questions about parts that weren't covered in the lectures, and I think I got the feel for it. It was much easier to understand because you answered with sincerity. Thank you!

5.0

재영

29% 수강 후 작성

Thanks to instructor Gemma, I am continuing to grow. Thank you.

강의상세_배울수있는것_타이틀

  • Implementing SQL logic

  • Using SQL functions

  • A quick overview of SQL syntax

SQL coding test problem solving,
Logic implementation + various functions in one lecture!

How much preparation should I do for the SQL coding test?
Where and why is my solution to the problem wrong?

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 analyze only the data you need. Because SQL uses a limited syntax, implementing SQL logic and using the right functions is crucial. Therefore, SQL is the first language you encounter before joining an IT company, especially for data- related positions, from the coding test. It remains essential even after joining the company.

But aren't you sure where to start? Should you start with the basics, like database principles, or is it overwhelming? For now, let's start with solving SQL problems for coding tests !

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

To help you solve general SQL problems in a short period of time, this lecture follows Leetcode 's SQL Easy difficulty problems (Korean translation provided) .

After establishing a solid foundation of knowledge, when I want to improve my skills, I start with simple problem-solving rather than delving into more difficult theories. This naturally allows me to review the concepts, and by solving the problems myself, they stick in my memory longer. Just like how you can't understand math if you only study the theory and don't practice solving problems, you won't understand it.

Don't worry if you can't solve a SQL problem on the first try. There's a gap between knowing the grammar and being able to solve the problem. At first, I couldn't solve the problem on the first try, and it took me a long time. Since it requires practice to familiarize yourself with the problem types, I've designed this course to help you approach it step-by-step with a light heart. Take the first step toward passing this year's SQL coding test!



Perfect for beginners!
First Steps to SQL Coding Test

Direct SQL query in MySQL Workbench + SQL backup via Github integration

The SQL you can query from the Leetcode prompt is limited. Directly verifying the data your SQL produces is essential for improving your skills. Therefore, before solving the problem, 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 your code to GitHub allows you to access it anytime, anywhere, from any device (whether it's your phone or another computer), making it a valuable backup tool. GitHub integration is incredibly useful, not only for SQL, but also for other programming languages!

Provides detailed SQL problem types and homework

Even within Leetcode's Easy difficulty, there are easy and hard levels. We'll start with the easier difficulty level. Beyond difficulty, we've also divided the SQL problems by type. Some are logic-related, like CASE WHEN and GROUP BY, while others are function-related, like LAG, LEAD, and RANK. By categorizing the problems, you can see at a glance how each type of problem will be presented.

For areas requiring additional conceptual explanation, we also provide theory lecture PPTs for students. We also provide assignments and solutions for additional practice on your own. Test your SQL skills for yourself!

Detailed Curriculum

The lecture is largely divided into three parts.

Part 1.
Introduction through very easy difficulty problems

Prepare for SQL coding tests by solving easier problems from Leetcode's Easy difficulty level first.

Part 2.
Logic related types

Solve logic- related problems by type (e.g. join, group by, not in, case when, etc.).

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

Part 3.
Function-related types

Solve function- related problems by type (e.g. rank, dense_rank, row_number, lag, lead, 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 additionally divided into difficulty and type .
  • 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 used in this lecture, but also other programming languages in the future.

Q. Is this a course that non-majors can also take?

No, this course is designed for those with basic SQL knowledge. It's ideal for job seekers preparing for SQL coding tests or those just starting out in data-related fields.

Q. What level of proficiency can I expect to reach after completing this course?

The actual coding test is a mix of algorithmic and SQL questions (plus the occasional Pandas DataFrame processing question). The SQL questions aren't that difficult! (The algorithmic questions are more discriminatory.)
If you follow the lectures carefully and review the code posted on Github before the coding test date, you will be able to solve the SQL section problems without difficulty.


강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • Computer Engineering Major

  • Job seekers preparing for coding tests

  • Data Analyst

선수 지식, 필요할까요?

  • SQL

강의소개.지공자소개

957

수강생

120

수강평

40

답변

4.9

강의 평점

5

강의_other

I am 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 novel 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 more than capable of discovering valuable gems. I would like to share these methodologies with all of you.

 

더보기

커리큘럼

전체

22개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

14개

5.0

14개의 수강평

  • paulmoon008308님의 프로필 이미지
    paulmoon008308

    수강평 111

    평균 평점 4.9

    5

    41% 수강 후 작성

    • blockmonkey1992님의 프로필 이미지
      blockmonkey1992

      수강평 11

      평균 평점 4.8

      5

      60% 수강 후 작성

      • jaeminchoi2011님의 프로필 이미지
        jaeminchoi2011

        수강평 2

        평균 평점 5.0

        5

        32% 수강 후 작성

        • yangjinho8269061님의 프로필 이미지
          yangjinho8269061

          수강평 21

          평균 평점 5.0

          5

          60% 수강 후 작성

          • jk92244137님의 프로필 이미지
            jk92244137

            수강평 2

            평균 평점 5.0

            5

            33% 수강 후 작성

            비슷한 강의

            같은 분야의 다른 강의를 만나보세요!

            강의상세.할인문구

            $2,947.00

            29%

            $26.40