Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Data Science

/

Certificate (Data Science)

[2025] SQLD Problem Solutions - 176 Yellow Problems for Those Who Find SQLD Questions Difficult

SQLD Yellow Book 176 Problem Solving Lecture for You Who Studied but Cannot Solve Problems. After Completing the Course, You Will Become an Expert Beyond Passing. SQLD All-in-One Pass!

(4.9) 7 reviews

109 learners

  • datacodelab
SQLD
자격증
시험
SQL
Big Data
Oracle
MSSQL

Reviews from Early Learners

What you will learn!

  • SQLD Exam Final Review with Practice Problems

  • Oracle and SQL Server Query Practice

  • Mastering SQL: From Complex to Simple Queries

For those of you who studied hard but still can't solve the problem

This is a lecture on solving Norangi's real-life problems.

SQLD - Yellowtail Practice Problem Solution

In SQL, solving practical problems is especially important.

I studied hard for both SQL theory and practice, but when I actually look at a SQLD problem, my mind goes blank.

This is the experience of almost 99% of test takers.

It's not easy to solve a problem that has a bunch of black SQL queries on a white surface.

Moreover, it is difficult because they do not disclose the previous exam questions .

So, I developed a lecture on solving real-life problems that everyone should solve, also known as the Norangi Past Questions . The Norangi Problems are in a book published by the organization that issues the exams, the Korea Data Industry Promotion Agency . They are the closest to real-life problems.


Why you should choose this course:

  • Norangi 176 problem complete explanation : Provides even the errors in the existing Norangi explanation

  • Provides practice scripts : Oracle, MSSQL Server practice scripts and data

  • 3rd mock exam provided : Ending with Norangi? No! 3rd mock exam provided that you can solve on your own

Note: Please read the information below carefully before applying for the course. 🙂

  • Recommended for intermediate and above level users who have completed theoretical studies.

  • Beginners should study the theory first before taking the class. The content may be more difficult than you think.

  • The problem-solving lectures focus on solving problems. You need to find and study the theoretical parts on your own.

The SQLD certification is your first step toward becoming a data & big data expert.
Take on the challenge now! 🚀

Your selection is successful! Choose the lectures for each part of the SQLD All-in-One Pass.

Slide 960 Px

All in one

Slide 960 Px-1

Part 1. Data Modeling

Part 2. SQL Basics and Utilization

The lecture has these features!

SQLD 176 Problem Solving

Norangi 176 problem individual lecture provided!

Provides detailed explanations for the overall exam summary

From problem solving to summarizing key theories, it's all possible!

Provides SQL practice scripts

For ORACLE + MS SQL Server practice
Environment setup guide + script + data provision

SQLD Practice Test 3rd Session

A shortcut to passing the exam in one go!
150 most similar practice exam questions, 3rd time provided!

Learning Contents

  • Qualification test practice problem solving + final summary of learning content + practice guide provided

  • Improve your practical problem-solving skills and practical skills through SQL practice (on Oracle + MS SQL Server)

Section (1) Understanding Data Modeling

You can learn core concepts by solving practical data modeling problems.

Detailed explanation + complete understanding of concepts, that's the shortcut to passing.

Section (2) Data Model and SQL

I will teach you how to easily solve complex and difficult modeling problems. Sometimes it is difficult to solve problems using only normal methods.

Let me tell you how to solve the problem effectively, not through shortcuts.


Section (3) SQL Basics

Modeling is essential to becoming a competent SQL expert.

Explain SQL by drawing ERD through data modeling.


Section (4) Using SQL

Practice! We provide practice guides, scripts, and data for a complete understanding.

The practice environment is Oracle + MS SQL Server. Oracle is used as the primary environment, and MS SQL Server is used as the secondary environment.

Section (5) Management syntax

Solve database and DBMS management syntax problems using the four types of SQL: DDL, DML, TCL, and DCL. Organize your learning with well-organized explanations.


Things to note before taking the class

  • The Korea Data Industry Promotion Agency (Korea Data Industry Promotion Agency) does not provide the Norangi Problem Sheet due to the possibility of intellectual property rights infringement.

  • The SQL practice environment is based on Docker Container. You can do it easily by following the lecture.

Practice environment

  • Operating System and Version (OS): Windows, Linux

  • Tools used: Oracle, MS SQL Server

  • PC specifications: Requires at least 30G of free disk space

Learning Materials

  • Norangi commentary (pdf), practice script (SQL file), SQL Server vs Oracle comparison (pdf)

  • 5 sets of practice exam questions (pdf)

