SQL/DB Basics You Should Know Before Asking AI

With step-by-step explanations that even beginners can easily understand, the once-vague coding tests will become clear. Learn only what you need and apply it to real-world practice right away!

Beyond simply copy-pasting with AI, you will learn how to actually automate repetitive tasks for non-developer professionals by connecting Claude Chat, Cowork, MCP, n8n, Supabase, and Vercel. Set against the backdrop of a virtual company called DingcoLabs, you will follow hands-on scenarios for PM, Marketing, Sales, CS, and HR to build work automation systems that can be applied to your company immediately.

AI is no longer a choice, but a matter of survival. Shorten development tasks that used to take 3 days down to 30 minutes; leave repetitive tasks to AI and focus on solving more important problems. Through AI-native development methods that are practical rather than theoretical, we will show you the definitive way to be recognized as an "AI-savvy developer" at your company.

In a world where every resume looks the same, "differentiation" is what gets you hired. Over the course of 6 weeks, learn 4 practical resume strategies delivered directly by an active backend professional.

I aim to help you understand the core concepts of Python within 60 minutes! I focused on the "Why" and "When" to use them, rather than just blind syntax.

No coding skills? No problem! Turn your ideas into real profit in just 4 weeks. Use AI and the latest tools to build a website and an app simultaneously and launch your service right away.

We live in an era where AI can generate 10 files at once. However, if you can't track where the code changed, if it conflicts with your teammates' work, or if you don't know how to revert it—your productivity will suffer no matter how well you use AI. This course isn't just a list of commands like git add and git commit. It provides a visual understanding of the principles behind safely managing AI-generated code and merging it with your team's work. In just two hours, you will transform into a developer who can freely track, revert, and merge any code, whether it was created by AI or written by yourself.

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

You've probably written SQL using JdbcTemplate before, right? Everyone has likely had that experience of sighing while having to fix both the SQL and the RowMapper every time a single column changes. This course starts from that very pain. Doing a single SELECT with pure JDBC takes 35 lines. You open a Connection, create a PreparedStatement, iterate through the ResultSet, and if you miss a single close(), the server crashes. After typing through this hell yourself, when you finally encounter a single line of JPA's save(), you'll feel "this is why we use JPA" not just in your head, but in your hands.

This is an introductory backend development course where you learn through understanding rather than memorization, and experience rather than theory. Instead of reciting a Googled definition when asked "What is JPA?" in an interview, this course will empower you to give an answer based on experience, starting with "Well, I've been through JdbcTemplate hell..." You will gain a deep, intuitive understanding of "why we use frameworks" by experiencing firsthand how 30 lines of pure Java ServerSocket code shrink down to just 7 lines in Spring Boot. After 6 sessions, you will walk away with a functional portfolio piece: a Todo List REST API built with Spring Boot + JPA.

The importance of MySQL is constantly being highlighted in various aspects. Through this lecture, you will learn step by step and through this, you will jump to the intermediate level in one go.

This course was created for those who find databases challenging, making it easy to understand concepts and build your skills through practice. This lecture covers database fundamentals and SQL language usage. For learning how to create databases, you can take the database design course. Since most program developers encounter databases in their work, I've made an effort to explain in detail how to approach databases from a programmer's perspective.

You will learn the overall process of developing and deploying a website through generative AI (ChatGPT, Cursor AI).

Learn how to model data in a distributed database environment.

I have summarized the essential SQL SELECT statements and basic usage of Google Sheets that I learned while working as an analyst at a service company.

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.

Systematically learn the distributed NoSQL database Cassandra, from foundational concepts to real-world applications. Build your large-scale data processing skills through hands-on practice and practical theory covering data modeling, query optimization, and cluster configuration. Even without prior database experience, you can become a Cassandra expert by learning from the practical know-how of a Silicon Valley developer.

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

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

This is a course on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

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

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

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

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.

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 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.

This course goes beyond basic CRUD-level database operations, equipping you with practical PostgreSQL skills essential for the AI era from a real-world perspective. Drawing on AI development experience in Silicon Valley, you will learn step-by-step how to design and leverage JSON, indexing, transactions, and pgvector in actual production services, and master the techniques to resolve complex data structure and performance issues.

With Cursor AI, you can develop real-world web applications alongside AI even without extensive programming experience. However, simply using the code written by AI as-is makes it difficult to achieve the desired results. In this course, you will learn the development process required for practical work step-by-step by completing a single project—covering everything from how to effectively utilize Cursor AI to setting up PHP and MySQL development environments, database basics, SQL commands, and implementing a member management system. While directly implementing features frequently used in actual web services—such as member registration, member lists, duplicate ID checks, regular expressions, pagination, and viewing, editing, and deleting member information—you will also learn how to prompt the AI to obtain better code. Every process from installation to project completion is explained step-by-step so that even beginners can easily follow along. By the end of the course, you will understand the basic principles of web development using Cursor AI and PHP/MySQL database integration, and you will gain the skills to develop your own projects.

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.

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