강의

N
챌린지

멘토링

로드맵

BEST
Data Science

/

Certificate (Data Science)

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

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.

(4.6) 62 reviews

709 learners

  • coddatg
SQLD
Oracle
MSSQL
자격증
시험
SQL

Reviews from Early Learners

What you will learn!

  • You can complete the entire Noraengi range and solve problems together that you might get stuck on when working alone.

  • Instead of thick expert guides, you can reduce the learning burden by concisely organizing only the necessary theory.

  • Through the experience of solving problems by directly executing queries in a hands-on environment, you can move away from simple memorization and engage in understanding-based learning.

  • Thanks to the short and segmented lecture structure, you can selectively review only the parts you need and quickly organize everything right before exams.

🤔 “노랭이만 보고 있는데… 막막하시죠?”

SQLD는 ‘직접 쿼리를 다룰 수 있는 능력’을 묻는 시험입니다.
두꺼운 전문가 가이드는 부담스럽고, 노랭이 문제집은 답만 확인하다 끝나기 쉽습니다.

이 강의는 다릅니다.
👉 노랭이 전 범위를 분석해 필요한 이론만 정리하고, 모든 문제를 실습으로 재현합니다.
👉 강의는 짧고 간결하며, 빠른 템포로 나누어져 있어 필요한 부분만 골라 복습할 수 있습니다.

🔑 이런 고민, 여기서 끝내세요.

❌ “노랭이 문제집을 혼자 풀다 보니 답만 보게 돼요.”

👉 노랭이 전 범위 분석 + 핵심 이론 정리
: 모든 문제를 구조화하고, 필요한 이론만 간결하게 정리해 드립니다.

❌ “실전에서 문제를 보면 접근 순서가 헷갈려요.”

👉 실습 위주로 시험 감각 체득
: 정석 풀이 루틴을 반복하며, 시험장에서 바로 풀 수 있는 힘을 길러드립니다.

❌ “강의가 길면 집중을 못 하겠어요.”

👉 짧고 간결한 강의 구성
: 불필요한 설명 없이 핵심만 빠르게, 짧은 클립으로 템포감 있게 학습합니다.

❌ “필요한 부분만 다시 보고 싶은데 힘들어요.”

👉 복습하기 좋은 분할 구조
: 토픽 단위로 나누어져 있어 필요한 부분만 골라 복습할 수 있고, 각 세션마다 퀵 리캡으로 시험 직전에도 빠르게 정리할 수 있습니다.

❌ “환경 세팅 때문에 시작부터 막혀요.”

👉 환경은 간단하고 동일
: 오라클 클라우드 ADB + Wallet, DBeaver로 바로 실습. 로컬 설치 부담 없이 Windows/Mac 어디서든 동일한 환경에서 학습합니다.

🌟 강의의 특징

노랭이 전 범위 분석 + 핵심 이론 정리

  • 노랭이 문제집을 모두 분석해 챕터별로 구조화

  • 두꺼운 전문가 가이드 대신, 필요한 이론만 정리

  • 모든 문제를 실습으로 재현하면서, 출제 의도까지 짚어줌

실습 위주로 시험 감각 체득

  • SQLD는 결국 “문제를 풀 수 있느냐”를 보는 시험

  • 이론 설명은 짧게, 문제 풀이와 정석 풀이 루틴 반복에 집중

  • 시험장에서 헷갈리지 않고 바로 풀 수 있는 힘을 길러줌

짧고 간결한 강의 구성

  • 불필요한 말은 줄이고, 핵심만 빠르게 전달

  • 한 개념·한 문제 단위로 짧은 클립 → 템포감 있게 학습

복습하기 좋은 분할 구조

  • 토픽 단위로 세분화된 섹션 → 필요한 부분만 골라 재생


환경은 간단하고 동일

  • 오라클 클라우드 ADB + Wallet, DBeaver로 실습

  • 로컬 설치 최소화, Windows/Mac 모두 동일 환경

🧑‍💻 이런 분들께 추천해요

SQL 기초는 있는데 시험 준비가 막막한 직장인

기본은 알지만, 시험을 어떻게 준비해야 할지 감이 안 오는 분

