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

This is a lecture on Rhino 3D, which is a basic tool for product design.

This is a lecture on Rhino 3D, which is a basic tool for product design.

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 is a lecture on the application of Revit (Autodesk Revit) for implementing BIM (Building Information Modeling).

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

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.

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.

Learn the core techniques of 'Prompt Engineering' to get exactly the answers you want from AI. From a complete beginner's first steps to expert practical applications, maximize your AI utilization skills!

You can learn the basic functions needed for 3D effects and motion graphics work in the Maya 2020 version. (Part 2)

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

Run effective advertising with Google AdWords

This is an assembler course provided by Smoothie TV.

This course focuses on developing practical visualization skills that can be immediately applied in the workplace by utilizing Seaborn, a core tool for data visualization, and plotly/Dash for building interactive dashboards. Through various hands-on exercises, you can enhance both your ability to create insight-driven visual materials and implement web-based dashboards.

Learn the core techniques of 'Prompt Engineering' to get exactly the answers you want from AI. From a complete beginner's first steps to expert practical applications, maximize your AI utilization skills!

This course is a practical beginner's course where you'll directly create various videos such as talking avatars, AI dance, and fairy tale animations using AI tools like HeyGen, Viggle, Runway, and more.

When you want to try using Figma, a UI design authoring tool, or when you want to create something with Figma, you'll practice the most basic usage methods.

Learn step-by-step how to easily and elegantly complete spreadsheets and data using Numbers in a Mac environment. A complete Numbers guide that covers everything from basic data entry to functions, chart utilization, and collaboration, all focused on practical application!

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.

" · Understand the definition of SQLD and its exam subjects and scoring. · Install Oracle XE version directly. · Install SqlDeveloper directly."

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

Develop and deploy servers using Java, Spring Boot, JPA, MySQL, and AWS. While developing web applications, you will learn all the background knowledge, theories, and various technologies required for server development, as well as the meaning of various options, the history of Spring Boot, and the changes in the latest version.

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

We'll complete one full cycle of a backend service using Spring Boot, MySQL, Docker, AWS EC2, and RDS. You'll gain a sense of accomplishment through application deployment, and learn about the problems server developers face in real-world API development and their solutions.

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.

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.

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