From Introduction to Utilization of MSSQL Server 2016-based Database Part 1

This course covers everything from building a database and creating tables to manipulating and modifying data within the database using various SQL queries.

You can build a database, create tables, and manipulate or change data within the database using various SQL queries.

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

You will be able to extract the data you want directly without the help of a developer. We will comfortably cover everything needed for analysis, from simple queries to joins. Start learning SQL with a lecture directly from the author of the book <SQL for Product Managers>.

A must-have subject for aspiring developers and those looking to get a job in big data!!

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

This is a practical backend course designed to cultivate the service planning and design thinking skills that developers need in the AI era.

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

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.

"I have a backend technical interview in a week—where should I start?" The secret to answers that make interviewers nod in approval. Fully master the actual answer patterns of successful candidates from Naver, Kakao, Coupang, and Toss in just 3 days!

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.

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

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

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.

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.

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

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.

In this lesson, you will learn how to create an .EXE file. You will also learn how to install an MSSQL database and request data in C#.

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

Immutable truths for developers/engineers that will never change even in the AI era! We provide essential computer science knowledge for free to prepare for developer/engineer job applications and technical interviews.