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.

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 3, you will solve problems on the topics of OPP, algorithms, strings, modules, and certification preparation.

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 2, you will solve problems on the topic of arrays and functions.

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.

This is a basic iOS language course taught by LAte Developer on YouTube.

This course is a **practical-focused lecture** that covers how to apply **conversational AI (ChatGPT, etc.)** to actual company work. Beyond simple AI usage methods, it is structured to enable learning of specific cases such as work automation, document creation, idea generation, and data analysis assistance that can be utilized in various departments and job environments. Through this course, learners will master methods to streamline repetitive and time-consuming tasks with AI, and experience smart workflows that collaborate with AI. Additionally, by understanding AI's strengths and limitations, it helps make correct decisions in actual business situations. Upon completing this course, you will be able to utilize conversational AI including ChatGPT as a tool to enhance work productivity, which will serve as an important foundation for securing competitiveness in future work environments.

"This is a course for learning the overall usage of Notion, an all-in-one productivity tool that enables efficient management of work and life in a Mac environment. You can learn step-by-step from Notion's basic functions to databases, automation, AI utilization, and practical template creation, acquiring work and self-management methods optimized for Mac users. Through a hands-on curriculum, you can increase productivity in both daily life and 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.

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

This is an assembler course provided by Smoothie TV.

This course is designed to help you learn the basic concepts of algorithms through JAVA programming. Rather than stopping at simple theoretical explanations, it is structured so that you can naturally understand various algorithms by implementing them directly in code. Students will learn step-by-step, starting from basic sorting and searching algorithms to more advanced ones, while simultaneously developing problem-solving skills and programming logic. Furthermore, by integrating JAVA syntax and usage through practice-oriented learning, you can master both algorithm theory and practical implementation at the same time. Through this course, learners will not only establish a solid understanding of algorithms but also acquire the capability to implement them using JAVA, gaining practical programming skills that can be applied to academics, employment, and professional work.

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 is a lecture on Rhino 3D, which is a basic tool for product design.

I would like to introduce you to the Premier course by Nori Island on YouTube.

Let's create a shopping mall with WordPress

This is a free Unity basics course by Unity Hub root owner Dong-geun Joo.

This is a course where you can study data structures and algorithms along with the object-oriented language C++.

This is the Pen Tool series from the Photoshop Advanced Course provided by Photoshop Revolution Broadcasting.

You can start creating games without difficult programming with Unreal Engine 4's Blueprint.

It guides you on how to freely use Python, a powerful and easy language.

We introduce ways to utilize GA4 data in BigQuery. Using the GA4 BigQuery demo data from the Google Merchandise Store (https://www.googlemerchandisestore.com/) available publicly in BigQuery, we provide hands-on practice with basic SQL queries and introduce methods for marketers and planners to easily utilize GA4 BigQuery data.

Knowledge Graph-based RAG System Implemented with Neo4J: Next-Generation Search Technology Utilizing Data Relationships Beyond Simple Vector Search Maximizing RAG Performance with the Power of Graph Databases!

Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.

This is a SQL lecture designed to help marketers learn SQL easily. We introduce the essential SQL grammar and analyze real data obtained from Kaggle.

This is an introductory BigQuery (SQL) course for beginners. I recommend it to those who are curious about how to process data. I will teach SQL from the perspective of data analysis and data engineering, rather than from a backend development perspective.

Not only developers, but also planners and data analysts learn databases step-by-step, starting from the basics of SQL.

This is a special lecture that can lay the theoretical foundation to simultaneously prepare for the Microsoft AZ-900 certification, and as the latest content reflecting the scope of questions as of May 2025, by providing content related to core data concepts, Azure's relational data, Azure's non-relational data, and Azure's analytical workloads in a form combining theory and practice, it can be utilized as a meaningful educational opportunity to not only obtain the certification but also take the first step towards becoming a data professional.

This course aims to obtain the state-certified SQLD (SQL Developer) certification. An SQLD refers to a developer who can write accurate SQL to manipulate and extract data while developing application software based on knowledge of databases and data modeling.

"SQLD is an exam where past questions are not officially released." In preparation for the upcoming 61st exam (May 31, 2026)— Practical materials featuring 50 questions per subject and chapter, vividly reconstructed by directly recalling the latest 60th exam!

"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!

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

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!

Let's understand data analysis tailored for advanced retail businesses and learn how to use the tools utilized in the industry!