Player Knowledge and Notes

  • Those who have studied SQLD Part 1, Part 2 or have similar level of skills

Recommended for
these people

Who is this course right for?

  • People who studied but find problems difficult

  • Wanting final review with practice problems

  • Those who want to enhance practical skills by improving query understanding

Need to know before starting?

  • Basic SQL Knowledge

  • Someone who studied SQLD Part1, Part2

Hello
This is

338

Learners

40

Reviews

43

Answers

4.8

Rating

5

Courses

공부하고 전파하는 것을 좋아합니다. 빅데이터와 인공지능에 오랜 경력이 있습니다.

  • 20년 현업 데이터분석가 경력, 5년 데이터 분석 강의!

  • 빅데이터 및 인공지능 분야 기업 및 공공기관 자문 및 출강

  • 빅데이터 분석기사 한권완성 필기, 실기 저자

  • 인공지능 분야 스타트업 대표

Curriculum

All

190 lectures ∙ (12hr 26min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

7 reviews

4.9

7 reviews

  • 공부하는문과생님의 프로필 이미지
    공부하는문과생

    Reviews 3

    Average Rating 5.0

    5

    45% enrolled

    시험 총 정리를 위한 자료가 제공되고 실습 가능한 오라클, msSql 실습 스크립트, 모의고사 풀이가 제공됩니다. 보고 공부하기 매우 편리하게 커리큘럼이 짜여져 있으나, 처음 접하는 분들이라면 조금 이해가 어려우실 수 있습니다. 문제를 풀어나가는 과정이나 왜 이렇게 나오는지에 대해 조금 더 자세하고 천천히 알려주시면 더욱 좋은 강의가 될 것 같습니다.

    • 데이터코드랩
      Instructor

      안녕하세요. 좋은 의견 남겨주셔서 감사드립니다. 문제의 난이도가 있다보니, 이해가 좀 어려웠을 수 있을거 같네요. 말씀하신 점을 보완하기 위해서 수업노트에 설명을 조금 더 상세하게 보완해두었습니다. 감사드리구요. 혹시 어려운 점이 있으면 질문을 활용해주시길 부탁드릴게요. :) 즐거운 토요일 보내세요. 감사합니다.

  • 장다예님의 프로필 이미지
    장다예

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    꼼꼼한 설명 감사합니다!

    • 안녕하세요. 좋은 수강평 남겨주셔서 감사합니다. 시험 얼마 안 남았네요. :) 응원합니다. :) 행복한 하루 보내시구요.

  • cmoon78님의 프로필 이미지
    cmoon78

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    • 안녕하세요. 좋은 수강평 남겨주셔서 감사드려요. 이제 시험이 얼마 안남았군요. 응원하겠습니다. :)

  • jin님의 프로필 이미지
    jin

    Reviews 1

    Average Rating 5.0

    5

    30% enrolled

    • 안녕하세요. 좋은 평점 남겨주셔서 감사드립니다. 시험이 얼마 안남았네요. 합격 응원하겠습니다. 감사합니다. :)

  • MK24님의 프로필 이미지
    MK24

    Reviews 2

    Average Rating 5.0

    Edited

    5

    100% enrolled

    난이도: 중상 추천 대상: SQLD 문제풀이만 하고 싶은 분들이 수강하면 좋아요! SQLD 시험 공부하기 정말 좋아요! 저는 개념강의 따로 3번 돌려도 문제풀이가 안되는 것 같아서 이 강의 듣으면서 개념을 어떻게 적용하고 풀어야 하는지 배우고 있습니다. 특히 다른 문제 풀이 강의들은 SQL 실습이 없는 경우도 있는데, 이 강의는 있어서 좀 더 이해하기 좋았습니다. 반복적으로 풀어보려고 해도 노랭이 문제가 많이 어려운데 강의 듣으면서 계속 반복적으로 풀고 있습니다. 이번에 꼭 합격하고 싶어요! + 2025.05.31 시험 후기: 노랭이 문제집에 있는 문제와 비슷하게 출제되었어요. 그러니 시간 없다면 2과목만이라도 풀고 가시는 것 추천합니다. 2과목이 많이 나와요.

    • 안녕하세요. 좋은 수강평 남겨주셔서 감사합니다. 시험이 얼마 안남았네요. 꼭 합격하시길 빌겠습니다. 감사합니다.

$30.80

datacodelab's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!