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!

Learn practical strategies for designing efficient and scalable database structures that accurately reflect the complex requirements of real-world scenarios.

Learn how to model data in a distributed database environment.

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

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

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.

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

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.

Extract and utilize data through Oracle 18c and become a database expert!

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

This is a course on making practical Unity games with a database. Challenging areas can be covered in this course.

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.

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

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