Getting SQL Developer (SQLD) Certification Part 2

Name: Getting SQL Developer (SQLD) Certification Part 2
Price: 55000 KRW
Rating: 4 (24 reviews)

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.

(4.0) 24 reviews

22,935 learners

Level Basic

Course period 12 months

usefulit

SQL

Reviews from Early Learners

4.0

5.0

everick9

14% enrolled

Thank you~!

5.0

할수있다

100% enrolled

Thank you, I listened carefully

5.0

abc2752

100% enrolled

The detailed explanation was really good

What you will gain after the course

What you need to know to get SQLD certification
Understanding Data Modeling
Understanding data models and performance

Learn the essentials and earn your SQLD certification! 🏅

📣 Please check before taking the class!

This course does not offer Q&A sessions with knowledge sharers . Please keep this in mind when attending.
This lecture is a continuation of Part 1 of Obtaining SQL Developer (SQLD) Certification .
The audio for this lecture was recorded somewhat softly. Please check the [Preview] video before attending the lecture.

Anyone interested in getting SQLD certification? 🙋

The SQLD certification is a nationally recognized qualification designed to cultivate individuals with a deep understanding of SQL execution principles and the specialized knowledge to effectively use it. This course covers development environment setup, core content essential for passing the exam, and problem-solving.

SQL developers must possess a foundational understanding of data modeling, as well as specialized knowledge in database object design and implementation, including SQL writing and performance optimization. Obtaining the SQLD certification can significantly enhance your query writing skills for design-based modeling tasks, providing valuable practical benefits.

Learning Objectives ✨

You can earn SQLD certification by understanding the core content and working through various examples.

_{From the lecture contents of 'Explanation and specific practice of the concept, features, pros and cons of views'}

_{Among the contents of the lecture 'Built-in (numeric function, DECODE (function, CASE statement practice')}

_{From the lecture 'Solving Verification Problems'}

SQLD Certification Series 📚

Recommended for
these people

Who is this course right for?

Anyone who wants to obtain SQLD certification
Anyone who wants to become a SQL developer

Need to know before starting?

Hello
This is usefulit

8,280,939

Learners

6,657

Reviews

4.6

Rating

336

Courses

I will help you grow through useful IT lectures.

Curriculum

All

36 lectures ∙ (18hr 31min)

Course Materials:

Lecture resources

Section 1. SQL_Basic 1

12 lectures ∙ (6hr 16min)

1. Description of types of DB (hierarchical, network, relational), concepts and types of DBMS
31:35
2. Description and practice of DDL, DML, DCL, and TCL command types
32:20
3. Specific practice on DDL, DML, DCL, and TCL command types
34:11
4. Description of transaction concepts, features, and SQL statement execution process (parsing, execution, and retrieval)
29:49
5. Description of DESC command, constraints (primary key, foreign key, default, not null), and On Delete Cascade option
30:40
6. DESC command, specific practice on constraints (primary key, foreign key, default, not null)
32:55
7. Concrete practice on constraints (on cascade), adding, changing, deleting columns in alter table, and deleting constraints
37:46
8. Explanation of the concept, features, pros and cons of views and specific practice
30:43
9. Explanation of INSERT, SELECT, NOLOGGING, UPDATE, DELETE, TRUNCATE statements and practice of INSERT
34:39
10. Practice NOLOGGING, UPDATE, DELETE, TRUNCATE statements
16:20
11. Description of ORDER BY, DISTINCT, ALIAS, SQL operators, LIKE, wildcards, BETWEEN AND, IN()
32:57
12. Specific practice on ORDER BY, DISTINCT,ALIAS, SQL operators, LIKE, wildcards, BETWEEN AND, IN()
32:58

Section 2. SQL_Basic 2

13 lectures ∙ (6hr 46min)

