Complete Guide to Information Processing Industrial Engineer Process Assessment Practical Exam: Learn by Solving

This course is designed to prepare you for the Information Processing Engineer practical exam solely through solving previous exam questions. Instead of unnecessary theories or vast amounts of content, it focuses on past exam questions that are repeatedly featured, allowing you to connect your learning directly to passing the exam. You can quickly grasp core points and question patterns by reflecting on the latest trends, and even learn tips for writing answers through the problem-solving process. This lecture is optimized for examinees aiming to pass efficiently in a short period of time.

This is a specialized practical exam lecture optimized for the Web Design & Development Craftsman (formerly Web Design Craftsman) practical exam, strictly adhering to the exam standards effective from January 1, 2025, to December 31, 2027. Coding Works' Web Design & Development Craftsman practical exam lectures, covering HTML+CSS+JQUERY publishing, are different. It includes fully produced instructional videos for all exam types (Types A, B, C, D, E, and F) for the 2026 Web Design & Development Craftsman exam.

It’s perfectly fine even if you’ve never written a single line of SQL. We start with installing Oracle Database and DBeaver. You’ll complete the entire scope of SQLD Subject 1 (Data Modeling) and Subject 2 (SQL Basics and Applications) by running queries yourself over 15 hours and 23 minutes. It includes practice questions and answers, as well as review lectures where we solve the questions together. You’ll be taught by a data expert with 30 years of experience, who worked as a DBA and SQL tuner at Korea Exchange Credit Card and Hyundai HiCar Direct, and has delivered 100 sessions of SQL lectures at Samsung Electronics.

This lecture is for studying Database Utilization, the third subject of the Information Processing Industrial Engineer written exam.

Doing it carelessly is worse than not doing it at all. You'll just waste time! From now on, let's solve it thoroughly and perfectly together!

Even if AI quickly generates an SQL draft, people must judge the table structure, relationships, performance, and data consistency. Using MySQL and DBeaver, you will gain hands-on experience with everything from tables, columns, data types, PKs, and FKs to DDL, database modeling, SQL fundamentals, indexes and EXPLAIN, and transactions, learning the standards for reading and validating AI-generated results.

The SQLD Latest Past Exam Problem Solving Course is a practical preparation lecture that reflects the 2024 revised exam standards and is based on actual past exam questions. Going beyond simply checking answers, it meticulously covers the question's intent, key testing points, and common pitfalls, developing practical problem-solving skills for SQLD certification success.

This course systematically teaches normalization and denormalization, which are core concepts in database design. Learners will understand the necessity and principles of normalization, and acquire step-by-step knowledge from First Normal Form to Third Normal Form and BCNF normalization techniques. Additionally, they will learn denormalization techniques that are essential considerations in practical database design, and discover actual application methods for performance optimization. Furthermore, learners can understand the essence of NULL values and their operational results, which are important concepts in databases, and examine the concept and characteristics of **Artificial Identifiers** to experience the importance of data integrity and management. Through this course, learners can establish a foundation for solving various problems that may arise during the data modeling process and develop database design capabilities applicable to both theory and practice.

Most developers still think in terms of Batch and CronJob when discussing data processing. However, in real-world service environments, data is generated continuously, and failing to process that flow immediately leads to delays, bottlenecks, and data consistency issues. I have also repeatedly faced the question, “Is batch processing really the right approach?” while dealing firsthand with real-time recommendations, state synchronization, and event delays in high-traffic environments. This course starts from that very question. It explores, from a practical perspective, how to use Apache Flink to perform computations as data flows in, manage state safely, and produce accurate results based on Event Time. Rather than simply explaining theory, it allows you to experience how real-time stream processing systems are designed and operated through actual source code and architectures. For those who have found real-time processing vague or wondered what lies beyond messaging, this course will provide a clear direction.

This course is designed to provide systematic learning from the basic concepts of relational databases (RDB) to foundational SQL skills. Learners will first understand the structure of databases and tables, work with SELECT statements which are the core of SQL language, and learn how to use various operators (arithmetic operators, concatenation operators). Additionally, learners will study the concept of **Functions** that are essential in data processing, and directly practice with string functions, numeric functions, date functions, and NULL-related functions through hands-on exercises, strengthening both theory and practical application simultaneously. Through this, learners will be able to go beyond simple data queries and develop foundational SQL capabilities that can be immediately applied to real-world data analysis and processing.

Libraries are optional, but web standard technologies are essential. Adapt to the new standard for web animation, Web Animation API, faster than others and apply it to your work right away!

This course is for those who want to learn DDD but feel lost on "how to apply it to a real project." In this course, we will implement DDD design from start to finish by **building an actual ordering system** based on Spring Boot. The focus is not on simple theory, but on "structures and code that can be used immediately in practice." After taking this course, you will be able to: ✔ Design DDD-based projects on your own ✔ Implement professional-level structures yourself

Now you can enjoy the easy and fun coding lectures of Young Cody Kim, a current star lecturer who has devoted himself to coding education for over 15 years, targeting elementary school students, high school students in IT software departments, college students in computer science departments, and job seekers who are not majoring in the field, not only offline but also online. With Young Cody Kim, who has produced over 500 front-end, back-end, full-stack, and web developers, your dream of becoming a developer will soon come true!

If you have learned HTML&CSS and JavaScript, try creating and deploying your own portfolio site using them. Actually using them will greatly help improve your skills.

You can enhance your mobile web production skills, which are the most competitive assets for publisher employment and practical publishing work. You will be able to solidify almost all production methods and know-how required to create mobile webs as a publisher. In particular, to cover much of the design ability required of publishers and developers these days, we have provided detailed explanations of the process of working on mobile web UI design using Figma. A key strength of this mobile web publishing course is the detailed instruction on how to create HTML wireframes for every single page. Through this lecture, your ability to create HTML wireframes will improve significantly. In mobile web publishing, you will acquire practical skills comparable to real-world work by learning how to perfectly adjust layouts for mobile and tablet devices using CSS variables (Var). You will fully develop intermediate-to-advanced practical CSS skills, centered around Flex layouts.

Solve everything from the basics of querydsl to practical use all at once!

Experience the Jeju-based bootcamp online! Quickly create your own service! :)

By creating 22 different mobile layouts across 19 pages, you can enhance your mobile web development skills, which is the most competitive asset for getting hired and working as a professional publisher. You will be able to solidify almost all production methods and know-how required for mobile web publishing. A key strength of this mobile web publishing course is the detailed instruction on how to create HTML wireframes for every single page. Through these lectures, your ability to build HTML wireframes will improve significantly. In particular, you will thoroughly learn CSS Nesting techniques. Centered around Flex layouts, you will gain sufficient intermediate-to-advanced practical CSS skills.

Learn I/O, networking, reflection, and annotations in depth, from the basics to the practical level. Build a web application server (WAS) directly in Java.

Create a desktop app with minimal theory! Anyone can start creating an app even without programming experience!