인프런 - 라이프타임 커리어 플랫폼

Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

Learn about the basics of Python required for data analysis, the data analysis framework (pandas), and the data analysis process.

By skimming through the content of the Tableau certification, you can understand the overall functions of Tableau in a short period of time.

There was a rumor that Ediya would open a store near Starbucks. How different would the locations of Ediya and Starbucks be? Will the real estate price fluctuation trend from 2013 to 2019 be reflected in the apartment sales price? What kind of parks are there in my neighborhood? How can I utilize the data in the public data portal? The goal is to become familiar with Python and various data analysis libraries by handling various types of data through public data.

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

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.

This course is for both beginners who have never been exposed to programming before and those who have some theoretical knowledge about Python. The main purpose of the course is to create interest and enjoyment in Python based on real projects. I hope that through this course, you will gain more ideas and have more fun with Python.

A theory-practice QGIS course covering analysis basics, advanced functions, and visualization introduction for QGIS utilization. Start QGIS by taking this unprecedented all-in-one course!!

Not only will you master Python and GIS! A practical QGIS course, you'll even learn automation using both.

You will be able to extract the data you want directly without the help of a developer. We will provide everything you need for analysis, from simple queries to joins. Start learning SQL with a direct lecture from the author of the book <Planner's SQL>.

In this class, you will learn about the principles and methods of analyzing and processing various types of financial data using Python's Pandas library, apply them to situations you may encounter in the real world, and ultimately learn how to implement backtesting based on financial statement data (based on Kang Hwan-guk's book, "You Can Do Quant Investment"). As a result, you can break away from being a "passive investor" who simply follows what others say without verifying or basing the investment logic, and become a "self-directed and active investor" who can freely extract various elements necessary for strategy implementation from data and quantitatively analyze them using Python and Pandas.

From basics to advanced data analysis! Based on what you've learned, analyze data yourself using data from Jeju Island!

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

Learn NoSQL technology, which can handle Big Data, one of the fundamental technologies in full-stack and data science utilized by modern startups. MongoDB is the easiest and quickest technology to utilize among NoSQL databases. In this lecture, you will learn the basics of MongoDB in a short time, and also acquire the skills to manipulate and utilize MongoDB with Python.

For those looking to learn Data Science, Big Data, and Crawling, (1) we will summarize the most essential Python core syntax in a short time, and (2) you will become familiar with Python and crawling through practical crawling programming.

This is a basic/introductory course on digital marketing. It covers how to design digital marketing based on data and various practical cases. It contains stories and content that I want to share from my 14 years of experience in various fields of marketing, from digital marketing agencies to in-house marketers at large corporations. It is recommended for those who want to understand digital marketing in general.

Do you want to create a tool that can help you with your real-world investments using Python? In this course, you will learn how to create an interactive web dashboard for financial data analysis for intermediate Python users and learn about pair trading strategies for in-depth quantitative work. We hope that you will be able to create your own useful analysis tools to help you analyze financial data more powerfully and make wise investment decisions.

This is not an investment lecture. It covers data collection, analysis, and visualization through securities data. It covers various data formats and teaches various text preprocessing techniques. It covers visualization techniques for time series data and methods for expressing scale. It covers several techniques for interpreting stock price data. This lecture is a course that teaches you how to gain insights through data analysis. The content learned through stock price data is organized so that you can apply it to collecting, analyzing, and visualizing data such as demand, inventory, sales, and traffic volume, where time series is used.

When you use Pandas for data analysis, preprocessing, machine learning, and deep learning, you tend to use only the functions you use frequently. There is a Pandas Cheat Sheet that collects and organizes only these essential contents. For those who get tired of learning Pandas from a thick book, we will teach you Python Pandas with just two pages of documents. Learn the core functions of Pandas with the cheat sheet provided in the official Pandas tutorial.

This is a lecture on how to use NumPy and practice its application in real-world scenarios.