Creating a table using public data CSV file

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?

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 💡

✋ 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!"

_{Section 3 "From File to Table"}

_{Section 4 "Public Services on the Table"}

_{Section 5: "Public Data, Common Standard Terminology"}

_{Section 6: "The Ultimate Address DB"}

Q&A to review before class 💬