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.

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

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.

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 basic SQL SELECT grammar lecture that starts without installing SQL.

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

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.

Learn the easy and fun story of SQL Server operations from a Microsoft Certified Trainer! We explain core operational technologies that you can learn and use right away, and that are truly needed in the field, step by step so that even beginners can easily understand.

'Complete Mastery of Practical SQL in 49 Sessions I - Basic Course' contains essential content that you must know for SQL. By learning using a practical database, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems. For intuitive understanding, practice is conducted using a database written in Korean.

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.

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

This course will help you strengthen the core of your business marketing by teaching you how to leverage data to find marketing insights.

I'll show you everything about how to build servers for stateful services and how zero-downtime deployment works.

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

This is a content about backend development using two databases, MySQL and Mongo, for job seekers preparing for backend employment.

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

Learn how to use Google Spreadsheets effectively in your work.

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

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.

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

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

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

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.

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 🚀

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