SQL Developer (SQLD) Certification Guide (2024 Revision) Part.3 Advanced

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++.

Notion's powerful and convenient database features allow even beginners to easily build a DB. In this course, you will learn about database concepts and related terms (tables, rows, columns, etc.), as well as the basic usage of the Notion database.

This course is designed to prepare for the Linux Master Level 1 first and second round certification exams. The Linux Master Level 1 certification evaluates expertise in practical areas such as Linux system operation, management, networking, and security, providing essential theory and hands-on practice for students preparing for this exam. Through this course, learners can systematically study the core structure and management methods of the Linux operating system, and acquire commands and system management skills applicable in practical work. Additionally, it is structured to strengthen exam adaptability through learning that reflects actual past exam question types and to build competency as a Linux professional.

This is a Photoshop course for beginners that will teach you the most basic and important functions of the graphic editing tool Photoshop.

This is a course to learn in various languages how to call various open data provided by the public data portal from various programming languages and how to use JSON data provided as a result of the call.

This is a lecture where you can learn JavaScript through theory and practice. We explain step by step so that even those who are new to coding can easily understand. Part 1 covers an overview of JavaScript, variables, data types, operators, control statements, and the basics of jQuery.

This course is a hands-on program where you learn the core syntax and applications of frontend web programming and apply them to actual portfolio creation. Learners will progressively master everything from basic syntax of HTML, CSS, and JavaScript to the latest frontend technologies, directly experiencing the process of implementing web interfaces and handling dynamic functionality. Additionally, through various examples frequently used in practice, you can naturally acquire efficient coding techniques and real development workflows. Through this course, learners can go beyond simple syntax memorization to understand the connected workflow from web page planning–design–implementation, and based on this, complete their own portfolio. Furthermore, this course will serve as a solid stepping stone for growing into a frontend developer, providing great help as an introductory course for learners new to web development and as a practical supplementary course for those wanting to build hands-on experience.

This course is a hands-on program focused on learning the core syntax and application methods of frontend web programming and applying them to actual portfolio creation. Learners will progressively master everything from basic syntax including HTML, CSS, and JavaScript to the latest frontend technologies, directly experiencing the process of web interface implementation and dynamic functionality handling. Additionally, through various examples frequently used in practice, learners can naturally acquire efficient coding techniques and real development workflows. Through this course, learners will move beyond simple syntax memorization to understand the connected workflow from web page planning–design–implementation, and based on this understanding, they can complete their own portfolio. Furthermore, this course will serve as a solid stepping stone for growing into a frontend developer, providing great help as an introductory course for learners new to web development and as a practical supplementary course for those looking to build hands-on experience.

This is a lecture to prepare for the Information Processing Engineer practical subject certification, and you can acquire basic knowledge to understand the development requirements of information systems, etc. (Second Part)

This is a lecture to prepare for the Information Processing Engineer practical subject certification, and you can acquire basic knowledge to understand the development requirements of information systems, etc. (Part 1)

This course is designed to learn the fundamental theories and practical processes necessary for applying AI modeling and service planning to real-world work environments. Learners can acquire essential foundational knowledge to skillfully perform AI modeling projects and experience various practical procedures used in actual business settings. The course is specifically structured to provide step-by-step learning of the entire workflow from AI service environment analysis → goal setting → requirements analysis → service model design → scenario planning → utilization planning → execution plan development → performance evaluation planning. Through this approach, learners can develop systematic thinking and practical application skills for how to introduce and utilize AI from business and service planning perspectives, rather than limiting themselves to purely technical learning. Upon completing this course, learners will understand the overall planning and execution process of AI projects and will be able to strengthen their capabilities as AI service planners, PMs, and data-driven strategists in actual corporate environments.

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.

This course covers practical MS Word tips that can be immediately applied in the workplace. Beyond simple document creation functions, it provides various practical know-how to enable efficient and professional document work. You can learn practical skills that will increase work efficiency, such as document editing, formatting, paragraph and table utilization that are frequently encountered in the workplace.

