Database Classics - Basics and Practice

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!

Starting from elementary school coding education to high school students in IT software departments, computer science college students, and job seekers from non-technical backgrounds, you can now meet the easy and fun coding lectures of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education, not only offline but also online. With Young Cody Kim, who has produced over 500 frontend, backend, full-stack, and web developers, your dream of becoming a developer will soon become reality!

If you are already a developer or want to become a developer but did not major in computer science and are weak in databases, gain lifelong knowledge with this one course!

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

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

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

mongoDB, NoSQL You hear a lot these days, but is it still an unfamiliar database? Aren't you using it like a relational database (RDS/SQL)? No matter how good the technology is, if it's not used correctly, it will have the opposite effect. That's why we often see cases of failure in using MongoDB. This lecture will teach you everything from basic concepts to practical know-how so that you can use MongoDB as MongoDB-like as possible.

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

I learned it the hard way, so you can learn it the easy way I've discarded unnecessary theory and included only the SQL essentials. Quickly build your SQL confidence.

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

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.

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

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.