SQL을 처음 접하는 대학생/취준생

데이터 직무 준비를 SQLD 자격증으로 시작하고 싶은 분

노랭이 문제집은 샀지만 진도가 안 나가는 수험생

해설이 불친절해 이해가 안 되고, 결국 답만 확인하고 넘어가는 분

🚀 수강 후에는..

✨ 막막했던 시험 내용이 파악됩니다
노랭이 전 범위와 핵심 이론을 구조화해서, 어디서부터 시작하고 무엇을 공부해야 할지 명확해집니다.

✨ 정석 풀이 루틴이 체득됩니다
모든 문제를 실습으로 재현하며, 문제를 읽는 순간 접근 순서가 자동으로 떠오르는 훈련을 하게 됩니다.

✨ 노랭이 문제집을 끝까지 완주합니다
혼자선 답만 보고 넘기던 문제도, 출제 의도와 풀이 과정을 이해하면서 전 범위를 완주할 수 있습니다.

✨ 복습이 훨씬 쉬워집니다
토픽 단위 분할과 퀵 리캡으로, 틀린 문제나 헷갈린 개념만 빠르게 다시 확인할 수 있습니다.

✨ 시험 불안이 줄어듭니다
모든 범위와 문제를 다뤄봤다는 경험 덕분에, 시험장에서 침착하게 정답을 고를 자신감이 생깁니다.

👩‍💻 이 강의를 만든 사람

“10년 넘게 데이터와 씨름한 데이터분석가가 정석대로 SQLD를 낋여드립니다.”

  • 2014~2017: 컴퓨터 사이언스 석사

  • 2017~2019: 출연연 연구원

  • 2021~2023: Y사 데이터 분석가

수강 전 참고 사항

실습 환경

  • DBeaver: 범용 DB 툴로 모든 실습을 진행합니다.

  • Oracle Autonomous Database(ADB): 오라클 클라우드에서 제공하는 클라우드 DBMS 환경을 활용합니다.

    • Wallet 파일 다운로드 후, 바로 접속 가능

    • 별도의 복잡한 설치 없이 안정적이고 동일한 환경 제공

👉 Windows와 Mac 모두에서 동일하게 접속 가능, 클라우드 기반이므로 수강생 누구나 같은 환경에서 실습할 수 있습니다.

  • 웹 컴파일 환경을 제공하는 SQL Fiddle을 일부 사용했습니다.


학습 자료

  • 쿼리 스크립트

  • 요약집

  • 문제 분석 자료


Recommended for
these people

Who is this course right for?

  • Working professionals who use SQL but feel overwhelmed about exam preparation

  • College students/job seekers learning SQL for the first time

  • A test-taker exhausted from solving Noraengi alone

Hello
This is

2,931

Learners

184

Reviews

98

Answers

4.8

Rating

3

Courses

안녕하세요. 따지기 좋아하는 데이터 분석가 땃지 입니다.

Email: coddat.g@gmail.com

LinkedIn: http://www.linkedin.com/in/ddatg

Curriculum

All

