IT Essential Knowledge - Database and SQL

This is a series of video lectures for AWS beginners and college students enrolled in AWS Educate. We will briefly introduce the AWS registration process and free tier services.

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 a hands-on lecture that covers the basic usage of the Cursor AI tool and how to apply it to actual website creation. Learners will understand the AI-based development environment and experience code writing and automation features using Cursor. The curriculum is designed not just to teach the tool's functions, but to help students develop practical skills through an actual website production project. Furthermore, it covers essential elements frequently used in website development—such as HTML, CSS, and JavaScript—along with efficient development methods using AI assistance, making it easy for beginners to follow along. By taking this course, learners will gain the ability to quickly implement ideas and complete websites using Cursor AI, which will serve as an excellent first step in adapting to the latest development environments.

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

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.

Through this course, you can study short answer and descriptive questions from past practical exams for the Information Security Engineer.

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

You can effectively study the contents of the Information Security Engineer practical exam questions and obtain the Information Security Engineer practical qualification.

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.

You can obtain a certificate by learning and utilizing basic knowledge about software design, the first subject in the written test for the Information Processing Engineer exam.

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 is an introductory course that teaches the most basic video editing, focusing on the basic editing functions of Davinci Resolve. (Part 1/3)

This course teaches texture styling for game graphics using the physically-based renderer Substance Painter.

This course is a foundational learning program that covers Introduction to Information and Communication Technology, one of the core theories in computer engineering. Through this course, learners can understand the basic structure and operating principles of computers, and learn the principles and applications of information and communication technology based on this foundation. It is structured to provide comprehensive learning from the processes of information generation, transmission, processing, and storage to data communication methods in network and internet environments. In addition, by understanding the basic concepts of information and communication technology along with the trends and roles of information and communication technology utilized in real life and industry as a whole, it provides a solid theoretical foundation for learners who are first entering the fields of computer engineering and information and communication technology. 👉 By taking this course, learners can build a fundamental foundation in information and communication technology that encompasses computers and networks, and furthermore, utilize it for advanced learning or preparation for related certifications.

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.

From building a database to creating tables, you can manipulate and change data within the database using various SQL queries.

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.

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

Python with easy and intuitive grammar! Learn Python, which is famous as an introductory programming language, from the basics to practice! In this lecture, you will learn about Python, variables, data types, conditional statements, and loops.

Train SQL queries through 50 diverse problems and prepare for real-world analysis environments and coding tests. * If you are new to learning SQL, you will be able to follow along without difficulty by first taking SQL [개념반].

A lecture taught directly by the author of the book "SQL 200," published by Jungbo Munhwasa! Over the years, numerous data analysts have empowered their data retrieval skills through instructor Yeon-soo Yoo's SQL lectures.

Sometimes, data processing is blocked and frustrating. If you are not a professional programmer or developer, learning unfamiliar fields such as Python or Java is not easy and there is not enough time. This is for those who only know Excel and SQL basics when it comes to frequently used things. This is the first part of the SQL query book that you can find and use when you need it.

Based on Oracle 21C, from concepts to practice, the easiest way to learn SQL for beginners! Taught directly by the author of Easyspub's "Do it! Introduction to SQL with Oracle"! Designed for non-majors and beginners, explained step by step.

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

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

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

"SQLD is an exam where past questions are not officially released." Preparing for the upcoming 60th exam (2026.3.7)— Practical study material featuring 50 vividly reconstructed questions by subject and chapter, based on the latest 59th exam!

Knowledge Graph-based RAG System Implemented with Neo4j: Next-generation search technology that leverages data relationships beyond simple vector search Maximize RAG performance with the power of graph databases!

SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!