Smart SQL Learning Methods in the AI Era [Introductory]

Starting from installing MariaDB and understanding its structure, you will learn step-by-step from writing SQL queries and utilizing functions to joins and subqueries. You will master core practical features such as table design, performance management, backup, and recovery through hands-on practice, completing the practical skills necessary for database development and operation.

"A query that ran perfectly during development suddenly slows down as data accumulates." At such times, the mark of a truly skilled developer is identifying the root cause based on solid evidence rather than guesswork, and optimizing a 30-second query down to 0.1 seconds. Master the core principles of database performance—from execution plans, indexes, and optimizers to joins and sorting—using millions of rows of real-world data. Elevate your skills and become a top-tier developer capable of independently analyzing and resolving slow queries in production environments.

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!

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.

Starting from elementary school coding education to high school students in IT software departments, computer science college students, and job seekers from non-technical backgrounds, you can now meet the easy and fun coding lectures of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education, not only offline but also online. With Young Cody Kim, who has produced over 500 frontend, backend, full-stack, and web developers, your dream of becoming a developer will soon become reality!

If you are already a developer or want to become a developer but did not major in computer science and are weak in databases, gain lifelong knowledge with this one course!

This course completes the entire workflow of practical data analysis, from Excel data analysis to SQL, BigQuery, and Tableau dashboards, through hands-on projects. Rather than just teaching you how to use the tools, you will learn the data analysis structures and mindsets actually used in real-world analysis tasks.

With the advent of the AI era, building data pipelines has become a core competency that determines a company's competitiveness. Learn how to build efficient data pipelines using Airflow, the most widely used tool, directly from a Silicon Valley expert (formerly Head of the Data Team at Udemy, currently a professor in the Data Masters program at San Jose State University) with practical experience and extensive lecturing experience.

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.

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!

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

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

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 is a process of creating your own backend API server, using Node-based Strapi v4, without any additional coding, with just a few clicks, and deploying it to AWS EC2. Almost the same can be applied to Strapi v5. Please refer to the lecture A/S as well~

This course teaches you how to build a practical Unity game with a database. It covers difficult-to-access topics in an easy-to-follow lecture format.

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

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.

Channel Talk interviewers will directly analyze the difference between failing and passing answers to the same questions, and help you prepare for actual follow-up 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.

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