Analysis and Visualization of 5 Million Korean Apartment Transaction Data with PostgreSQL

This is a lecture that teaches you how to save time and maximize your work productivity by using NotebookLM.

GCP (Google Cloud Platform) is Google's cloud computing service, offering a variety of infrastructure and platform services. This allows you to leverage various functionalities.

This is a lecture on performing performance and load tests on a sample Web Application using Locust.

This article describes the process of creating AWS resources based on AWS InfraArchitecture using Terraform modules.

This is the process of designing and implementing applications and directly designing and configuring Cloud infrastructure architectures to run developed programs in a Cloud environment.

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.

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

A DBA instructor with 30 years of experience teaches 45 essential SQL tuning techniques that can be immediately applied in practice through real-world examples. Master the practical know-how to make slow queries 10 times faster, from execution plan analysis to index optimization and join tuning!

A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

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.

From building a database to creating tables, you can manipulate and change data within the database using various SQL queries.

mongoDB, NoSQL You hear a lot these days, but is it still an unfamiliar database? Aren't you using it like a relational database (RDS/SQL)? No matter how good the technology is, if it's not used correctly, it will have the opposite effect. That's why we often see cases of failure in using MongoDB. This lecture will teach you everything from basic concepts to practical know-how so that you can use MongoDB as MongoDB-like as possible.

Learn how to model data in a distributed database environment.

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

★PYTHON★ This is a basic lecture on server development using Fast API. Learn how to develop servers easily, quickly, and conveniently using various packages such as Fast API, SQLAlchemy, Pydantic, and Starlette! Don't worry, we have prepared a DB backup file as well as integration with PostgreSQL! We will teach you the "basics" of UI design using Dash and Plotly and provide the source code used in the lecture :)

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

This is a code lab-based class where you will directly build a big data system or distributed processing system cluster (HDFS, Zookeeper, Spark, Zeppelin) that guarantees high availability.

★.NET 8.0★ This is a basic course on Windows Desktop development using Winform. Learn how to easily do DB CRUD using EntityFrameworkCore. We will teach you the class design method based on loose coupling and the "basics" of Form UI Design. We will also provide the source code used in the course :)

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

Knowledge Graph-based RAG System Implemented with Neo4j: Next-generation search technology that leverages data relationships beyond simple vector search Maximize RAG performance with the power of graph databases!

Revolutionize your stock investments with AI! In this lecture, you will directly build a real, working AI automated trading system targeting the top 25 NASDAQ stocks. We provide a special opportunity to gain experience and know-how through simulated investments with the 한국투자증권 API, and to perform AI stock automated trading with a real account. Even stock beginners will have no problem. We will easily explain basic stock concepts and why you should invest in US stocks, and provide all source code and remote support. From now on, investment is essential for the next 60 years of our lives. Create your own AI investment partner that will be with you!

This course teaches MS-SQL through baseball/company databases.

What do you learn in the 'Business Information Visualization Certification' course? This certification course focuses on developing the ability to analyze data well, visualize it in an easy-to-understand way, and clearly and effectively communicate the information needed when making important decisions in a company or organization. Simply put, it's a course where you learn the skills to not just look at data, but to discover the hidden meanings within it and express them through pictures, tables, graphs, etc., so you can explain them well to others. Through this course, you will: Develop the ability to think strategically through data, build practical skills that can be immediately applied to actual work, and enhance your professional expertise and competitiveness. Through this lecture, develop the ability to connect business and data, and take one more step toward becoming an expert who understands and explains data.

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.

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.