Kim Young-han’s Practical Introduction to Databases – A First Step into SQL for Everyone in IT (Learning SQL Step by Step)

Learn the essential fundamentals of SQL and databases needed for practical work. Not only developers, but also planners and data analysts will learn SQL in depth.

I have created a course titled 'Introduction to MySQL Performance Optimization & Practice (SQL Tuning Edition)' that is easy for non-majors to understand and can be applied immediately in practice!

Make the most of relational database systems!

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

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!

In this lecture, we aim to create a Web Scraping API server using the Naver Shopping site. We will show you how to configure a managed API server by connecting MySQL and configuring a 3-tier architecture!!

Solve 25 SQL problems of various difficulty levels. This is the Advent of SQL 2024 explanation lecture. Upon finishing the lecture, you can complete the Advent calendar and obtain a badge.

A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

This course implements a bulletin board CRUD using Spine, following the entire process from start to finish to see exactly which rules and sequences Spine uses to execute requests and complete responses. Based on Spine's core Execution Pipeline, we will examine the entire request lifecycle without omission: Routing (Handler selection) → Argument Resolution (Argument Resolver) → Controller Invocation (Invoker) → Return Value Processing (ReturnValue Handler). The focus is not on building features quickly. Instead, by directly tracing questions like "When is this logic executed?" and "Who is responsible for this step?" within Spine's architecture, you will develop the intuition to explain and control the execution flow. We also cover how cross-cutting concerns, such as logging, are separated from the controller and integrated into the execution flow (Interceptor). By the end of the bulletin board example, you will have gained something more important than just building CRUD with Spine: the criteria to determine where to attach specific features based on Spine's execution model. This is not just a simple CRUD course; it is the essential first course to truly getting started with Spine.

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

Does game backend development feel daunting and vague? With know-how gained from firsthand experience with numerous projects, I will show you how to perfectly integrate complex Firebase features into actual games. We will connect Firebase to a Unity 6 Watermelon Game to implement online features such as login, cloud database (Firestore) save/load, rankings, bulletin boards, and mailboxes. This is a practical course that also covers security rules, Remote Config operations, and code design based on a layered architecture (UI, logic, and data access).

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

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.

SQLD, where should I start? For those of you feeling completely overwhelmed, this is the lecture for you. You will meet a transformed version of yourself after completing the course. SQLD All-in-One Pass!

For those feeling overwhelmed by SQLD exam preparation, this is a standard course that analyzes the entire scope of the "Yellow Book," organizes the necessary theories through practice-oriented lessons, and solves every single problem. With short, concise clips and a topic-based structure, you can build the practical skills needed to succeed on the actual exam.

This course goes beyond basic CRUD-level database usage, helping you develop the PostgreSQL skills needed in the AI era from a practical, real-world perspective. Drawing on AI development experience in Silicon Valley, you’ll gradually learn how to design and use JSON, indexes, transactions, and pgvector in actual services, while gaining the skills to solve complex data structure and performance problems.

A guide to the exam for nationally recognized SQL qualifications! Establish a comprehensive knowledge system related to SQL.

From the fundamentals of MySQL usage to the advanced techniques required in real-world service environments, you will learn progressively. The course also covers a wide range of topics, including data modeling techniques based on various cases and practical data, evaluating the effectiveness of Foreign Key design, analyzing the Google Calendar schema DDL, and modern DDL design principles. It provides an in-depth understanding of how to use MySQL as a core component of a system, rather than merely as a database.

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

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