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

In this course, you will learn how to use basic commands for 2D drawings in AutoCAD 2022.

Python with easy and intuitive grammar! Learn Python, which is famous as an introductory programming language, from the basics to practice! In this course, you will learn data structures (stacks, queues, tuples, sets, dictionaries, strings, collections module).

This course is designed to learn the JavaScript programming language along with the latest ES6 grammar.

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 helps build a basic understanding of algorithms using the C# programming language. It also covers the full process of coding 12 algorithms essential for industry use.

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

This course is an advanced program that provides in-depth coverage of C# multithreading and asynchronous programming, systematically designed to help you learn concurrency handling techniques frequently used in real-world applications. First, you'll understand the basic concepts of threads and practice creating and managing threads, learning to precisely control thread states and behaviors through various thread methods, ThreadState enumeration, and Flags properties. Next, you'll practice the differences and use cases between **Interrupt() and Abort()**, and learn how to reliably implement thread synchronization using **lock keywords and Monitor class (Enter, Exit, Wait, Pulse)**. Additionally, you'll cover asynchronous programming techniques essential in modern development environments, practicing parallel programming using Task and Task<TResult> classes, and the Parallel class. Finally, through async/await keywords, you'll understand the differences between synchronous and asynchronous code and gain experience applying more efficient asynchronous processing methods to projects. Through this course, learners will acquire the ability to develop high-performance applications using multithreading and asynchronous programming, and gain confidence in solving concurrency issues and implementing efficient programs in real-world scenarios.

This lecture is designed to prepare for the Information Security Engineer written exam, and it will help you concisely summarize the core theories and strengthen your practical skills through problem solving. Take a step closer to obtaining the Information Security Engineer certification with analysis of past questions and practical preparation strategies.

This lecture is designed to prepare for the Information Security Engineer written exam, and it will help you concisely summarize the core theories and strengthen your practical skills through problem solving. Take a step closer to obtaining the Information Security Engineer certification with analysis of past questions and practical preparation strategies.

This course is a step-by-step learning program that covers network programming from fundamentals to hands-on practice. First, we examine the origins and development of the Internet to understand how today's network environment was formed. Next, we learn the structure and operating principles of the TCP/IP protocol, which is the core of networking, to build a theoretical foundation. In the practical stage, we implement actual network communication using the Socket class, TcpListener, and TcpClient classes provided by C#, and experience client-server architecture. Through this, you can understand the actual data transmission and reception process and network connection procedures beyond simple theory. Finally, we visually implement network programs by creating user interfaces (UI) using WinForm. We practice enabling connection, message transmission, and reception through button clicks, developing the ability to create network application programs that can be utilized in real-world environments.

This course is a lecture that teaches C# Windows Forms (WinForm) application development step by step from basics to hands-on practice. First, you will understand how Windows Forms applications work and learn the structure and usage of WinForm classes and Application classes. Through this, you will become familiar with the execution flow of applications and build a foundation through actual code practice. In the following lessons, you will design forms using the form designer tool and implement **user interfaces (UI) utilizing various controls** such as buttons, text boxes, and labels. Rather than stopping at simple UI composition, you will develop the ability to create programs applicable in real work by adding event handling and interactive features. Additionally, you will practice asynchronous task processing methods in the WinForm environment and learn techniques to simultaneously improve application performance and user experience. Through this course, learners can solidly build the fundamentals of desktop application development in Windows environments and acquire WinForm programming capabilities applicable to real work.

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)

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.

React is an open source JavaScript library created by Facebook. You can create UI based on components using JavaScript. Learn all the components you need to develop a web using React, the most popular front-end development library currently optimized for creating SPAs (Single Page Applications). In Part 1, you will learn the basic concepts of web development using React.

This is an Adobe Lightroom course for photography and digital image processing.

This is a course to learn the Python programming language with 100 problems. This course consists of a total of 3 parts, and in Part 1, you will solve problems on the topics of variables, data types, operators, conditional statements, and loops.

Understand the definition of LINQ, learn the basic syntax of LINQ, and learn how to query data from various data sources using LINQ. Additionally, understand the detailed syntax of LINQ and LINQ standard operators and practice them directly.

"Understand the definition of the dynamic type, learn how to declare and use variables using the dynamic type, and understand how to handle COM objects using the dynamic type. Also, understand methods for ensuring interoperability with Python and practice them directly."

Through this course, learners can acquire the ability to obtain a computer proficiency certificate. This course is designed to meet the examination criteria for obtaining a computer proficiency certificate. You can learn and utilize basic knowledge of the computer proficiency subject to prepare for obtaining the certificate.

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.

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.

Let's improve performance by utilizing the basic technology stack! After the improvement, we will check the changes through load testing and monitoring tools! We will also prepare for interviews on each topic!

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

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

We will complete one full cycle of a backend service using Spring Boot, MySQL, Docker, AWS EC2, and RDS. Gain a sense of accomplishment through application deployment, and cover issues server developers face in real-world API development and their solutions.

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.

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.

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.

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.