CertNote/ Commute Study Notes
Roadmap
KOEN
CLF-C02 · FoundationalCloud Practitioner - Foundational
DVA-C02 · AssociateDeveloper - Associate
SAA-C03 · AssociateSolutions Architect - Associate
SOA-C02 · AssociateCloudOps Engineer - Associate
SAP-C02 · ProfessionalSolutions Architect - Professional
DOP-C02 · ProfessionalDevOps Engineer - Professional
Linux Master 2 · 2급KAIT Linux Master - Level 2
SCS-C03 · SpecialtySecurity - Specialty
Linux Master 1 · 1급KAIT Linux Master - Level 1
MLA-C01 · AssociateMachine Learning Engineer - Associate
AIF-C01 · FoundationalAI Practitioner - Foundational
DEA-C01 · AssociateData Engineer - Associate
MLS-C01 · SpecialtyMachine Learning - Specialty
SQLD · 개발자SQL Developer (SQLD)
  • Week 1
    • 1.Data Modeling Overview
    • 2.Three-Level Schema and Modeling Stages
    • 3.Entities
    • 4.Attributes
    • 5.Relationships
  • Week 2
  • Week 3
  • Week 4
  • Week 5
  • Week 6
  • Week 7
  • Week 8

© CertNote · 주간랩스

  • About
  • Changelog
  • Contact
  • Terms
  • Privacy
← All certifications/SQLD

SQL Developer (SQLD)

8 weeks · 40 days · Developer

Start with Week 1

Read SQLD pass reviews →

Exam Information

Entry to intermediate · Even first-time SQL learners can prepare in 8 weeks
Passing
총점 60점 이상 (과목별 40% 미만 과락)
StageQuestionsDurationFormatCost
필기50문항 (1과목 10 · 2과목 40)90min객관식, 문항당 2점50,000원

Domain Weights

Understanding Data Modeling20%
SQL Fundamentals and Application80%
PrerequisitesThere are no eligibility requirements to take the exam.
LanguagesKorean

Benefits & Tips

  • Passing earns you a 50% discount voucher for your next exam. Find it under "Benefits" in your AWS Certification account and use it for recertification or another certification (it has an expiry date, so use it before then).
  • The certification is valid for 3 years and must be renewed before it expires. You can use the 50% voucher for recertification too.
  • There is no free retake (every attempt is paid in full). Passing on the first try is the cheapest route, so take the real exam once your mock exam scores clear the passing mark.
  • Passing also earns you a Credly digital badge that you can add to LinkedIn and your email signature.

FAQ

How is the SQLD exam administered?+

You answer 50 multiple-choice questions in 90 minutes. Subject 1, Understanding Data Modeling, has 10 questions (20 points), and Subject 2, SQL Fundamentals and Application, has 40 questions (80 points), at 2 points per question.

What is the passing standard?+

A total score of 60 or higher passes. However, scoring below 40% in any subject is an automatic fail, so you must score above 8 of 20 points in Subject 1 and above 32 of 80 points in Subject 2.

Are there eligibility requirements?+

No. Anyone can take the exam.

How many times a year is the exam held?+

It is held regularly four times a year. The exam fee is KRW 50,000, and you can check the registration period for each session on the registration page of the Korea Data Agency's data certification website.

Which DBMS syntax do the questions use?+

Oracle syntax is the baseline, and some questions ask about differences from SQL Server (such as TOP and the + string concatenation operator). That is why the example results in these notes were verified by running them on a real Oracle database.

Official Exam Guide Register for Exam

Week 1

  • Day 1Data Modeling Overview
  • Day 2Three-Level Schema and Modeling Stages
  • Day 3Entities
  • Day 4Attributes
  • Day 5Relationships

Week 2

  • Day 1Identifiers
  • Day 2Normalization
  • Day 3Denormalization
  • Day 4Relationships and Joins, and the Transactions a Model Expresses
  • Day 5Null Attributes and Natural vs Surrogate Identifiers

Week 3

  • Day 1Relational Databases and SELECT
  • Day 2Character and Numeric Functions
  • Day 3Date and Conversion Functions
  • Day 4NULL Functions and CASE·DECODE
  • Day 5The WHERE Clause

Week 4

  • Day 1GROUP BY and Aggregate Functions
  • Day 2HAVING and Execution Order
  • Day 3The ORDER BY Clause and Sorting
  • Day 4Joins (EQUI, Non-EQUI, (+))
  • Day 5Standard Joins (ANSI)

Week 5

  • Day 1Subquery Basics
  • Day 2Correlated Subqueries, Scalar Subqueries, and Inline Views
  • Day 3Set Operators
  • Day 4Group Functions ROLLUP and CUBE
  • Day 5GROUPING SETS and the GROUPING Function

Week 6

  • Day 1Ranking Functions
  • Day 2Aggregate and Row-Order Window Functions
  • Day 3Top N Queries
  • Day 4Hierarchical Queries
  • Day 5Self Join

Week 7

  • Day 1The PIVOT and UNPIVOT Clauses
  • Day 2Regular Expressions
  • Day 3Data Manipulation Language, DML (INSERT·UPDATE·DELETE·MERGE)
  • Day 4Transaction Control Language, TCL (COMMIT·ROLLBACK·SAVEPOINT)
  • Day 5Data Definition Language (DDL) and Data Control Language (DCL)

Week 8

  • Day 1Pitfalls Roundup 1 (NULL and COUNT)
  • Day 2Pitfalls Roundup 2 (Execution Order and Joins)
  • Day 3Differences Between Oracle and SQL Server
  • Day 4Subject 1 Wrap-Up
  • Day 5Subject 2 Wrap-Up