Introduction to Database Based on MSSQL Server 2016: From Basics to Practical Application Part.2

This is a hands-on course where you'll build an AI-based autonomous driving car using Raspberry Pi and various sensors.

This course is an advanced program that delves deeply into C# multi-threading and asynchronous programming, structured to help you systematically learn concurrency handling techniques frequently used in practice. First, you will understand the basic concepts of threads and practice how to create and manage them. You will learn how to finely control thread states and behaviors through various thread methods, the ThreadState enumeration, and Flags attributes. Next, you will practice the differences and use cases of **Interrupt() and Abort()**, and learn how to reliably implement synchronization between threads using the **lock keyword and the Monitor class (Enter, Exit, Wait, Pulse)**. Furthermore, the course covers asynchronous programming techniques essential in modern development environments, including hands-on practice with parallel programming using the Task and Task<TResult> classes, as well as the Parallel class. Finally, through the async/await keywords, you will understand the differences between synchronous and asynchronous code and gain experience applying more efficient asynchronous processing methods to projects. Through this lecture, learners will acquire the ability to develop high-performance applications using multi-threading and asynchronous programming, gaining confidence in solving concurrency issues and implementing efficient programs in real-world scenarios.

This course is a practical-focused program that covers the comprehensive utilization of **Google Sheets, the most widely used spreadsheet program in the world**. Starting with basic functions such as fundamental input, formatting, and cell management that even first-time users can easily follow, the course progressively advances to professional features including advanced function utilization, data analysis and visualization, conditional formatting, and pivot tables through step-by-step learning. Additionally, by focusing intensively on Google Sheets' unique strengths of real-time collaboration tools and cloud-based sharing features, learners can experience an efficient work environment where multiple people can simultaneously create, edit, and review documents. Through this course, learners can go beyond simple spreadsheet usage to simultaneously strengthen their data-driven decision-making abilities and collaboration capabilities, significantly improving work productivity.

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.

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 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 basic machine learning course that briefly covers the basic machine learning theory for those who are new to machine learning.

This course is designed to help office workers and practitioners utilize office programs more proficiently. Rather than simply learning the functions, the learning process focuses on real-world business scenarios such as document creation, data management, and presentation production. Through this course, students will systematically learn everything from the basics to the practical application of office programs like Word, Excel, and PowerPoint, naturally acquiring the skills to apply various functions to their specific tasks. This will help increase the efficiency of simple repetitive tasks and further strengthen practical competencies such as report writing and data analysis. In short, this course is a practical learning program that provides productivity-enhancing skills that can be applied immediately in the field, not only for beginners new to office programs but also for professionals who already have experience using them.

This is an introductory 3D graphics modeling course using the 3D modeling software Autodesk Maya. The course consists of four parts in total, and this specific session focuses intensively on animation techniques using Maya.

This course is designed to teach the entire process of 'AI Training Data Construction,' which is essential for successfully executing AI modeling projects. Learners will not simply remain at the theoretical knowledge level, but will experience step-by-step the data construction processes required in actual practice. Specifically, the course covers the entire process from AI training data planning → acquisition → storage → preprocessing → labeling → pseudonymization and transformation through hands-on practice, structured to develop practical skills that can be immediately applied in the field. Additionally, learners will systematically study the most important data management capabilities in AI projects, such as data quality management and security issues, personal information de-identification processing, and dataset optimization. Through this, learners can grow from simple data collectors into data specialists who can proactively plan and execute AI projects. 👉 Through this course, learners will understand how to construct high-quality training data that determines AI model performance and acquire practical capabilities to effectively apply this in real work environments.

This tutorial will show you how to use Bootstrap to create responsive web pages that change layout depending on the device.

This course is designed to provide basic knowledge for those who are interested in mechanical drawing and design, those who are aiming to obtain qualifications in the field, those who wish to advance into a related field, or those who wish to improve their expertise.

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.

This course is designed to prepare you for the Information Security Engineer written exam by concisely summarizing core theories and strengthening practical skills through problem-solving. Take a step closer to obtaining your Information Security Engineer certification with past exam analysis and practical preparation strategies.

This course teaches you how to write safe and reliable code in the software development process. Rather than simply stopping at feature implementation, you'll learn programming principles and techniques that can prevent security vulnerabilities and ensure stability. Through hands-on practice and case studies, you can understand security threats that may occur in real development environments and acquire safe coding techniques such as coding rules, input validation, exception handling, and memory management to prevent them. By taking this course, developers will enhance the completeness of their code while gaining practical capabilities to develop software with security and reliability.

This course is a basic introductory program for learning how to utilize the Raspberry Pi Pico and various sensors. Learners will understand the fundamental functions of the Raspberry Pi Pico and acquire the ability to control various sensors using it. Based on a foundational understanding of the Raspberry Pi Pico, this course is structured to step-by-step improve your skills in utilizing sensors.

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

Learn the fundamentals of Onshape and learn the basics of 3D modeling and CAD.

This is how to use Photoshop, taught in [Photoshop Revolution Broadcast].

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

You can master Database development, which is essential for mobile/web development, through MySQL.

This is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

This course focuses on building the real skills needed in actual development work. The goal is not simply to learn how to write code well, but to experience how to work well as a developer. The examples are based on the commerce domain, covering cases frequently encountered in real-world work environments, and are provided in SpringBoot & Kotlin. However, it's a course where anyone can contemplate and experience real-world development through thought-provoking content, without being dependent on any specific language or framework. Based on the practical perspective of a senior developer and former director at Toss Payments who led a large-scale payment service organization, the course is designed to help you learn the thought processes and design decisions used in actual work environments.

If you can master DB and programming, you should be more than halfway prepared for the information processing engineer exam. Let's take a look at the DB and programming parts, which are worth 45 to 55 points in the practical exam, and pass the written exam steadily.

With the arrival of the AI era, the skills required of developers are becoming increasingly complex. You might have thought, "I just need to be good at frontend," but when you try to create your own service or integrate AI features, you eventually hit a massive wall called the backend. However, as you try to start backend development, are you overwhelmed by how much there is to learn—from database design and authentication (Auth) to storage management and complex infrastructure setup? Now, you can lay down that heavy burden. In this course, we use Supabase, which solves all these backend functions at once. We will guide you through the fastest shortcut to becoming a full-stack developer who can "instantly" complete a backend without complex server knowledge and bring ideas to life immediately.

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

This is a course for learning MS-SQL through baseball and corporate databases.

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.

This is a WPF lecture that will be helpful to developers who are considering introducing WPF in WinForms, application developers who are hoping to get a job in the US, and those who are hoping to get a job as a developer. It is not a lecture focused on theory and design, but covers content that can be used in practice.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

Learn common components of global-scale services through popular papers, books, and articles.

In this lesson, you will learn how to create an .EXE file. You will also learn how to install an MSSQL database and request data in C#.