Database MSSQL

In this lesson, you will learn how to create an .EXE file. You will also learn how to install an MSSQL database and request data in C#.

We cover ASP.NET Core, which is mainly used by foreign companies and large corporations.

You can learn how to solve concurrency problems, how to tune procedures, and how to speed up query execution. You can also learn various know-hows such as common mistakes and problems that occur in practice. (The only refactoring lecture in the world)

Learn C# for developing applications like ASP.NET, Winform, WPF, and MAUI that run on the .NET Platform.

We will cover ASP.NET Core Identity, creating bulletin boards, EF Core, data filtering, etc.

In this lecture, you will learn how to create an ERD. You will learn database design. (The only big data design lecture in Korea)

This is a WPF lecture that will be helpful to developers who are considering introducing WPF in WinForms, application developers who are hoping to get a job in the US, and those who are hoping to get a job as a developer. It is not a lecture focused on theory and design, but covers content that can be used in practice.

You can solve design problems by writing code in a formatted way. You can understand code or patterns written by other programmers.

This is an Oracle course, one of the top 3 databases. Even if you are learning databases for the first time, you can easily learn.

Learn about MAUI cross-platform development, which lets you develop and run Windows, macOS, iOS, and Android applications with a single code base.

Creating an application on Linux (Ubuntu OS). (Cross-platform application development)

This course teaches you how to communicate in real-time with ASP.NET Core, MAUI, and WPF using SignalR.

The meeting of Enterprise Architecture (EA) and Spring Framework adopted by large corporations and foreign companies! The world's only Enterprise Architecture X Spring Framework lecture. In addition, it is structured to be more helpful in applying actual development projects by satisfying the conditions of electronic government frameworks frequently used in practice.

SSIS, SSAS, MachineLearning, BI, ETL. You can learn important technologies that cannot be found in domestic books, YouTube, lectures, blogs, and academies. I also recommend it to those who are interested in employment at domestic large companies, American large companies, and American state funding agencies.

This is a class diagram lecture in UML. This is a design lecture.

This is a course to learn MariaDB, a commercially available database. Even if you are learning about databases for the first time, you can learn it easily.

This course covers the essential knowledge that every 0.5 to 3-year C# application developer should have.

This course covers the essential knowledge that every 0.5 to 3-year C# application developer should have.

Let's learn the C# language. You can learn it even if you don't know the C language. The development tools are also installed from the beginning.

Learn how to save, modify, delete, and query data in a database. Anyone, regardless of major, can easily follow along in just 30 minutes.

You can learn how to solve concurrency problems, how to tune procedures, and how to speed up query execution. You can also learn various know-hows such as common mistakes and problems that occur in practice. (The only refactoring lecture in the world)

This course is an easy-to-understand explanation of database design theory, focusing on practical exercises. Most people who have experienced it through books, etc. have probably felt that database theory was difficult and given up. I did the same. However, if you know it, you will find that it is an easy and very interesting field. In this course, the design content is organized so that you can understand it just by looking at it.

Make the most of relational database systems!

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

In this lesson, you will learn how to create an .EXE file. You will also learn how to install an MSSQL database and request data in C#.

Learn how to model data in a distributed database environment.

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

Backend Entry Worry: Over! From HTTP, API, DB basics to the latest tech (MSA, Docker, Cloud)! Backend development knowledge learned easily and systematically!

This course provides a step-by-step learning path, ranging from the fundamental usage of MySQL to advanced techniques required in real-world production environments. It covers a wide range of topics, including data modeling techniques based on various case studies and practical data, evaluating the effectiveness of Foreign Key designs, analyzing Google Calendar schema DDL, and modern DDL design principles. Through this course, you will gain an in-depth understanding of how to utilize MySQL as a core system component rather than just a simple database.

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 🚀

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.

This lecture comprehensively organizes the content that would be good for those who want to get a job as a new Spring Java backend developer, especially those who are about to have an interview.

This is a WPF lecture that will be helpful to developers who are considering introducing WPF in WinForms, application developers who are hoping to get a job in the US, and those who are hoping to get a job as a developer. It is not a lecture focused on theory and design, but covers content that can be used in practice.

A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

I've created a 'Redis Beginner/Practical (Query Performance Optimization)' course that's easy to understand even for non-majors and can be applied immediately in real-world situations!

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

This is a course on creating a practical Unity game with a database. You can learn through lectures about aspects that are difficult to encounter.

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.

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

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