SQL Query Book to Find and Use When You Need It, Part I

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.

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

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 covers everything from building a database to creating tables and manipulating and changing data within the database using various SQL queries.

This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

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

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

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

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

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

SQLD Yellow Book 176 Problem-Solving Course for those who studied but can't solve problems. After completion, you'll go beyond passing to become an expert. SQLD All-in-One Pass!

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.

For those who feel overwhelmed preparing for the SQLD exam, this is a comprehensive course that analyzes the entire Norang-i scope, organizes necessary theory, conducts practice-focused classes, and solves all problems systematically. With short, concise clips and topic-based segmented structure, you can build skills that work directly in the exam room.

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.

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

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

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 🚀

Make the most of relational database systems!

SQLD, where do I even start? This course is for those who feel completely lost - you'll meet a transformed version of yourself after completing it. SQLD All-in-One Pass!