245 lectures ∙ (8hr 44min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

62 reviews

4.6

62 reviews

  • inforsysis4952님의 프로필 이미지
    inforsysis4952

    Reviews 2

    ∙

    Average Rating 5.0

    5

    12% enrolled

    In the settings, more detailed instructions are needed for Windows users. However, the instructor helped me directly, so I was able to solve it well. I think there must be people like me, so it would be good to reorganize the settings manual. Since then, I have been listening to the lecture while practicing with Debiber, and I am satisfied with the lecture.

    • coddatg
      Instructor

      Levi! Thank you for trying and following along persistently even though the Windows environment settings guide was insufficient. I think it would be better to make a video guide for that part.. I will try to improve it as soon as possible. Thank you for leaving a review. I hope you study hard and pass the certification ;)

  • bong08220153님의 프로필 이미지
    bong08220153

    Reviews 4

    ∙

    Average Rating 5.0

    5

    32% enrolled

    I sold ducks that year of all years :D

    • coddatg
      Instructor

      Haha.. what the heck happened that year!

  • hyuncheol102님의 프로필 이미지
    hyuncheol102

    Reviews 3

    ∙

    Average Rating 5.0

    5

    95% enrolled

    This is a great lecture that helps a lot when you are preparing for SQLD by just reading yellow books as a non-major.

    • coddatg
      Instructor

      Hello 🙇‍♂️ It brings me great fulfillment as an instructor to hear that this has been especially helpful for those without a technical background 😊 If I was able to make your overwhelming preparation even a little bit easier, that would be my greatest joy 🎉📘 Thank you!

  • yjdevelopers4950님의 프로필 이미지
    yjdevelopers4950

    Reviews 1

    ∙

    Average Rating 5.0

    5

    83% enrolled

    • coddatg
      Instructor

      Wow… To think you'd leave such an amazing review - as an instructor, I truly feel like I've received a wonderful gift 🙏 This review seemed to provide even deeper insights into my course than I had myself, which was so moving, and because I wanted to write a thoughtful reply, I ended up being way too late 😂 As you mentioned, I believe the SQLD exam isn't simply a "memorization test," but rather the core is the process of directly writing queries to discover and internalize the rules. You pinpointed this exactly, which made me reflect on my own course again. Especially the part where you didn't just memorize rules like 'having-group by-select-order by' but understood and internalized why they work that way - I think that's the most fundamental attitude toward SQL. Starting from no background, overcoming the overwhelming feeling through practice, and finally achieving the success of passing - that's truly an amazing journey 🎉 I sincerely hope that this passing experience will serve as a solid foundation not only for SQL but also for data analysis and your overall career going forward 🚀

  • bin26880606님의 프로필 이미지
    bin26880606

    Reviews 1

    ∙

    Average Rating 5.0

    5

    94% enrolled

    The lecture structure is so good If you understand and follow the previous lectures well, you will have no problem understanding the next lectures If you follow it well until the end, you will be familiar with most of the problems The table of contents is also well-divided, so even if you only look at the table of contents after taking the class, - Oh, what was this about..? (click) - Oh, I know this It was so helpful in identifying weak points and saving review time, and on the day of the test. I feel like I got good results

    • coddatg
      Instructor

      bin2688, thank you for leaving a review. Above all, I am happy with this review because I think the intention of planning and creating the lecture was well conveyed. 🥰🥰🥰🥰 I think you probably passed since you listened to the lecture diligently and reviewed it well. 🎉🎉🎉 I hope you get good results ;)

$38.50

coddatg's other courses

Check out other courses by the instructor!

E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice강의 썸네일

E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice

coddatg

Learn SQL not through listing grammar like SELECT and WHERE, but by solving business questions like "What are recent sales?", "Who buys more?", and "What are the Top 5 products?". Practice hands-on in a free environment (BigQuery Sandbox + Looker Studio) and complete analysis results with dashboards. You can gain practical data analysis thinking along with SQL fundamentals without getting bored.

초급

초급

SQL, data-visualization, looker-studio

E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice강의 썸네일

E-commerce Data-Driven Story-Based SQL – BigQuery & Looker Studio Practice

coddatg

For those who haven't even started with SQL, come here강의 썸네일

For those who haven't even started with SQL, come here

coddatg

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

입문

입문

SQL, bigquery

For those who haven't even started with SQL, come here강의 썸네일

For those who haven't even started with SQL, come here

coddatg

Similar courses

Explore other courses in the same field!

SQLD Practice Problem Solutions (2 subjects)강의 썸네일

SQLD Practice Problem Solutions (2 subjects)

y2kdba

A guide to the exam for nationally recognized SQL qualifications! Establish a comprehensive knowledge system related to SQL.

초급

초급

SQLD

SQLD Practice Problem Solutions (2 subjects)강의 썸네일

SQLD Practice Problem Solutions (2 subjects)

y2kdba

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions강의 썸네일

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

입문

입문

SQL, SQLD

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions강의 썸네일

SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

Masocampus

Getting SQL Developer (SQLD) Certification Part 2강의 썸네일

Getting SQL Developer (SQLD) Certification Part 2

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.

초급

초급

SQL

Getting SQL Developer (SQLD) Certification Part 2강의 썸네일

