Phát triển MariaDB Client, HeidiSQL
swa
MariaDB 클라이언트 개발 도구 HeidiSQL để tìm hiểu cách tạo truy vấn SQL và xử lý cơ sở dữ liệu.
중급이상
SQL, MariaDB, HeidiSQL
Creating a table using public data CSV file
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.
What you will gain after the course
Creating a table with public data
Text data processing method
How to use MariaDB environment SQL
HeidiSQL Hidden Features
With fun and rich public data📊
Let's take a big step into the world of data!
Data as I wish
For those of you who want to cook 🍽️
Databases and SQL are considered sophisticated areas of IT knowledge. SQL, in particular, is a language close to natural language, allowing for the systematic organization of vast amounts of data using a limited number of reserved words and the rapid and accurate retrieval of desired information. However, for non-experts, the barriers of "code" and "expertise" often prevent them from being treated as mere large Excel files. This holds true even in the real world.
Marketing and planning experts may not know code, but their perspective on the market is unique. What would happen if we gave them public data and SQL tools ? How would the public data market appear to a seasoned IT veteran starting a new career?
Anyone interested can access the public data portal
Access countless public data DBs by field,
You can edit and process it to your liking.
For over a decade, databases existed solely on servers, with the raw data stored there, accessible only to so-called field experts. However, now, sites like public data portals are churning out countless data and specialized knowledge on a daily basis. Anyone with the interest can now build a database on their own PC, laptop, or even tablet.
In this era, where everyone has the opportunity to access and manipulate data fairly and freely, we aim to provide experts in various fields with a source of data resources through public data, along with the appropriate tools to utilize them.
After encountering public data ,
Your worries will be solved 💡
In this lecture !
✅ Learn how to create tables using public data.
✅ The goal is to improve your overall SQL level through a series of tasks that occur along the way.
(Acquire database knowledge for editing, processing, and uploading files)
✋ What if you're a developer whose schedule keeps getting delayed whenever data is mentioned?
Clear your mind and take a break at the temple called DB! Approach data as an independent discipline. Even if you don't know much about databases, you can gain confidence in data. It's just the beginning.
✋ What if you're a marketer who needs to leverage data but isn't comfortable dealing with development teams?
Take your first steps into the language of data. You'll gradually become familiar with the dictionary term "DB" and the letters "SQL." Technical communication might just begin. A single marketer might even be able to persuade the development team.
✋ What if you are a planner struggling with proposals and ideation?
Explore the world of public data, a world more exciting than games, and discover innovative ideas. Wherever there's data, you'll be able to focus on it. Because you can look into it.
✋ What if you are a developer who started later than others and is having a mental breakdown about what to do and whether you are doing well?
A persimmon that's late is always sweeter! Understanding your data can help you feel more confident. You might even discover why you've been stuck, why you've been slow, why you've been frustrated, and why you've been feeling stuck.
Unique features of this course
Check it out 📌
- Practice speaks louder than theory! We don't cover much theory, and most of the learning is hands-on.
- Initially, it may be difficult to follow the data editing process. During the course, we will create over twenty tables and upload data to help you become accustomed to data editing.
- As a bonus, you'll also learn HeidiSQL, a MariaDB SQL tool, and some of the big and small features of Notepad++.
- We provide a simple level quiz to help you become familiar with the table.
- There may be many example tables that are not normalized or cannot be normalized. The goal of this lecture is not to normalize data, but rather to demonstrate that "I can do this with data, too!"
📢 Please check before taking the class!
- You should have basic knowledge of SQL and MariaDB as a beginner.
- We provide summary materials and example files in the form of text files (.txt) according to the class content.
Q&A to review before class 💬
Q. Is there anything I need to prepare before attending the lecture?
You should have some basic knowledge of SQL and MariaDB.
Q. Is this a course that non-majors can also take?
If you have basic SQL and MariaDB knowledge, you can learn it. If you work at an IT company, it will enhance your understanding of developers and development teams. Even for other roles, if you're familiar with Excel, I think you'll find it quite useful.
Q. What are the benefits of learning SQL/MariaDB/HeidiSQL using public data?
We can broaden our understanding of data. Data is a social phenomenon, human relationships, and the footprints we leave behind as we move forward. Understanding data can provide clues as to where to go.
Q. What can I do after taking this course?
You can access information and statistics using public data on your own PC. To exaggerate a bit, you can indirectly experience things like commuter traffic, real estate market trends, consumer sentiment, price fluctuations, and even natural phenomena, all from the comfort of your own home. If you even follow the daily news, you might find yourself nodding along before you know it.
Q. What level of content is covered in the class?
Rather than focusing on database-specific aspects like normalization or advanced SQL techniques, the main goal of the course is to teach you, "I can handle data with this!" The course focuses on less theory and more practice.
Q. What environment do I need to prepare to take the course?
You just need enough memory to install and run MariaDB on your personal desktop or laptop (at least 8MB of memory).
Recommended for
these people
Who is this course right for?
Coder crews who become anxious when standing in front of data
Marketing fanatics, it's time to get out of Excel.
Business proposals are not scary. With public data.
How late is it? Add a spoonful of data to your boiling passion.
Need to know before starting?
MariaDB
HeidiSQL
SQL
2,617
Learners
67
Reviews
27
Answers
4.8
Rating
10
Courses
안녕하세요 『소프트웨어알림장』입니다. 데이터베이스 및 미들웨어 애플리케이션 개발, 응용 분야의 경험을 쌓아왔으며 MySQL과 MariaDB를 바탕으로 SQL을 활용한 강좌들을 제작하고 있습니다. 유튜브 채널 "SQL뱅크" 를 운영하고 있습니다.
Hello, this is "SQL BANK". I have accumulated experience in developing database and middleware applications and in various application fields. I create tutorials utilizing SQL based on MySQL and MariaDB. I also run a YouTube channel called "SQL BANK".
Curriculum
All
23 lectures ∙ (6hr 29min)
Course Materials:
Lecture resources
Published:
Last updated:
Reviews
All
2 reviews
5.0
2 reviews
daeheepark1382Reviews 2
∙
Average Rating 5.0
- pink321ryu
Reviews 21
∙
Average Rating 5.0
5
100% enrolledTôi tò mò về việc chuyển đổi dữ liệu công khai thành cơ sở dữ liệu và không biết cách thực hiện, nhưng thông qua khóa học này, tôi đã có thể hiểu rõ về nó thông qua các giải thích chi tiết và lặp đi lặp lại. Ngoài ra, tôi đã có thể tìm hiểu các hướng dẫn sử dụng cơ bản cần thiết cho bài giảng thông qua một bài giảng miễn phí riêng biệt, điều này giúp tôi dễ dàng truy cập hơn và tôi đang cố gắng sử dụng nó trong công việc của mình. Cảm ơn
- swaInstructor
Khóa học này được coi là khó theo dõi ở cấp độ SQL mới bắt đầu. Tuy nhiên, nhìn vào nội dung và tính logic trong các câu hỏi của Ryu Jae-an, tôi có thể cảm nhận được rất nhiều niềm đam mê và chuyên môn, và tôi nghĩ anh ấy có đủ năng lực cần thiết, đặc biệt là trong lĩnh vực xử lý dữ liệu. Chúng tôi dành cho bạn một tràng pháo tay thật lớn và sự ủng hộ vì bạn đã không bỏ cuộc cho đến cuối cùng và tham gia hết các bài giảng. Nhờ có Jae-an Ryu, những bài giảng mà tôi nghĩ có phần còn thiếu sót đã trở nên ý nghĩa và bổ ích hơn. Ngoài ra, cảm ơn bạn rất nhiều vì đã cho chúng tôi một đánh giá hào phóng.
$30.80
swa's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
![[2025] SQLD All-in-One - Đỗ ngay lần đầu dành cho người không chuyên강의 썸네일](https://cdn.inflearn.com/public/files/courses/336953/cover/01jr02gfpt2km3k50amyw7sttt?f=avif&w=420)
![[Loạt bài phát triển game MMORPG thực hiện bằng C# và Unity] Phần 5: Cơ sở dữ liệu강의 썸네일](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![Hướng dẫn hoàn chỉnh MongoDB dễ hiểu và sâu sắc nhất [ By. Người không chuyên ngành & Nhà phát triển Kakao ]강의 썸네일](https://cdn.inflearn.com/public/files/courses/337578/cover/01jwt82r7jn3c9mzybfn00mdnh?f=avif&w=420)
![Bootcamp chinh phục hoàn toàn từ Java cơ bản đến Oracle SQL [Phiên bản đầy đủ]강의 썸네일](https://cdn.inflearn.com/public/files/courses/336223/cover/01k2j32xzj93q4a4mhs8ra9q4b?f=avif&w=420)
