SQL Survival Kit for Data Beginners

"SQL Survival Kit for Those Stranded on a Database Island"

What is the purpose of the lecture?

It is designed to help learners systematically learn the entire process from the basics of writing queries using SQL to practical application. It is designed to develop the ability to handle data through actual data and practice, and to be able to apply it directly in a practical environment, rather than simply learning theories. Learners will learn how to efficiently analyze data using SQL and derive insights based on data. Furthermore, they will learn a data-based way of thinking, maximize their ability to utilize data, and through this, acquire the expertise to solve business problems or create new values. This process contributes not only to the learner's personal growth, but also to improving their job skills.

• The goal is to learn from the basics to practical application and to acquire the ability to apply it directly to actual work.

• Learn data-driven thinking and develop the ability to handle data efficiently.

What can I learn from this lecture?

You can learn the practical skills required to collect, organize, and analyze data using SQL. It covers a wide range of topics, from writing database queries to data preprocessing and Python linking for big data. Through this course, learners will understand the process of data analysis and acquire the ability to apply it to practice. In particular, it focuses on cultivating the ability to solve problems and create value based on data.

• Learn data collection, organization, and analysis techniques using SQL through various practical examples.

• Learn the basics of handling data using SQL, as well as the ability to define and design data structures.

• It covers a wide range of key database features, including data preprocessing, hierarchies, subqueries, stored procedures, and functions.

In what fields is it mainly used?

It can be utilized in various industries. Database management skills are becoming an essential capability in various fields such as marketing, management consulting, finance, and manufacturing. For example, in the marketing field, it is used to analyze customer data to optimize campaigns, and in the financial field, it is used to manage and analyze large-scale transaction data to establish investment strategies. In the manufacturing industry, it contributes to improving efficiency and optimizing quality management by analyzing production data. It also plays an important role in various fields such as public data analysis and policy establishment and decision support using big data. You can learn practical skills that can be utilized in almost all occupations that require data-driven decision making.

• It is used to handle basic data in various industrial fields such as marketing data analysis, management consulting, financial data processing, and manufacturing production data processing.

• It is also used to analyze public data and big data, and build data-based decision-making systems.

Who is it suitable for?

It is suitable for a variety of learners who are interested in databases and data analysis. It is also suitable for working professionals who want to use SQL in their field work, and it provides an opportunity for students preparing for related certifications and employment to gain practical experience.

The features of this course are as follows:

• Hands-on: Learn practical, real-world skills using MariaDB and public data.

• Various data examples: Covers various public data such as Korean Movie Database, Consumer Price Index, and regional temperature analysis data.

• Lesson Plans at a Glance: Mind map-style lesson plans help students stay more focused on the flow of the course.

This course covers everything from SQL basics to practical applications, and is highly recommended for all learners who want to grow into data experts. Through this course, learners will learn the skills to freely handle SQL using a database called MariaDB and a development tool called HeidiSQL, and acquire data-based problem-solving skills. Through hands-on learning, you can handle real data, develop practical skills, and acquire practical analysis skills that can be used in various industries. This course, which is easy for anyone from beginners to intermediate learners, will be the starting point of data analysis and a solid foundation for you to leap forward as an expert.

After attending the lecture, you will gain an understanding of these contents.

Learning Contents

• It consists of a total of 4 sections and 37 lectures.

Things to note before taking the class