Getting SQL Developer (SQLD) Certification Part 2

usefulit

Easy to understand, SQL secret recipe for everyone강의 썸네일

Easy to understand, SQL secret recipe for everyone

mktcrmer8678

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

초급

초급

SQL, Big Data, Data Engineering

Easy to understand, SQL secret recipe for everyone강의 썸네일

Easy to understand, SQL secret recipe for everyone

mktcrmer8678

Getting SQL Developer (SQLD) Certification Part 4강의 썸네일

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.

초급

초급

SQL

Getting SQL Developer (SQLD) Certification Part 4강의 썸네일

Getting SQL Developer (SQLD) Certification Part 4

usefulit

Level up your query skills (advanced T-SQL queries) with SQL Server consultants강의 썸네일

Level up your query skills (advanced T-SQL queries) with SQL Server consultants

sqlexpert

Learn how to use the most commonly and importantly used advanced T-SQL queries in practice from a SQL Server expert consultant and Microsoft MVP, so you can write SQL in a more SQL-like way.

중급이상

중급이상

SQL

Level up your query skills (advanced T-SQL queries) with SQL Server consultants강의 썸네일

Level up your query skills (advanced T-SQL queries) with SQL Server consultants

sqlexpert

[2025] SQLD All-in-One for Non-Majors to Pass in One Shot강의 썸네일

[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!

입문

입문

SQLD, Big Data, Data Engineering

[2025] SQLD All-in-One for Non-Majors to Pass in One Shot강의 썸네일

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

datacodelab

SQLD Certification Preparation Course강의 썸네일

SQLD Certification Preparation Course

SoYoung Yoon

This course aims to acquire the state-authorized SQLD certification. SQLD refers to a developer who, based on database and data modeling knowledge, can write accurate SQL for manipulating and extracting data while developing application software.

입문

입문

SQL, SQLD

SQLD Certification Preparation Course강의 썸네일

SQLD Certification Preparation Course

SoYoung Yoon

SQL that makes it easy to learn the core강의 썸네일

SQL that makes it easy to learn the core

Masocampus

Skip the complicated theories and concepts and just write SQL statements, practice, and follow along!

입문

입문

SQL, MySQL

SQL that makes it easy to learn the core강의 썸네일

SQL that makes it easy to learn the core

Masocampus

SQL Query Book to Find and Use When You Need It, Part I강의 썸네일

SQL Query Book to Find and Use When You Need It, Part I

swa

Sometimes, data processing is blocked and frustrating. If you are not a professional programmer or developer, learning unfamiliar fields such as Python or Java is not easy and there is not enough time. This is for those who only know Excel and SQL basics when it comes to frequently used things. This is the first part of the SQL query book that you can find and use when you need it.

초급

초급

SQL, MariaDB, HeidiSQL

SQL Query Book to Find and Use When You Need It, Part I강의 썸네일

SQL Query Book to Find and Use When You Need It, Part I

swa

Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving강의 썸네일

Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving

Neo

Learning by Doing: 정보처리산업기사 I have prepared everything for passing the 정보처리산업기사 course-evaluation practical exam.

입문

입문

HTML/CSS, Java, SQL

Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving강의 썸네일

Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving

Neo

SQL data analysis learned through various cases강의 썸네일

SQL data analysis learned through various cases

dooleyz3525

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

중급이상

중급이상

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases강의 썸네일

SQL data analysis learned through various cases

dooleyz3525

Information Processing Technician Written Exam강의 썸네일

Information Processing Technician Written Exam

hoonteam

It contains the contents that are absolutely necessary for the Information Processing Technician written exam. You can systematically study the subjects of General Electronic Calculator, Package Utilization, PC Operating System, and General Information and Communications.

입문

입문

Computer Architecture, Operating System, database

Information Processing Technician Written Exam강의 썸네일

Information Processing Technician Written Exam

hoonteam

Fashion Retail Analysis강의 썸네일

Fashion Retail Analysis

pnuswedu

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!

입문

입문

scm, SQL, Google Analytics

Fashion Retail Analysis강의 썸네일

Fashion Retail Analysis

pnuswedu