강의

N
챌린지

멘토링

N
클립

커뮤니티

Data Science

/

Certificate (Data Science)

SQLD Practice Problem Solutions (2 subjects)

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

(5.0) 1 reviews

23 learners

Level Basic

Course period 2 months

  • y2kdba
SQLD
SQLD
SQLD
SQLD

What you will gain after the course

  • Prepare for the exam for the nationally recognized SQL qualification

  • SQL

SQLD, meticulously executed with practical problems!

SQL Developer Certification Exam
Be perfectly prepared.

What is SQLD ?

The SQLD nationally certified SQL developer qualification exam is an exam that evaluates job performance skills related to database design and implementation and SQL utilization, such as writing SQL and optimizing performance based on knowledge of data modeling.

National Certified SQL Developer Qualification Exam
It helps you prepare.

Regardless of whether you are a development major or not
Anyone can apply .

In this course, you'll learn a comprehensive understanding of the SQL language to facilitate your work in a database. You'll also prepare for the nationally recognized SQL certification exam .

I used "SQL Certification Exam Practice Questions," published by the Korea Data Industry Promotion Agency (KDIA), commonly known as the "Yellow Book," as a recommended textbook for those preparing for the nationally recognized SQL certification exam. I've compiled 26 video explanations for all 146 questions across two subjects in the textbook.

While there are answer sheets for every problem, those who study on their own often find some of the solutions difficult, and most of the content is written in text format. To address this, we 've incorporated graphical explanations to enhance learners' understanding.

I recommend this to these people 🙋

People who have never encountered SQL but want to obtain SQLD certification

Those who have attempted the SQLD exam multiple times but failed to pass

Those who have difficulty understanding the explanations in the SQLD textbook

From the SQL language to the SQLD certification exam ✍️

After taking this course, you will have the SQL knowledge necessary for a career in databases. This course is also open to anyone who wants to learn SQL, even if it's not specifically for the certification exam.

To achieve a high score on the exam, you need to plan ahead and study repeatedly. To ensure sufficient study, we recommend setting aside at least a month for preparation. If you have any questions, please actively utilize the Q&A section.

What you'll learn 📚

This course is divided into three parts, and you will learn Parts 1, 2, and 3 in that order. The structure and content of each part are as follows:

Learn at a glance 🔎

1️⃣

Learn about the types of SQL you can use, SQL-related tasks, components of the SELECT statement, SQL functions, null-related functions, and join concepts.

2️⃣

Learn about data models, self-joins, standard joins, outer joins, set operators, hierarchical queries, GROUP functions, window functions, GRANT and REVOKE, and more.

3️⃣

Learn about the basic principles of SQL optimization, including optimizers, execution plans, execution plan analysis, index basics, index and DML performance, and types of indexes.

Are you curious about the detailed curriculum?

Part 1. SQL Basics and Utilization

  1. Types of SQL
  2. DDL Syntax
  3. Definition of Null Value
  4. DML operations
  5. FOREIGN KEY and DML
  6. DELTE, TRUNCATE
  7. Transaction characteristics
  8. SELECt related to null
  9. WHERE clause of SELECT
  10. SQL functions
  11. Understanding the Date type
  12. SUM(CASE ~ END)
  13. NULL related functions
  14. GROUP function and null
  15. GROUP BY clause
  16. HAVING clause
  17. ORDER BY clause
  18. TOP-N queries
  19. Join concept
  20. Non-equi join

Part 2. Using SQL

  1. Pure relational operators
  2. Data Model and Join
  3. GROUP BY, HAVING
  4. Standard join
  5. Cartesian Product
  6. Results from outer join
  7. set operators
  8. Subqueries and output results
  9. Subqueries and set operators
  10. Set operators and output results
  11. Types of set operators
  12. Hierarchical queries and output results
  13. Understanding hierarchical queries
  14. Writing hierarchical queries
  15. Comparing Hierarchical Queries in Oracle and SQL Server
  16. Self-join
  17. Accumulated value processing
  18. Types of subqueries
  19. Subqueries and joins
  20. Subqueries and UPDATE
  21. View and View Utilization
  22. ROLLUP function, CUBE function, GROUPING SETS
  23. Composition and characteristics of window functions
  24. RANK, DENSE_RANK, ROW_NUMBER
  25. Understanding Window Functions
  26. Window functions and output results
  27. LEAD, LAG
  28. GRANT and REVOKE, ROKE
  29. Distinguishing between permissions and possible actions for GRAN/REVOKE
  30. PL/SQL, stored procedures, triggers, user-defined functions

Part 3. Basic Principles of SQL Optimization

  1. Optimizer and Execution Plan
  2. Execution Plan Analysis
  3. Index Basics
  4. Index and DML performance
  5. Types of indexes
  6. Combined index
  7. Join technique
  8. Subqueries and joins

Expected Questions Q&A 💬

Q. Can I take the course even if I have no background (i.e., no SQL-related knowledge)?

Yes, it is possible.

Q. How much time should I devote to preparing for the exam?

Some people say it takes as little as two weeks, but if you want to pass, you need to prepare for at least a month.

Q. What is the difference between SQLD and SQLP?

SQLD requires passing two subjects, including subject 1 and subject 2. And SQLP can be taken by those who have passed SQLD, in which case you must pass subject 1, subject 2, subject 3, etc.

Introducing the Knowledge Sharer ✒️

History

  • Worked at Samsung SDS (Samsung Everland IS Team, June 1992 - April 2002)
  • Samsung SDS Multicampus Lecture (Database Technology, April 2002 - December 2020)

