Life Coding - SQLite

The basics of database! We will help you to clearly understand the concept of your DB. We will help you not to get lost in any study related to database in the future.

When you ask AI, “Give me the top 10 by sales,” it can instantly whip up a plausible-looking query. But to judge whether that query is correct, whether the result of joining three tables is accurate, or whether it’s doing a full scan of 500,000 rows without an index —you ultimately need a solid grasp of database fundamentals. This course doesn’t cover anything difficult. In just two hours, you’ll type along and learn the full flow of SQL, covering only what you need to know before asking AI to do it for you. By the end of the course, you won’t feel uneasy anymore when faced with a query written by AI.

Learn about Race Condition, a representative concurrency problem. Practice by comparing single server environments and distributed environments that cause concurrency issues. Understand transaction boundaries and isolation levels. Learn the differences between optimistic locking, pessimistic locking, and distributed locking.

Systematically learn the distributed NoSQL database Cassandra, from basic concepts to practical application. Develop high-volume data processing capabilities through practice-oriented theory and hands-on exercises, including data modeling, query optimization, and cluster configuration. Even without prior database experience, you can grow into a Cassandra expert based on the know-how of a current Silicon Valley developer.

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.

With the arrival of the AI era, the skills required of developers are becoming increasingly complex. You might have thought, "I just need to be good at frontend," but when you try to create your own service or integrate AI features, you eventually hit a massive wall called the backend. However, as you try to start backend development, are you overwhelmed by how much there is to learn—from database design and authentication (Auth) to storage management and complex infrastructure setup? Now, you can lay down that heavy burden. In this course, we use Supabase, which solves all these backend functions at once. We will guide you through the fastest shortcut to becoming a full-stack developer who can "instantly" complete a backend without complex server knowledge and bring ideas to life immediately.

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.

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

I learned it the hard way, but I want you to learn it easily. I've discarded unnecessary theories and included only the core essentials of SQL. Build your SQL confidence quickly.

Introduction to SQL Data Analysis! Quick and easy to understand with practical problem solving!

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.

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.

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

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.