MariaDB client development, HeidiSQL

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.

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.

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.

Let's edit and process the countless data generated through public services to build our own database, and discover another hidden world through a series of tasks that occur in the process and by utilizing SQL.

For those who frequently forget how far they've thought and organized, here is how to create and utilize mind maps through Freeplane!

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

[Only for those new to web development] Spring Boot REST API: Building step-by-step while properly understanding JPA

This lecture is a lecture on database basics in the [Web Development Full Stack Course] lecture series for training full-stack web developers. This lecture is a process of understanding database design while analyzing Netflix and Carrot Market. It is a basic lecture where you can learn basic database design principles and SQL.

[Newbies to Web Development Only] Let's Build a Spring Boot REST API Step-by-Step, the Easy Way

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

This course is a practical Airflow master program designed to help you understand "why Airflow works this way" and enable you to design and debug data pipelines on your own. It covers everything from Apache Airflow's core mechanisms to detailed theory and hands-on practice involving DAGs, Operators, Hooks, Scheduling, Timezones, Idempotency, and Templates.

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

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

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

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.

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.

This is a code-lab-oriented course where you will directly build big data or distributed processing system clusters (HDFS, Zookeeper, Spark, Zeppelin) that guarantee High Availability.

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

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 on creating practical Unity games with databases. It covers topics that are usually difficult to encounter, explained through lectures.

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 🚀

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.