13. Description of NULL-related functions, GROUP BY clause, HAVING clause, and aggregate functions
30:28
14. Specific practice on NULL-related functions, GROUP BY clause, HAVING clause, and aggregate functions
33:25
15. SELECT statement execution order, type conversion, DUAL table, built-in (explanation of character type functions)
30:30
16. Description of built-in (numeric functions, DECODE (function, CASE statement)
21:02
17. DUAL table, built-in (character type, date type function practice)
26:32
18. Built-in (numeric function, DECODE (function, CASE statement practice)
28:35
19. Description of ROWNUM, ROWID, and WITH clauses
31:46
20. Description of GRANT, REVOKE, COMMIT, ROLLBACK, SAVEPOINT
33:28
21. Concrete practice on ROWNUM, ROWID, and WITH clauses
26:34
22. Concrete practice on GRANT, REVOKE, COMMIT, ROLLBACK, SAVEPOINT
35:23
23. Solving past exam questions
40:31
24. Previous Exam Questions - 37th Solution - 1
33:27
25. Previous Exam Questions - 37th Solution - 2
34:45

Section 3. SQL_Utilization

11 lectures ∙ (5hr 28min)

26. Explanation of EQUI join, INNER join, and HASH join
30:20
27. Description of INTERSECT operation, NON EQUI join, OUTER join, and CROSS join
25:53
28. Description of table initialization and data insertion for joins and practice
31:26
29. Practice on EQUI(equivalent) join, INNER JOIN, HASH JOIN, QUERY execution plan, and column ambiguity
32:13
30. Practice on INTERSECT operation, OUTER join, and CROSS join
29:35
31. Description of UNION, UNION ALL difference, MINUS operation, and hierarchical data lookup
34:30
32. Hierarchical data query, tree implementation with LEVEL, LPAD(), explanation of CONNECT BY keyword
20:34
33. Practice on UNION, UNION ALL, MINUS, LEVEL, LPAD(), CONNECT BY
34:05
34. Difference between single, multiple, and scalar SUBQUERY and explanation of operators ANY, SOME, ALL, EXISTS
37:18
35. Difference between single, multiple, and scalar SUBQUERY and practice with operators ANY, SOME, ALL, EXISTS
36:57
36. Solve the verification problem
15:17

Published: 01/20/2022

Last updated: 01/21/2022

Reviews

All

24 reviews

4.0

24 reviews

everick93569
Reviews 319
∙
Average Rating 4.9
12/18/2023
5
14% enrolled
Thank you~!
shyeo
Reviews 1
∙
Average Rating 1.0
03/11/2022
1
67% enrolled
Not all lectures required to obtain SQLD certification have been uploaded.
kkdts8072
Reviews 2
∙
Average Rating 1.0
02/04/2023
1
100% enrolled
There are some parts that are missing or incorrect. It seems that some corrections or video editing are needed. *Section 1. SQL_Basic 2 - Past Exam Problem Solving Video Past Exam Problem Solving 03 - CREATE, ALTER are DDL statements, but explained as DCL statements Past Exam Problem Solving 15 Not done
jiwoolee
Reviews 2
∙
Average Rating 3.0
01/20/2023
2
6% enrolled
There are some parts that are wrong in the middle, so I hope you can edit them and upload them. I explained it as a, but after a while I found out it was b. This kind of situation It's a bit much for every lecture to happen... I had the same complaints about other lectures, but it feels like they just took the basics and made a lecture right away to sell it.
justlearn
Reviews 1
∙
Average Rating 3.0
03/09/2022
3
100% enrolled
Part 2 is not the end....

usefulit's other courses

Check out other courses by the instructor!

SW Development Security - Learn Secure Coding Properly 2025

usefulit

This course teaches you how to write safe and reliable code in the software development process. Rather than simply stopping at feature implementation, you'll learn programming principles and techniques that can prevent security vulnerabilities and ensure stability. Through hands-on practice and case studies, you can understand security threats that may occur in real development environments and acquire safe coding techniques such as coding rules, input validation, exception handling, and memory management to prevent them. By taking this course, developers will enhance the completeness of their code while gaining practical capabilities to develop software with security and reliability.

Beginner

software-design

SW Development Security - Learn Secure Coding Properly 2025

usefulit

Introduction to Autodesk Maya 3D Graphics Part.3 Rendering

usefulit

This is an introductory 3D graphics modeling course using the 3D modeling software Autodesk Maya. The course consists of four parts in total, and in this session, we will focus on learning Maya's rendering features.

Basic

MAYA

Introduction to Autodesk Maya 3D Graphics Part.3 Rendering

usefulit

Introduction to Motion Graphics in After Effects CC 2020 Part 1

usefulit

This course is for those who are new to After Effects, and explains the overall usage method focusing on the most basic contents, and learns the basic process of motion work through simple tasks.

Beginner

After Effects, Video Production

Introduction to Motion Graphics in After Effects CC 2020 Part 1

usefulit

Information Security Engineer Practical Test - Problem Solving Focus Part 2 Network Security

usefulit

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

Basic

Engineer information security, security

Information Security Engineer Practical Test - Problem Solving Focus Part 2 Network Security

usefulit

MSSQL Server 2016-Based Database: From Introduction to Application Part.3

usefulit

This course covers everything from building a database and creating tables to manipulating and modifying data within the database using various SQL queries.

Intermediate

SQL, MSSQL, DBMS/RDBMS

MSSQL Server 2016-Based Database: From Introduction to Application Part.3

usefulit

Information Security Engineer Practical Test - Problem Solving Focus Part 4 System Security

usefulit

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

Basic

Engineer information security, security

Information Security Engineer Practical Test - Problem Solving Focus Part 4 System Security

usefulit

Information Security Engineer Practical - Problem Solving Focus Part 3 Application Security

usefulit

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

Basic

Engineer information security, security

Information Security Engineer Practical - Problem Solving Focus Part 3 Application Security

usefulit

Information Security Engineer Practical - Problem Solving Part 1 General Information Protection, Security and Password, Access Control

usefulit

Through this course, you can study short answer and descriptive questions from past practical exams for the Information Security Engineer.

Basic

Engineer information security, security

Information Security Engineer Practical - Problem Solving Part 1 General Information Protection, Security and Password, Access Control

usefulit

Information Security Engineer Practical Test - Problem Solving Part 5 Information Security Management, Law

usefulit

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

Basic

Engineer information security, security

Information Security Engineer Practical Test - Problem Solving Part 5 Information Security Management, Law

usefulit

ChatGPT for Office Workers, Part 1: Basics

usefulit

This course covers how to improve work efficiency by leveraging ChatGPT’s core functions: generation, summarization, analysis, and transformation. It provides practical content that can be applied immediately, from writing effective prompts to summarizing documents, creating reports, and handling business communication. You can learn how to use ChatGPT in a variety of roles, including customer service, sales, HR, and planning.

Intermediate

writing, prompt engineering, business

ChatGPT for Office Workers, Part 1: Basics

usefulit

Free Cloud-Based 3D CAD - Onshape Basics

usefulit

Learn the fundamentals of Onshape and learn the basics of 3D modeling and CAD.

Basic

Onshape

Free Cloud-Based 3D CAD - Onshape Basics

usefulit

[Photoshop Revolution Broadcast] Photoshop Basics Complete

usefulit

This is how to use Photoshop, taught in [Photoshop Revolution Broadcast].

Beginner

Photoshop

[Photoshop Revolution Broadcast] Photoshop Basics Complete

usefulit

How to Get 100% Out of Claude for the Workplace

usefulit

Learn how office workers can effectively use Claude in their actual work, focusing on key business tools such as Excel, PowerPoint, business writing, and VBA automation. Through hands-on exercises in each chapter, you will learn how to reduce repetitive tasks and increase productivity.

Basic

hancell, claude, Excel

How to Get 100% Out of Claude for the Workplace

usefulit

Learn assembler

usefulit

This is an assembler course provided by Smoothie TV.

Basic

Learn assembler

usefulit

Essential Practical Applications Every Working Professional Should Know - Hangul

usefulit

This course is a practical program designed to help you effectively utilize OA (Office Automation) programs in real life and work situations. Focusing on the core functions of representative office programs such as Word, Excel, and PowerPoint, we provide hands-on lectures that anyone can easily follow. Through this course, students will go beyond simple feature learning to develop practical OA utilization skills that can be immediately applied to various work situations, including document creation, household budget management, and presentation material production needed in daily life, as well as report writing, data analysis, and presentations in the workplace. Since we cover everything step by step from the basics, beginners can easily approach the material, and learners who already have experience can learn more efficient and professional utilization methods to increase work productivity and strengthen practical competitiveness.

Beginner

Hancom

Essential Practical Applications Every Working Professional Should Know - Hangul

usefulit

Getting Started with AWS Cloud for Beginners

usefulit

This is a series of video lectures for AWS beginners and college students enrolled in AWS Educate. We will briefly introduce the AWS registration process and free tier services.

Basic

AWS

Getting Started with AWS Cloud for Beginners

usefulit

[Photoshop Revolution Broadcast] Photoshop Intermediate Complete

usefulit

We're starting a series of tutorials for Photoshop image correction and editing, from basics to advanced editing.

Basic

Photoshop

[Photoshop Revolution Broadcast] Photoshop Intermediate Complete

usefulit

[Photoshop Revolution Broadcast] Photoshop Advanced Completion - Mastering the Pen Tool

usefulit

This is the Pen Tool series from the Photoshop Advanced Course provided by Photoshop Revolution Broadcasting.

Intermediate

Photoshop

[Photoshop Revolution Broadcast] Photoshop Advanced Completion - Mastering the Pen Tool

usefulit

Arduino Tutorial

usefulit

This is an Arduino lecture by Park Sung-jun on YouTube.

Beginner

Arduino

Arduino Tutorial

usefulit

Premier Courses on Nori Island (Adobe Premiere)

usefulit

I would like to introduce you to the Premier course by Nori Island on YouTube.

Beginner

Premiere Pro, Video Production

Premier Courses on Nori Island (Adobe Premiere)

usefulit

Similar courses

Explore other courses in the same field!

Getting SQL Developer (SQLD) Certification Part 3

usefulit

Basic

SQL

Getting SQL Developer (SQLD) Certification Part 3

usefulit

[2026] SQLD Part2 - Pass on Your First Try Even as a Non-Major

algolearn

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

Beginner

SQL, Big Data, Oracle

[2026] SQLD Part2 - Pass on Your First Try Even as a Non-Major

algolearn

Getting SQL Developer (SQLD) Certification Part 1

usefulit

Basic

SQL

Getting SQL Developer (SQLD) Certification Part 1

usefulit

59th Session (25.11.16) Reconstruction of Past Exam Questions Evaluated as Relatively Easy - All Questions by Subject and Chapter [SQLD Past Questions are the Answer!]

leejm99987374

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

Basic

SQL, Oracle, pivot

59th Session (25.11.16) Reconstruction of Past Exam Questions Evaluated as Relatively Easy - All Questions by Subject and Chapter [SQLD Past Questions are the Answer!]

leejm99987374

58th Session (25.8.23) Reconstruction of High-Difficulty Exam Questions - All Questions by Subject and Chapter [SQLD Past Questions are the Answer!]

leejm99987374

"SQLD is an exam where past questions are not released to the public." Preparing for the upcoming 60th exam (26.3.7)— Practical study material featuring 50 questions per subject and chapter, vividly reconstructed based on the actual 58th exam, which was rated as having the highest difficulty ever!

Basic

SQL, Oracle, pivot

58th Session (25.8.23) Reconstruction of High-Difficulty Exam Questions - All Questions by Subject and Chapter [SQLD Past Questions are the Answer!]

leejm99987374

Kim Young-han’s Practical Database – Fundamentals Edition

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

Basic

SQL, MySQL, DBMS/RDBMS

Kim Young-han’s Practical Database – Fundamentals Edition

Kim Young-han’s Practical Database – Design Part 2: 9 Design Patterns You’ll Definitely Encounter in Real-World Practice

Solve the common codes, category hierarchies, history tracking, soft deletes, statistics, dynamic design, JSON utilization, and more that you inevitably encounter in real-world design through nine core patterns. This goes beyond simple theory, incorporating practical know-how proven across numerous projects and criteria for making the right choices in different situations. Become a true design expert who can confidently design for any requirement.

Basic

SQL, MySQL, DBMS/RDBMS

Kim Young-han’s Practical Database – Design Part 2: 9 Design Patterns You’ll Definitely Encounter in Real-World Practice

[2026] SQLD All-in-One: Pass in One Go, Even for Non-Majors

algolearn

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

Beginner

SQL, Big Data, Data Engineering

[2026] SQLD All-in-One: Pass in One Go, Even for Non-Majors

algolearn

SQLD Certification Prep Course

SoYoung Yoon

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

Beginner

SQL, SQLD

SQLD Certification Prep Course

SoYoung Yoon