Inflearn brand logo image
Inflearn brand logo image

N

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

SQLD Yellow title

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

Slide 960 Px-2

Part 2. SQL Basics and Utilization

The lecture has these features!

Figure 1

SQLD 176 Problem Solving

Norangi 176 problem individual lecture provided!

Features of yellowtail

Provides detailed explanations for the overall exam summary

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

Slide 960 Px (1)

Provides SQL practice scripts

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

Slide 960 Px (2)

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)

Slide 960 Px (3)

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.


Slide 960 Px (4)
Slide 960 Px (5)

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.

Slide 960 Px (6)
Slide 960 Px (7)

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

  • ggg9905님의 프로필 이미지
    ggg9905

    Reviews 3

    ∙

    Average Rating 5.0

    5

    45% enrolled

    Materials are provided for a comprehensive exam review, along with practice Oracle and MS SQL scripts, and mock exam solutions. The curriculum is designed for convenient viewing and studying, but it may be a bit difficult to understand for those new to the subject. A more detailed and slower explanation of the problem-solving process and the reasoning behind the solutions would make this an even better lecture.

    • datacodelab
      Instructor

      Hello. Thank you for leaving such a great comment. I understand that the difficulty of the problem may have made it a bit hard to follow. I've added more detailed explanations to the class notes to address the points you mentioned. Thank you, and please feel free to use the questions if you have any difficulties. :) Have a wonderful Saturday. Thank you.

  • jjangdaye2275님의 프로필 이미지
    jjangdaye2275

    Reviews 1

    ∙

    Average Rating 5.0

    5

    30% enrolled

    Thank you for the detailed explanation!

    • datacodelab
      Instructor

      Hello. Thank you for leaving a good review. Not much time left for the exam. :) I'm cheering for you. :) Have a happy day.

  • cmoon781397님의 프로필 이미지
    cmoon781397

    Reviews 1

    ∙

    Average Rating 5.0

    5

    30% enrolled

    • datacodelab
      Instructor

      Hello. Thank you for leaving a good review. The exam is coming up soon. I'll be rooting for you. :)

  • mabbak03254069님의 프로필 이미지
    mabbak03254069

    Reviews 1

    ∙

    Average Rating 5.0

    5

    30% enrolled

    • datacodelab
      Instructor

      Hello. Thank you for leaving a good rating. The test is coming up soon. I will cheer for your success. Thank you. :)

  • ksksks7144님의 프로필 이미지
    ksksks7144

    Reviews 2

    ∙

    Average Rating 5.0

    Edited

    5

    100% enrolled

    Difficulty: Medium-High Recommended for: Those who only want to practice SQLD problems! Great for studying for the SQLD exam! Even after going through concept lectures separately 3 times, I felt stuck on problem-solving, so I'm taking this course to learn how to apply concepts and solve problems. Especially since other problem-solving courses sometimes lack SQL practice, this course having it made it easier to understand. Even when trying to solve the "Yellow Book" problems repeatedly, they are quite difficult, but I'm continuously practicing them while listening to the lecture. I really want to pass this time! + 2025.05.31 Exam Review: Problems similar to those in the "Yellow Book" problem set were included in the exam. So, if you're short on time, I recommend at least solving the problems for Subject 2 before going. Subject 2 appears a lot.

    $30.80

    datacodelab's other courses

    Check out other courses by the instructor!

    [2025] SQLD All-in-One for Non-Majors to Pass in One ShotCourse Thumbnail

    [2025] SQLD All-in-One for Non-Majors to Pass in One Shot

    datacodelab

    SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

    Beginner

    Beginner

    SQLD, Big Data, Data Engineering

    [2025] SQLD All-in-One for Non-Majors to Pass in One ShotCourse Thumbnail

    [2025] SQLD All-in-One for Non-Majors to Pass in One Shot

    datacodelab

    [2025] SQLD Part2 One-Try Pass (Non-Majors)Course Thumbnail

    [2025] SQLD Part2 One-Try Pass (Non-Majors)

    datacodelab

    SQLD, where to begin? A course for those feeling lost, you'll find a changed you after completion. SQLD All-in-One Pass!

    Beginner

    Beginner

    SQLD, Big Data, SQL

    [2025] SQLD Part2 One-Try Pass (Non-Majors)Course Thumbnail

    [2025] SQLD Part2 One-Try Pass (Non-Majors)

    datacodelab

    [2025] SQLD Part1 That Even Non-Majors Can Pass in One TryCourse Thumbnail

    [2025] SQLD Part1 That Even Non-Majors Can Pass in One Try

    datacodelab

    SQLD, where do I even begin? A course for those who feel completely lost; you'll meet a transformed self after finishing the course. SQLD All-in-One Pass!

    Basic

    Basic

    SQLD, erwin, Oracle

    [2025] SQLD Part1 That Even Non-Majors Can Pass in One TryCourse Thumbnail

    [2025] SQLD Part1 That Even Non-Majors Can Pass in One Try

    datacodelab

    [2025] Big Branch Practical! Pass in one shot with the latest past exam solutions (Python)Course Thumbnail

    [2025] Big Branch Practical! Pass in one shot with the latest past exam solutions (Python)

    datacodelab

    Many applicants want to solve past questions. Why is that? Because the question setter refers to past questions. Solving the latest past questions is the shortcut to success.

    Basic

    Basic

    Python, Engineer Big Data Analysis, Big Data

    [2025] Big Branch Practical! Pass in one shot with the latest past exam solutions (Python)Course Thumbnail

    [2025] Big Branch Practical! Pass in one shot with the latest past exam solutions (Python)

    datacodelab

    Similar courses

    Explore other courses in the same field!

    [2025] SQLD All-in-One for Non-Majors to Pass in One ShotCourse Thumbnail

    [2025] SQLD All-in-One for Non-Majors to Pass in One Shot

    datacodelab

    SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

    Beginner

    Beginner

    SQLD, Big Data, Data Engineering

    [2025] SQLD All-in-One for Non-Majors to Pass in One ShotCourse Thumbnail

    [2025] SQLD All-in-One for Non-Majors to Pass in One Shot

    datacodelab

    [2025] SQLD Part2 One-Try Pass (Non-Majors)Course Thumbnail

    [2025] SQLD Part2 One-Try Pass (Non-Majors)

    datacodelab

    SQLD, where to begin? A course for those feeling lost, you'll find a changed you after completion. SQLD All-in-One Pass!

    Beginner

    Beginner

    SQLD, Big Data, SQL

    [2025] SQLD Part2 One-Try Pass (Non-Majors)Course Thumbnail

    [2025] SQLD Part2 One-Try Pass (Non-Majors)

    datacodelab

    Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)Course Thumbnail

    Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)

    coddatg

    For those who feel overwhelmed preparing for the SQLD exam, this is a comprehensive course that analyzes the entire Norang-i scope, organizes necessary theory, conducts practice-focused classes, and solves all problems systematically. With short, concise clips and topic-based segmented structure, you can build skills that work directly in the exam room.

    Basic

    Basic

    SQL, Oracle, MSSQL

    Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)Course Thumbnail

    Hands-on Practice for Mastering SQLD Fundamentals (Subject 2)

    coddatg

    [2025 Revised Edition] Big Data Analysis Engineer Practical Exam (with Python)Course Thumbnail

    [2025 Revised Edition] Big Data Analysis Engineer Practical Exam (with Python)

    eduatoz

    The Certified Big Data Analyst exam is a nationally recognized certification administered twice a year. This course provides detailed lectures covering everything from the basics to the core concepts to help you prepare for the practical exam. The exam difficulty increases with each iteration. To address this, we provide a range of essential content, starting with the fundamentals, to improve your chances of passing.

    Basic

    Basic

    Big Data

    [2025 Revised Edition] Big Data Analysis Engineer Practical Exam (with Python)Course Thumbnail

    [2025 Revised Edition] Big Data Analysis Engineer Practical Exam (with Python)

    eduatoz

    15-day big data pilot projectCourse Thumbnail

    15-day big data pilot project

    빅디

    "Big Data + AI Full Stack Development" - The process of building big data that breathes life into AI is carried out in the form of a pilot project. We identify requirements, configure the platform step by step, and perform smart car data exploration and analysis.

    Basic

    Basic

    Big Data, Hadoop, Kafka

    15-day big data pilot projectCourse Thumbnail

    15-day big data pilot project

    빅디

    SQL Basics from a Silicon Valley Data LeaderCourse Thumbnail

    SQL Basics from a Silicon Valley Data Leader

    keeyonghan9539

    If you work with data, SQL is a fundamental skill you must know. In this course, we will learn SQL from a data analysis perspective, focusing on hands-on practice. The practice will be conducted in Google Colab using DuckDB.

    Basic

    Basic

    SQL, Data literacy, Data Engineering

    SQL Basics from a Silicon Valley Data LeaderCourse Thumbnail

    SQL Basics from a Silicon Valley Data Leader

    keeyonghan9539

    Airflow Basics from a Silicon Valley Data LeaderCourse Thumbnail

    Airflow Basics from a Silicon Valley Data Leader

    keeyonghan9539

    With the advent of the AI era, building data pipelines has become a core competency that determines a company's competitiveness. Learn how to build efficient data pipelines using Airflow, the most widely used tool, directly from a Silicon Valley expert (formerly Head of the Data Team at Udemy, currently a professor in the Data Masters program at San Jose State University) with practical experience and extensive lecturing experience.

    Basic

    Basic

    airflow, snowflake, SQL

    Airflow Basics from a Silicon Valley Data LeaderCourse Thumbnail

    Airflow Basics from a Silicon Valley Data Leader

    keeyonghan9539

    Getting SQL Developer (SQLD) Certification Part 4Course Thumbnail

    Getting SQL Developer (SQLD) Certification Part 4

    usefulit

    It contains only the essentials required to obtain the SQLD certification. This is a learning process that will help you acquire the SQLD certification by solving various examples directly, starting from setting up the development environment and building your skills.

    Basic

    Basic

    SQL

    Getting SQL Developer (SQLD) Certification Part 4Course Thumbnail

    Getting SQL Developer (SQLD) Certification Part 4

    usefulit

    First steps to SQL coding testCourse Thumbnail

    First steps to SQL coding test

    gemmadata

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

    Basic

    Basic

    Coding Test, SQL, MySQL

    First steps to SQL coding testCourse Thumbnail

    First steps to SQL coding test

    gemmadata

    Mathematical Statistics Basics for Non-Majors (Practical)Course Thumbnail

    Mathematical Statistics Basics for Non-Majors (Practical)

    medici

    This course is a course that practices the basics of machine learning mathematics and statistics using Python. Machine learning and deep learning require programming skills, but they also require a mathematical background to understand the principles. Through this course, you can gradually learn the basic mathematics required for artificial intelligence.

    Basic

    Basic

    Linear Algebra, Probability and Statistics, Python

    Mathematical Statistics Basics for Non-Majors (Practical)Course Thumbnail

    Mathematical Statistics Basics for Non-Majors (Practical)

    medici

    [Renewal] First-time SQL and Database (MySQL) Bootcamp [From Beginner to Application]Course Thumbnail

    [Renewal] First-time SQL and Database (MySQL) Bootcamp [From Beginner to Application]

    funcoding

    Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

    Basic

    Basic

    Python, SQL, MySQL

    [Renewal] First-time SQL and Database (MySQL) Bootcamp [From Beginner to Application]Course Thumbnail

    [Renewal] First-time SQL and Database (MySQL) Bootcamp [From Beginner to Application]

    funcoding

    Big Data and Statistical Analysis Using RCourse Thumbnail

    Big Data and Statistical Analysis Using R

    kpcre

    It covers basic data concepts, useful R functions and packages, and data analysis exercises, to allow anyone to perform big data analysis using R programming.

    Beginner

    Beginner

    R, Big Data

    Big Data and Statistical Analysis Using RCourse Thumbnail

    Big Data and Statistical Analysis Using R

    kpcre

    Certification and Practice! Business Information Visualization (Practical) Tableau All in OneCourse Thumbnail

    Certification and Practice! Business Information Visualization (Practical) Tableau All in One

    onepm

    This lecture aims to systematically learn the essential core concepts and functions absolutely necessary for the Business Information Visualization Practical Exam (Tableau), based on the exam guidelines of the organizing institution. It is structured around practical exercises so that you can freely use the functions frequently tested in the actual exam, and through solving mock exam problems of types A and B, you can improve your understanding of the exam types and your problem-solving skills together. Lecture plan and materials can be checked at https://github.com/hansikyung/Tableau_OneTime.

    Basic

    Basic

    Big Data, Tableau

    Certification and Practice! Business Information Visualization (Practical) Tableau All in OneCourse Thumbnail

    Certification and Practice! Business Information Visualization (Practical) Tableau All in One

    onepm

    An easy and fun SQL story with Teacher JangraeCourse Thumbnail

    An easy and fun SQL story with Teacher Jangrae

    jangrae

    Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

    Beginner

    Beginner

    SQL, DBMS/RDBMS, MySQL

    An easy and fun SQL story with Teacher JangraeCourse Thumbnail

    An easy and fun SQL story with Teacher Jangrae

    jangrae

    First time but like an expert with AI – I'm also a data analyst with just ChatGPTCourse Thumbnail

    First time but like an expert with AI – I'm also a data analyst with just ChatGPT

    masocampus

    It's now an era where data speaks, not intuition. Learn data analysis easily with ChatGPT!

    Basic

    Basic

    ChatGPT, Big Data, AI

    First time but like an expert with AI – I'm also a data analyst with just ChatGPTCourse Thumbnail

    First time but like an expert with AI – I'm also a data analyst with just ChatGPT

    masocampus

    Resignation Time if You Don't Know? The Standard Guide to Data EngineeringCourse Thumbnail

    Resignation Time if You Don't Know? The Standard Guide to Data Engineering

    altoformula

    Uncover true value in the age of data! 📊 Designing applications focused on data has now become essential. Develop the insight and skills your company wants with the latest trends and practical case studies. Start now with efficient data processing and design secrets! Your next step, leap into the data-driven world!

    Basic

    Basic

    Big Data, Data Engineering, Architecture

    Resignation Time if You Don't Know? The Standard Guide to Data EngineeringCourse Thumbnail

    Resignation Time if You Don't Know? The Standard Guide to Data Engineering

    altoformula

    Pillow Investment Method: AI Stock Auto-Trading Machine That Makes Money While You SleepCourse Thumbnail

    Pillow Investment Method: AI Stock Auto-Trading Machine That Makes Money While You Sleep

    cheatkeylab

    Revolutionize your stock investments with AI! In this lecture, you will directly build a real, working AI automated trading system targeting the top 25 NASDAQ stocks. We provide a special opportunity to gain experience and know-how through simulated investments with the 한국투자증권 API, and to perform AI stock automated trading with a real account. Even stock beginners will have no problem. We will easily explain basic stock concepts and why you should invest in US stocks, and provide all source code and remote support. From now on, investment is essential for the next 60 years of our lives. Create your own AI investment partner that will be with you!

    Beginner

    Beginner

    Python, Deep Learning(DL), Data Engineering

    Pillow Investment Method: AI Stock Auto-Trading Machine That Makes Money While You SleepCourse Thumbnail

    Pillow Investment Method: AI Stock Auto-Trading Machine That Makes Money While You Sleep

    cheatkeylab

    Probability and Statistics 101Course Thumbnail

    Probability and Statistics 101

    루비네코딩

    Finally, a probability and statistics course for everyone is here! Learn the principles of probability and statistics step by step through theory and coding practice.

    Basic

    Basic

    Probability and Statistics, Big Data, Python

    Probability and Statistics 101Course Thumbnail

    Probability and Statistics 101

    루비네코딩

    Time Series Analysis and ForecastingCourse Thumbnail

    Time Series Analysis and Forecasting

    루비네코딩

    Time Series: Become a Data Analysis Expert! Let's be analysts strong in theory & practice!

    Intermediate

    Intermediate

    Probability and Statistics, Python, Big Data

    Time Series Analysis and ForecastingCourse Thumbnail

    Time Series Analysis and Forecasting

    루비네코딩

    Big Data Analysis and Visualization Using PythonCourse Thumbnail

    Big Data Analysis and Visualization Using Python

    kpcre

    We explored the essential Python syntax necessary for big data analysis and, through various examples, presented methods such as big data file processing and visualization.

    Beginner

    Beginner

    Python, Big Data

    Big Data Analysis and Visualization Using PythonCourse Thumbnail

    Big Data Analysis and Visualization Using Python

    kpcre