Notion's powerful and convenient database features allow even beginners to easily build a DB. In this lecture, you will learn about data sorting, filters, and advanced part features such as DB relationships and rollup functions.

Learn the key features of Illustration CC 2020 to quickly and easily utilize illustrations.

This course focuses on learning the fundamental concepts of algorithms using the JAVA language, with an emphasis on simultaneously developing programming thinking skills and problem-solving abilities. Additionally, it systematically covers the large-scale application development procedures used in corporate environments, allowing students to learn the analysis and design processes required in practical work. Through this, learners can go beyond simple coding abilities to become familiar with the overall system analysis and design process and strengthen their practical application skills. By learning step-by-step from basics to practical procedures through this course, students can build a foundation for growing into developers, system engineers, and IT planners.

This course goes beyond the React beginner level and is an intermediate learning course that intensively covers the principles and usage of Hooks, which are most frequently utilized in practical development. Through Hooks, the core tool of functional components, you can learn step-by-step how to implement state management, lifecycle control, performance optimization, and more. In particular, it systematically organizes the roles and usage patterns of basic Hooks like useState and useEffect, as well as advanced Hooks such as useRef, useMemo, and useCallback, and is structured to help you understand which Hook to choose for different situations. Through practical examples, you'll go beyond simple code writing to experience: State management optimization between components Prevention of unnecessary rendering Dynamic data management and DOM control This allows you to develop the intuition to solve problems frequently encountered in real projects. Upon completing this course, you'll master Hook-based development flow, which is the core of React, and be able to confidently apply it to more complex application structures.

Learn the key features of Photoshop CC 2020 to use Photoshop easily and quickly.

This course is a course to learn and utilize the OBS Studio program.

Learn the basics of using AutoCAD and the basic functions for 2D CAD work.

This course is designed to systematically learn advanced SQL features including GROUPING functions and window functions to prepare for the SQLD exam and improve practical data analysis skills. You will learn the concepts and applications of GROUPING functions and master methods for analyzing data at various aggregation levels. You will understand the basic concepts and types of **window functions (based on the OVER keyword)** and enhance your practical skills through hands-on exercises. You will learn **ranking functions (RANK, DENSE_RANK, ROW_NUMBER, etc.)** and window utilization options for aggregate functions through practical examples. You will work with **row order functions (LAG, LEAD, FIRST_VALUE, LAST_VALUE, etc.)** and practice time series data and order-based analysis directly. 👉 Through this course, learners will be able to expand their data aggregation and analysis skills to an advanced level, acquiring practical abilities that can be immediately applied not only for the SQLD exam but also in real corporate data analysis environments.

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.

From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

This lecture is a lecture on the backend part of the [Web Development Full Stack Course] lecture series for training full-stack web developers. This lecture is based on the contents of the instructor's book <A Week Before Investing in a Node.js Project>.

This course covers how to create web applications using Node.js and MySQL.

This course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

This is a full-stack restaurant map tutorial that allows you to learn everything from front-end, back-end, Kakao Map API usage, and deployment all at once while creating a restaurant map of your favorite YouTuber.

We will learn about cases where companies such as Line, Google, Carrot, and Kakao actually improved MySQL performance. Let's go beyond simple performance optimization guides and understand the internal workings of MySQL and learn how to use it efficiently.

Learning by Doing: 정보처리산업기사 I have prepared everything for passing the 정보처리산업기사 course-evaluation practical exam.

In this course, you will practice step-by-step using React and FastAPI to implement social features like real-time voting, comments, and likes, as well as integrating payment systems (KakaoPay, TossPay, etc.) for monetization.

Create a SNS service using Vue and Nuxt frameworks. Learn the full stack knowledge required for the service.

This course teaches you how to implement modern web applications that combine the accessibility of the web with the excellent information management capabilities of a database by linking PHP and MySQL.