Getting SQL Developer (SQLD) Certification Part 2

Name: Getting SQL Developer (SQLD) Certification Part 2
Price: 38500 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,697

Learners

6,638

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~!
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
justlearn
Reviews 1
∙
Average Rating 3.0
03/09/2022
3
100% enrolled
Part 2 is not the end....
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.
shyeo
Reviews 1
∙
Average Rating 1.0
03/11/2022
1
67% enrolled
Not all lectures required to obtain SQLD certification have been uploaded.

usefulit's other courses

Check out other courses by the instructor!

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

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

Introduction to Autodesk Maya 3D Graphics Part.4 Animation

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 this specific session focuses intensively on animation techniques using Maya.

Basic

MAYA

Introduction to Autodesk Maya 3D Graphics Part.4 Animation

usefulit

C++ Programming Fundamentals for Beginners

usefulit

This is a basic C++ course for those who are new to C++ programming. You will learn and practice how to utilize C++ along with an overview of programming and the basic grammar of C++.

Beginner

C++

C++ Programming Fundamentals for Beginners

usefulit

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

Learn to read mechanical drawings for beginners Part 1

usefulit

This course is designed to provide basic knowledge for those who are interested in mechanical drawing and design, those who are aiming to obtain qualifications in the field, those who wish to advance into a related field, or those who wish to improve their expertise.

Beginner

CAD

Learn to read mechanical drawings for beginners Part 1

usefulit

Blender 3.0 Introduction to 3D Graphics Part 2

usefulit

We will explain the overall concept and method of working with 3D graphics using Blender.

Basic

Blender, 3d-modelling

Blender 3.0 Introduction to 3D Graphics Part 2

usefulit

Python Basics to Practice Part 2

usefulit

Python with easy and intuitive grammar! Learn Python, a renowned introductory programming language, from the basics to practice! In this lecture, you will learn Python functions and lists.

Beginner

Python

Python Basics to Practice Part 2

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

Introduction to Database Based on MSSQL Server 2016: From Basics to Practical Application Part.2

usefulit

You can build a database, create tables, and manipulate or change data within the database using various SQL queries.

Basic

SQL, MSSQL, DBMS/RDBMS

Introduction to Database Based on MSSQL Server 2016: From Basics to Practical Application Part.2

usefulit

AI Image Creation with Midjourney (미드저니), from Hobbies to Business Applications [Basics]

usefulit

This course provides a step-by-step introduction to AI image creation with Midjourney, covering the fundamentals, prompt writing, result enhancement, parameter control, business image generation, and basic image editing. After first understanding AI image copyright and guidelines for safe use, you will learn Midjourney’s generation workflow, prompt formulas, and image-based generation features—including upscaling and variations—through hands-on practice. The course covers image creation examples that can be immediately applied to work and content production, and is designed to help you develop the basic skills needed to modify generated results to suit your objectives using Remix, Inpainting, and Zoom Out.

Intermediate

Content Creation, prompt engineering, Midjourney

AI Image Creation with Midjourney (미드저니), from Hobbies to Business Applications [Basics]

usefulit

Introduction to 3D Graphics Starting with Cinema 4D R23 Part.4 Animation & Motion

usefulit

We will proceed with basic learning of the animation and motion production features of Cinema 4D R23 software.

Basic

Cinema 4D

Introduction to 3D Graphics Starting with Cinema 4D R23 Part.4 Animation & Motion

usefulit

Introduction to Video Editing Davinci Resolve 16 Version Part 2

usefulit

This is an introductory course that teaches the most basic video editing, focusing on the basic editing functions of Davinci Resolve. (Part 2/3)

Basic

Davinci Resolve

Introduction to Video Editing Davinci Resolve 16 Version Part 2

usefulit

Introduction to Video Editing Davinci Resolve 16 Version Part 3

usefulit

This is an introductory course that teaches the most basic video editing, focusing on the basic editing functions of Davinci Resolve. (Part 3/3)

Basic

Davinci Resolve

Introduction to Video Editing Davinci Resolve 16 Version Part 3

usefulit

A Beginner’s Guide to Adobe Photoshop CC 2019 for Complete Beginners

usefulit

This is a beginner-friendly Photoshop course that teaches the most fundamental and essential features of the graphics editing tool Photoshop step by step.

Beginner

Photoshop

A Beginner’s Guide to Adobe Photoshop CC 2019 for Complete Beginners

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

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

Learn Excel with Tips

usefulit

1. Learn the main functions of Excel so you can create documents easily and quickly. 2. Learn tips commonly used in practice.

Basic

Excel, MS-Office

Learn Excel with Tips

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

Getting SQL Developer (SQLD) Certification Part 4

usefulit

Basic

SQL

Getting SQL Developer (SQLD) Certification Part 4

usefulit

Hands-on SQLD Practice (Subject 2)

coddatg

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

Basic

SQL, Oracle, MSSQL

Hands-on SQLD Practice (Subject 2)

coddatg

[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

Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]

leejm99987374

"SQLD is an exam where past questions are not officially released." In preparation for the upcoming 61st exam (May 31, 2026)— Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 60th exam!

Basic

SQL, Oracle, subquery

Check out the first past exam of 2026, the 60th session (26.3.7)! - All questions by subject and chapter [SQLD Past Exams are the Answer!]

leejm99987374

First steps to SQL coding test

Gemma

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

Basic

Coding Test, SQL, MySQL

First steps to SQL coding test

Gemma

[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

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.

Basic

SQL, MariaDB, HeidiSQL

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

swa

The final step for SQL coding test

Gemma

As you work through more difficult Leetcode SQL problems, you'll learn how to apply multiple grammar rules to a single problem.

Intermediate

Coding Test, SQL, MySQL

The final step for SQL coding test

Gemma

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

Fashion Retail Analysis

pnuswedu

Let's understand data analysis tailored for advanced retail businesses and learn how to use the tools utilized in the industry!

Beginner

scm, SQL, Google Analytics

Fashion Retail Analysis

pnuswedu

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.

Intermediate

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various cases

dooleyz3525

Getting SQL Developer (SQLD) Certification Part 2

4.0

What you will gain after the course

Anyone interested in getting SQLD certification? 🙋

Learning Objectives ✨

SQLD Certification Series 📚

Recommended for these people

HelloThis is usefulit

Curriculum

Reviews

usefulit's other courses

Similar courses

Recommended for
these people

Hello
This is usefulit