SQL with a Silicon Valley Engineer

From a developer who only used ChatGPT to a developer who handles AI agents. Learn practical ways to maximize coding productivity using Codex's Rules, Hooks, Skills, and MCP.

Are you using AI but still typing new prompts every single time? Code is being generated, but are team-level automation and systematization still out of reach? This course is not about learning Claude Code as a "conversation tool." It is a course where you will learn how to design AI as a system using Agents, Sub-agents, Agent Teams, Memory, and Hooks.

Now, your AI is no longer in the cloud. It runs directly inside your laptop. Using LM Studio and Ollama, we will show you how to build a Private AI environment that runs entirely locally— from data processing and document analysis to code generation. Without security concerns, without costs, and even faster— Move beyond simply "using" AI and start "truly mastering" it.

"The technology that prepares you for the future, Docker" This course focuses on learning Docker quickly and easily. It explains the basic concepts and usage of Docker in an intuitive and easy-to-understand way, and through interesting practical exercises, you can learn solid skills that can be used immediately in practice, such as creating containers, building images, and setting up networks. This is the perfect course for those who want to quickly absorb and apply the latest technology to their work!

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 🚀

Learn Everything About Python from a Silicon Valley Software Engineer. Currently, as a 15-year veteran software developer, I handle everything from web applications, big data, and even SRE & DevOps, all with Python. From the basics of Python to advanced techniques, don't miss this opportunity to learn all the skills and know-how for using Python in real-world Silicon Valley practice!

Learn Elasticsearch, the core technology for data search and analysis in the rapidly growing IT field! We will teach you how to solve complex searches simply, along with hands-on practice that you can apply right away. Are you ready to upgrade your digital skills?

Are you still managing ML experiments manually? 🤔 Automate everything from experiment tracking to model deployment with MLflow, and dramatically boost your development productivity! An essential skill for data scientists and ML engineers 💡 Start right now! 🚀

Learn how to process big data from a Silicon Valley software engineer & how to develop big data code with Apache Spark using Python. I am a 14-year software developer who handles everything from web applications to big data and SRE & DevOps with Python. Don't miss this opportunity to learn about Apache Spark, which is essential for big data professionals, in an easy and in-depth way using Python!

Uncover true value in the age of data! 📊 Designing applications focused on data has now become essential. Develop the insight and skills your company wants with the latest trends and practical case studies. Start now with efficient data processing and design secrets! Your next step, leap into the data-driven world!

You will learn Apache Airflow, the most widely used Orchestrator for creating software data pipelines.

Don't miss the opportunity to learn about Kubernetes, the hottest infrastructure in Silicon Valley, from a practitioner!

How to Read the World with Data: Explore Your Own Data Science! Dive deep and practically into the tools and techniques that form the core of modern data science. In particular, you will learn how to analyze data and implement algorithms using Anaconda, Numpy, Pandas, and Scikit-learn, essential components of data science.

“There are many ways to solve problems, but why do we feel lost during interviews?” This lecture offers coding interview survival strategies directly from a current engineer working in Silicon Valley. Focusing on problems frequently encountered in real interviews, we'll guide you not just through simple solutions, but also how to articulate your thought process and how you'll be perceived from the interviewer's perspective. Designed for mid-level developers and above, the curriculum is optimized for real-world interviews. If you are preparing for coding tests and technical interviews, gain practical skills and confidence through this lecture.

Linux is an operating system widely used on various platforms worldwide, including servers, the cloud, and IoT devices. Through this course, you can enhance your competitiveness in the IT field based on a deep understanding of Linux. Furthermore, by acquiring expertise in open-source technology, you can prepare for the future technological landscape and stand out in a high-demand job market.

🔥 Vibe Coding with Streamlit 🔥 Real-time coding experience where you can instantly create your own web service with just one line of code! Visual-focused, hands-on lectures tailored to MZ sensibilities - no complex backend knowledge required. Learn the basics of Streamlit and awaken your development instincts by directly implementing practical apps. Complete your own "personal service" with code in a vibe way right now 😎💻

This is a practical Ansible course taught by Silicon Valley engineers. Ansible is a powerful tool for automated infrastructure management and provisioning, saving time and effort and building a consistent environment.

"Enter the world of Cloud Infrastructure Automation!" Terraform, an infrastructure automation tool, is used to provision and manage resources in a cloud environment. Now, you too can define and automate your cloud infrastructure as code to quickly and consistently configure an infrastructure environment!

Apache Superset is an open-source BI tool that lets you quickly create charts and dashboards by connecting multiple databases. You can visualize data without knowing code, and SQL Lab allows you to run queries directly, making it useful for everyone from beginners to professionals. The dashboards you create can be shared immediately with permission settings, making it perfect for collaboration. Learning Superset gives you the ability to make data-driven decisions quickly and build practical dashboards you can use right away at work. In short, it's perfect for anyone who wants to make data "speak." 🚀

Real-time data processing is now essential, not optional! Learn to handle real-time streaming smartly with Apache Flink. Batch? Streaming? Even complex concepts can be understood easily and quickly. Hands-on practice configuration where you'll get the hang of it by directly working with Kafka and DB integration! In a world driven by data, start first with Flink.

Redis is a fast and scalable open-source database. This technology is used to maximize performance in real-time applications, games, social media platforms, and more. However, to truly understand the power of Redis and use it effectively, you need a deep understanding. Now is your chance to learn Redis in a professional way. "Redis with Silicon Valley Engineers" covers a wide range of topics, from the core concepts of Redis to advanced features. This course is designed for everyone, from beginners who are new to Redis to advanced users.

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 🚀

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.

Real-time data processing is now essential, not optional! Learn to handle real-time streaming smartly with Apache Flink. Batch? Streaming? Even complex concepts can be understood easily and quickly. Hands-on practice configuration where you'll get the hang of it by directly working with Kafka and DB integration! In a world driven by data, start first with Flink.

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.

You can learn how to handle data frames (tables) using Python, similar to the SELECT statement in SQL.

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

We conduct app log analysis using data from Google Analytics 4 and Firebase. It includes useful content for practical use, such as arrays, window functions, funnels, retention, Google Sheets, and more.

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

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

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

If you want to be recognized as a machine learning expert in large-scale data environments—from understanding the core framework of Spark Machine Learning to SQL-based data processing through high-difficulty practical problems, and the ability to implement optimized machine learning models through business domain analysis—join this course.

This course is a practical Airflow master program designed to help you understand "why Airflow works this way" and enable you to design and debug data pipelines on your own. It covers everything from Apache Airflow's core mechanisms to detailed theory and hands-on practice involving DAGs, Operators, Hooks, Scheduling, Timezones, Idempotency, and Templates.

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.

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.

Uncover true value in the age of data! 📊 Designing applications focused on data has now become essential. Develop the insight and skills your company wants with the latest trends and practical case studies. Start now with efficient data processing and design secrets! Your next step, leap into the data-driven world!

This lecture comprehensively organizes the content that would be good for those who want to get a job as a new Spring Java backend developer, especially those who are about to have an interview.

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.