inflearn logo

Programming Craftsman Practical Exam (2026) — Subject 4: SQL Writing (Complete)

This course offers a systematic study of the SQL writing section, the fourth subject of the Programming Craftsman practical exam. It covers a range of SQL syntax, from DDL and basic queries to JOINs, subqueries, inline views, and common table expressions. The goal is to build the problem-solving skills needed for the practical exam and earn the certification.

1 learners are taking this course

Level Basic

Course period 12 months

dcl
dcl
SQL
SQL
subquery
subquery
joins
joins
dcl
dcl
SQL
SQL
subquery
subquery
joins
joins

What you will gain after the course

  • Can analyze and solve SQL writing problems on the practical exam for the Programming Technician certification.

  • Can write queries using advanced SQL syntax such as JOINs, subqueries, inline views, and common table expressions.

  • You can define and manage database table structures using DDL.

Programming Technician Practical Exam (2026) · Subject 4: SQL Writing

Seven lessons are all you need for the SQL practical exam.

DDL · Basic Queries · JOIN · Subqueries · Inline Views · Scalar Subqueries · CTEs

프로그래밍기능사 실기 (2026년) · 4과목 SQL작성 강의 대표 이미지

You can solve the SQL writing questions in Subject 4 of the Craftsman Programmer practical exam on your own.

TOOL

Tools Covered

Covers the SQL syntax needed for the practical exam.

SQ

SQL

CURRICULUM

What You’ll Learn Here

Learn SQL syntax systematically for the practical exam.

Lesson 1

Define Database Structures with DDL

You can write SQL to create, modify, and delete tables and manage database structures.

Lessons 2–3

Basic Queries and Using JOINs

You can write practical queries, from single-table lookups to joins across multiple tables.

Lessons 4–7

Master Subqueries and CTEs

You will be able to solve complex problems using advanced SQL syntax, such as inline views, scalar subqueries, and common table expressions.

NOTICE

Notes Before Enrolling

  • Questions and answers are not provided.
  • Watching at an accelerated speed is recommended.
  • This reflects the UI at the time of recording; it may change.
  • The practical exam schedule must be checked separately.
  • You may need to set up a separate SQL execution environment.

Recommended for
these people

Who is this course right for?

  • Learners preparing to earn a practical certification in programming skills.

  • Learners who want to improve their ability to solve practical problems in the SQL writing section.

  • A beginner looking to systematically learn database SQL syntax

Need to know before starting?

  • Understanding the basic concepts of relational databases

  • Basic programming syntax and logical thinking skills

  • Fundamentals of the written exam subjects for the Programming Craftsman certification

Hello
This is usefulit

8,281,845

Learners

6,724

Reviews

4.6

Rating

407

Courses

I will help you grow through useful IT lectures.

Curriculum

All

8 lectures ∙ (3hr 43min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

usefulit's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$16.50

25%

$16.50