Data analysis starting with SQL and Google Sheets

This is a [Data Analysis, Programming Language] lecture prepared for SQL data analysis beginners. This is a SQL SELECT basic grammar lecture that starts without installing SQL.

This is a basic SQL SELECT grammar lecture that starts without installing SQL.

I wanted to briefly cover the basics of Python through Jupyter Notebook, which allows you to immediately check the results of your coding.

You can quickly convert MATLAB code to PYTHON by extracting only the PYTHON grammar that matches the MATLAB grammar.

This course covers the most important and basic grammar in MATLAB through simple examples, so that even non-computer experts can learn it quickly.

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

This is not a complete list of Google Spreadsheets, but rather a collection of only the things I use to preprocess data in my field.

Through detailed lectures and hands-on practice on the core elements of SQL, we will provide you with a solid foundation to grow into a SQL analysis expert.

Learn how to analyze 5 million Korean apartment transaction data using PostgreSQL. Covers the process of data cleaning, transformation, and deriving meaningful insights through various SQL queries.

Learn how to model data in a distributed database environment.

It provides a key guide to understanding the internal mechanisms of Oracle DB architecture and growing as a performance tuning and performance analysis expert.

Instead of long and boring theories, you can learn them one by one through short practical exercises, and as you flesh them out one by one, you will soon be able to experience the overall architecture composition.

Technology should also start with interest. I have prepared a story about a person who analyzes MBTI of his coworkers. I hope that those who have been daunted by SQL will start studying it with enjoyment.

We covered the concepts considered while migrating 20 billion data items managed through the existing MongoDB to MySQL.

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

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 is a course for learning MS-SQL through baseball and corporate databases.

Learn how to use Google Spreadsheets effectively in your work.

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.

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

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

Knowledge Graph-based RAG System Implemented with Neo4J: Next-Generation Search Technology Utilizing Data Relationships Beyond Simple Vector Search Maximizing RAG Performance with the Power of Graph Databases!

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam 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.

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 will help you strengthen the core of your business marketing by teaching you how to leverage data to find marketing insights.