Khái niệm cơ bản về cơ sở dữ liệu - Khái niệm cơ bản và thực hành

Are you familiar with Python now? Python is the most widely used language for collecting, analyzing, and utilizing data. If you want to use Python for data science, today's lesson will be really helpful. We will install and use Python modules and packages, aka libraries, related to data science.

Python, now you're doing it? Then, can you implement GUI using PyQt in Python? In order to implement GUI using Python, I've included only the most necessary content, focusing on the most frequently used syntax in actual development sites, utilizing the package PyQt.

Team leaders, you say, if you give me an Excel file, I have to look at it one by one? Can't you organize it so that it's pretty and easy to see at a glance? I'm busy organizing and analyzing data, but when will I edit it nicely? When that happens, you think, how great would it be if there was a magical tool that visualizes the Excel data I organized beautifully? Yes, there is. Power BI, a magical tool created by MS. It's a simple visualization tool that makes it easy to see the Excel data you created at a glance, and once you create it, it's continuously updated and used later! We'll tell you very, very easily and kindly what the program is and how to use it!

What do you do with Excel? Sorting and filtering the data that pours in? What do you do when your team leader suddenly wants data? You want a lot of data, and you are always busy and waste time, right? Have you heard of pivot tables? You may have even used them. But! Pivot tables are easier than you think, and there are more hidden functions. Here is a secret that will drastically reduce the time you spend handling, analyzing, and organizing data.

It contains only the most essential content, focusing on the most frequently used phrases when doing web crawling in the field. Once you learn it, you can use it in many different ways.

Learn Python easily and quickly with patterns. Learn only the essentials in a concise manner 💪

Rather than a boring and obvious Python lecture, we've collected the most frequently used Python patterns in the field.

Excel Basics: Build your stamina! Witch's Excel Honey Tip Recipe 📚

Are you working overtime because of Excel? Or are you having trouble getting your work done because of an error? For you, I have prepared 10 really, really useful tips for using Excel!

This is a course on creating practical Unity games with databases. You can work through the difficult-to-approach parts through the lectures.

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.

This is a SQLite lecture provided by Living Coding (Open Tutorials), which will help you get started with the relational database SQLite.

This course focuses on building the real skills needed in development practice. The goal is not simply to learn how to write code well, but to feel how to work well as a developer. The examples are based on the commerce domain, covering cases frequently encountered in actual work, and are provided with SpringBoot & Kotlin. However, it's a course that is not dependent on language/framework and allows anyone to contemplate through thought-provoking material and experience real-world practice.

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

Learn how to analyze 5 million Korean apartment transaction data using PostgreSQL. Covers the process of data cleaning, transformation, and deriving meaningful insights through various SQL queries.

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.

[Web Dev Beginners Only] Build a Spring Boot REST API easily, step-by-step, fully understanding JPA.

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

Learn about Race Condition, a representative concurrency problem. Practice by comparing single server environments and distributed environments that cause concurrency issues. Understand transaction boundaries and isolation levels. Learn the differences between optimistic locking, pessimistic locking, and distributed locking.

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

Secrets of people who are good at their jobs! How should I start with SQL? It covers everything from SQL installation and basic environment configuration to simple practical exercises that can be used in real life! You can also learn basic commands step by step through practical exercises.

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.

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.