Creating a table using public data CSV file

Sometimes, data processing is blocked and frustrating. If you are not a professional programmer or developer, learning unfamiliar fields such as Python or Java is not easy and there is not enough time. This is for those who only know Excel and SQL basics when it comes to frequently used things. This is the first part of the SQL query book that you can find and use when you need it.

Through a hands-on curriculum using MariaDB and HeidiSQL, you can learn the core concepts of SQL and how to use it in practice while collecting, preprocessing, and analyzing data.

We will create a remote development environment using VS Code and extensions, and learn about WSL and code-server, a VS Code used on the web.

If you are good at using mind maps, try expanding the areas of application. It can be used in various fields such as presentation materials, weekly reports, chronological timelines, agile scrum and to-do lists, storyboards, etc.

We will look at usage and examples of the 108 main internal functions provided by MariaDB using the HeidiSQL development tool.

Learn how to draw an ERD and convert it to a database and tables using MySQL Workbench.

We will study Total Commander, which allows you to manage folders and files in Windows more conveniently.

For those of you who often forget how far you've thought and organized, here's how to create and use a mind map using Freeplane!

Learn how to write SQL queries and work with databases using the MariaDB client development tool HeidiSQL.

A practical beginner course that completes SQL fundamentals in just 3 hours

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!

This course teaches you how to write performance-conscious queries during the SQL development phase, guided by a SQL Server expert. You can learn the basics for meeting query performance requirements along with practical case studies.

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

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

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

This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

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.

From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

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

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

SQLD Yellow Book 176 Problem Solving Lecture for You Who Studied but Cannot Solve Problems. After Completing the Course, You Will Become an Expert Beyond Passing. SQLD All-in-One Pass!

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

SQLD, where should I start? This course is for you who feel so overwhelmed; you'll meet a changed you after completing it. SQLD All-in-One Pass!

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