Things to note before taking the course 📢

Practice environment

  • No separate practical training is conducted in class.

Player Knowledge and Precautions

  • Prior knowledge of SQL fundamentals is helpful, but not required.
  • It is recommended that you memorize the key points summarized in [SQL Qualification Exam Practice Questions], which was adopted as a textbook, as well as the key points additionally explained in the video.

Recommended for
these people

Who is this course right for?

  • For those who want to learn SQL

  • Those preparing for the nationally recognized SQL qualification exam

Need to know before starting?

  • Introduction to SQL

  • Data Modeling

Hello
This is

101

Learners

6

Reviews

4.3

Rating

3

Courses

1. Work and Teaching History:
   1) Worked at Samsung SDS (Samsung Everland IS Team, 1992.06 ~~ 2002.04)
   2) Lectured at Samsung SDS Multicampus (Database Technology field, 2002.04 ~~ 2020.12)

2. Areas of Instruction:
1) Oracle SQL Utilization
2) Oracle SQL Tuning

3. Certifications: ORACLE 7.3 Database Administrator (Acquired 1998.06) ORACLE 8.0 Database Administrator (Acquired 1999.01) -------------------- SQL Certification Exam

3. Certifications:
   ORACLE 7.3 Database Administrator (Acquired 1998.06)
   ORACLE 8.0 Database Administrator (Acquired 1999.01)

----------------------------------------

This course covers both the practice problem sets for the SQL Certification and general SQL learning.

Especially for exam preparation to obtain the SQLD certification,

"SQL Qualification Exam Practical Questions - Korea Data Agency" has been adopted as the textbook.

🔔 Subject 1

🗒 Videos: M1 ~ M9

🗒 Questions: 52 questions in total

🗒 Time: 2 hours 48 minutes 38 seconds

In addition to this, we have prepared materials summarizing the most essential basic knowledge related to learning SQL.

I have also prepared materials summarizing the most essential content to help you build foundational knowledge.

It is also a bit regrettable that the SQL learning is being conducted solely for the purpose of obtaining the SQLD certification.

Of course, we have taken these points into consideration, and to further enhance practical SQL application skills,

I am planning to provide a wide range of information.

To everyone who wishes to learn SQL

I will strive to provide you with useful information.

Thank you.

Curriculum

All

21 lectures ∙ (4hr 47min)

Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • rigingssam님의 프로필 이미지
    rigingssam

    Reviews 17

    ∙

    Average Rating 4.8

    5

    62% enrolled

    $93.50

    y2kdba's other courses

    Check out other courses by the instructor!

    Practical Oracle SQL UtilizationCourse Thumbnail

    Practical Oracle SQL Utilization

    y2kdba

    We would like to provide an opportunity to learn SQL, a language used in relational databases, in general. In particular, we wrote the execution examples in the ORACLE environment. The learning content is largely divided into 2 parts and a total of 11 lectures. After learning the entire content, you can cultivate the ability to perform tasks in a database along with the general knowledge of SQL, and you can also prepare for the nationally certified SQL developer qualification.

    Basic

    Basic

    Oracle, SQL

    Practical Oracle SQL UtilizationCourse Thumbnail

    Practical Oracle SQL Utilization

    y2kdba

    SQLD Practice Problem Solution (1 subject)Course Thumbnail

    SQLD Practice Problem Solution (1 subject)

    y2kdba

    Completely prepare for one subject of the exam for nationally certified SQL developer qualification using the Korea Data Industry Promotion Agency's SQL qualification exam practice questions as a textbook.

    Basic

    Basic

    SQLD

    SQLD Practice Problem Solution (1 subject)Course Thumbnail

    SQLD Practice Problem Solution (1 subject)

    y2kdba

    Similar courses

    Explore other courses in the same field!

    SQLD Practice Problem Solution (1 subject)Course Thumbnail

    SQLD Practice Problem Solution (1 subject)

    y2kdba

    Completely prepare for one subject of the exam for nationally certified SQL developer qualification using the Korea Data Industry Promotion Agency's SQL qualification exam practice questions as a textbook.

    Basic

    Basic

    SQLD

    SQLD Practice Problem Solution (1 subject)Course Thumbnail

    SQLD Practice Problem Solution (1 subject)

    y2kdba

    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

    [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-MajorCourse Thumbnail

    [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-Major

    algolearn

    SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!

    Beginner

    Beginner

    SQL, Big Data, Data Engineering

    [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-MajorCourse Thumbnail

    [2026] SQLD All-in-One: Pass on Your First Try Even as a Non-Major

    algolearn

    Kim Young-han's Practical Database - FundamentalsCourse Thumbnail

    Kim Young-han's Practical Database - Fundamentals

    yh

    Learn the essential fundamentals of SQL and databases needed for practical work. Not only developers, but also product managers and data analysts can learn SQL in depth.

    Basic

    Basic

    SQL, MySQL, DBMS/RDBMS

    Kim Young-han's Practical Database - FundamentalsCourse Thumbnail

    Kim Young-han's Practical Database - Fundamentals

    yh

    Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)Course Thumbnail

    Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

    yh

    Not only developers, but also planners and data analysts learn databases step-by-step, starting from SQL basics.

    Beginner

    Beginner

    SQL, MySQL, DBMS/RDBMS

    Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)Course Thumbnail

    Kim Younghan's Practical Database Introduction - SQL First Steps for All IT Professionals (Step by Step from SQL)

    yh