Smart SQL Learning Methods in the AI Era [Introductory]

Even if AI quickly generates SQL drafts, humans must still judge table structures, relationships, performance, and data consistency. Using MySQL and DBeaver, you will gain hands-on experience with tables, columns, data types, PK/FK, DDL, database modeling, SQL core concepts, indexes, EXPLAIN, and transactions to master the standards for reading and verifying AI-generated results.

A lecture directly taught by the author of the SQL 200 Questions book (PL/SQL) published by Jeongbo Munhwasa! This is a PL/SQL lecture by Oracle instructor Yoo Yeon-soo, who has trained numerous DBAs and PL/SQL developers. After taking this course, you will clearly feel the difference between before and after using PL/SQL.

A DBA instructor with 30 years of experience teaches 45 essential SQL tuning techniques that can be immediately applied in practice through real-world examples. Master the practical know-how to make slow queries 10 times faster, from execution plan analysis to index optimization and join tuning!

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.

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.

How is processing big data different from processing data with Pandas? Let's learn about Spark, an essential framework for big data processing.

[Only for those new to web development] Spring Boot REST API: Building step-by-step while properly understanding JPA

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

King Basic🐥, only for those who say they have no more words to describe me.👂 Concepts go to the universe🚀, King Basic practice day and night✍, learn SQL with your hands!✋ No installation required.🔥 Here is the lecture restaurant, Jecobe!🎉

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.

I'll show you everything about how to build servers for stateful services and how zero-downtime deployment works.

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

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

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

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!

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 is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

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

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

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.

This course focuses more on data modeling through entity design than on JPA technical explanations. Based on the principle that solid DB design is the foundation of application development, we analyze various design patterns—such as one-to-many, many-to-many, inheritance, and collections—alongside business scenarios. You will learn by directly observing the process of code being transformed into actual tables on screen. To ensure immediate practical application, we provide business use cases, source code, and test codes for each design pattern.