MySQL Performance Optimization

Practical Payment System Development Course, learn by code, and cover the knowledge needed to implement a real system.

Master prompt engineering perfectly, an essential skill for developers in the AI era.

Let's improve performance by utilizing the basic technology stack! After the improvement, we will check the changes through load testing and monitoring tools! We will also prepare for interviews on each topic!

I've created the 'MySQL Performance Optimization Intro/Practical (SQL Tuning Edition)' course, easy for non-majors to understand and immediately applicable in practice!

You will learn about what a node is, the latest JavaScript grammar, the node API, npm, the module system, databases, testing, and more. You will create a project using five practical examples. You will also deploy a service to the cloud and convert a node project to TypeScript.

Starting from elementary school coding education to high school students in IT software departments, computer science college students, and job seekers from non-technical backgrounds, you can now meet the easy and fun coding lectures of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education, not only offline but also online. With Young Cody Kim, who has produced over 500 frontend, backend, full-stack, and web developers, your dream of becoming a developer will soon become reality!

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

This course is designed to systematically learn advanced SQL features including GROUPING functions and window functions to prepare for the SQLD exam and improve practical data analysis skills. You will learn the concepts and applications of GROUPING functions and master methods for analyzing data at various aggregation levels. You will understand the basic concepts and types of **window functions (based on the OVER keyword)** and enhance your practical skills through hands-on exercises. You will learn **ranking functions (RANK, DENSE_RANK, ROW_NUMBER, etc.)** and window utilization options for aggregate functions through practical examples. You will work with **row order functions (LAG, LEAD, FIRST_VALUE, LAST_VALUE, etc.)** and practice time series data and order-based analysis directly. 👉 Through this course, learners will be able to expand their data aggregation and analysis skills to an advanced level, acquiring practical abilities that can be immediately applied not only for the SQLD exam but also in real corporate data analysis environments.

This course is designed to provide systematic learning from the basic concepts of relational databases (RDB) to foundational SQL skills. Learners will first understand the structure of databases and tables, work with SELECT statements which are the core of SQL language, and learn how to use various operators (arithmetic operators, concatenation operators). Additionally, learners will study the concept of **Functions** that are essential in data processing, and directly practice with string functions, numeric functions, date functions, and NULL-related functions through hands-on exercises, strengthening both theory and practical application simultaneously. Through this, learners will be able to go beyond simple data queries and develop foundational SQL capabilities that can be immediately applied to real-world data analysis and processing.

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

We enable you to fundamentally understand and resolve issues where Hangeul appears broken on web pages or in databases, or files contain unknown characters.

A must-have subject for aspiring developers and those looking to get a job in big data!!

This course covers how to create web applications using Node.js and MySQL.

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

This is a course on making practical Unity games with a database. Challenging areas can be covered in this course.

In this course, you will practice step-by-step using React and FastAPI to implement social features like real-time voting, comments, and likes, as well as integrating payment systems (KakaoPay, TossPay, etc.) for monetization.

This course is designed to help students learn and practice PHP programming concepts. It is designed for students who want to learn PHP programming concepts.

From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

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

Learning by Doing: 정보처리산업기사 I have prepared everything for passing the 정보처리산업기사 course-evaluation practical exam.

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

Create a SNS service using Vue and Nuxt frameworks. Learn the full stack knowledge required for the service.