Data analysis starting with SQL and Google Sheets

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.

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

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.

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

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

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.

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

Easy and fun SQL stories learned from professional instructors! Lectures are conducted systematically and step-by-step for beginners. We offer opportunities to learn with sufficient repetition through a 3-step learning process.

This is an Oracle DBMS SQL course for beginners.

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.

This course completes the entire workflow of practical data analysis, from Excel data analysis to SQL, BigQuery, and Tableau dashboards, through hands-on projects. Rather than just teaching you how to use the tools, you will learn the data analysis structures and mindsets actually used in real-world analysis tasks.

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

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

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.

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

We will inform you about the platform mass adoption method using AWS (S3, CloudFront) and MySQL (Geospatial Query).

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.

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

Data Analysis that Determines Online MD Performance! Learn essential data analysis and strategy formulation techniques necessary for MDs to maximize sales and profit in the e-commerce market.

What do you learn in the 'Management Information Visualization Professional' certification course? This certification course focuses on developing the ability to analyze data effectively, visualize it for easy understanding, and communicate necessary information clearly and efficiently for important decision-making within companies or organizations. In simple terms, it is a process of learning the skills to not just look at data, but to uncover hidden meanings within it and express them through charts, tables, and graphs so they can be easily explained to others. Through this course, you will: Develop the power of strategic thinking through data, build practical skills that can be applied immediately to real-world tasks, and enhance your professional expertise and competitiveness. Through this lecture, cultivate the ability to connect management with data and take a step forward as an expert who understands and explains data.

This is a course aimed at obtaining the nationally recognized SQLD certification, and SQLD refers to developers who can write accurate SQL for manipulating and extracting data while developing application software based on database and data modeling knowledge.

Let's understand data analysis suitable for advanced retail business and learn how to utilize tools utilized in the industry!

Learn how to use Google Spreadsheets effectively in your work.