Is SQL too complicated? If you write it yourself and practice, you'll understand it much faster!

Boldly omit complicated theories and concepts, and practice and follow along by writing SQL statements right away!

SQL (Structured Query Language)Silver Build and manage databasesand in the database Extracting the desired data It is a widely used language for queries (Queries). Essential use when viewing data stored in a DBTherefore, if you don't know SQL, it's difficult to use databases in various situations, such as work or personal projects. For example, if you work for a company that uses a database to store customer information, you may have trouble retrieving or updating that information if you don't know SQL. Therefore, now that data literacy is important, it is an essential tool for office workers.

I learn something like this!

— Basic concepts of databases and schemas

— The overall theory and format of SQL

— Securing SQL capabilities through the use of various functions

— Ability to use SQL in practice using AI

Data collection blocked?

Use SQL. it's piercing~

Let's use only the core SQL easily and quickly!

< at Maso CampusSQL that only makes it easy to learn the core> At, you can develop the following competencies.

Learn about concepts you can never avoid if you learn SQL!

We will briefly explain key terms and concepts such as DB, schema, tables, keys, DBMS, and relationships, and learn about the types and licenses of DBML. We will teach you the entire process from download to setup in the most concise and friendly manner so that you can freely install MySQL 8.0 Community Edition, which is an essential tool for SQL practice, when needed.

Let's upload an Excel file to the DB server!

The main purpose of SQL is to freely extract desired data from a database, and after a simple and quick review of theoretical explanations such as creating schemas and tables and entering, deleting, and modifying data individually, follow the process of uploading 3,000 customer information and 25,000 sales data to the DB server, and use actual data for each situation in the same way at any time in practice.

Let's learn the core syntax of SQL and try it out!

It covers the core syntax of SQL for extracting the data I want, selecting it, and applying various conditions. We will tell you only what is essential for the actual work of applying conditions, aggregating, and limiting data, focusing on SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, and LIMIT.

Another SQL statement inside an SQL statement? Let's output complex conditions all at once with subqueries and joins!

We combine multiple tables into one, such as a subquery that puts a query within a query and an inner join that combines multiple data, and output complex conditional statements, and also examines various error situations that everyone commonly makes mistakes at this time, and also examines what points should be kept in mind in practice.

I recommend it to people like this

— People interested in data and data analysis

— Those who want to analyze data with tools other than Excel

— Those who want to thoroughly learn and master the database, which is the foundation of SQL

— Those who want to write their own SQL statements and extract only the data they need

After listening to an SQL course where you can easily learn only the core

< SQL that only makes it easy to learn the core >After listening to the lecture,

You can secure the following competencies.

Understanding key terms and operating principles for proper use of SQL
Ability to upload files to DB and extract data
Ability to uncover insights from large amounts of data
Securing practical skills using various conditions and statistics

We will teach you everything you need in SQL, from definitions and terms of databases to key uses.

Master this course and start using SQL in earnest!

Master this course and become a professional worker!

Course features

By taking this course step by step, you will learn the essential syntax of SQL and have sufficient practical skills to extract and organize desired data from a company database. Also, at the end of this course, I will introduce tips for using artificial intelligence services to better handle SQL so that students can understand more in-depth use of SQL and how to optimize SQL performance to handle big data according to each student's situation.

STEP 1. SQL, Is it much different from Excel?

It's not! SQL can easily and quickly create repetitive tasks in Excel through queries, and since it uses a database even if the amount of data is large, it can quickly extract only the required data. I will teach you the core concepts and operating principles of SQL step by step. If you listen to it, you'll fall in love with the appeal of SQL, which is easier than Excel.

STEP 2. Upload the file to the DB and save only the data I want!

If you want to extract only the data you need from Excel at work or in your daily life, but you're tired or bothersome of the work environment by creating pivot tables and filters every time, try using SQL! You can easily and quickly extract only the data you want with key grammars that you will use over and over again in your lectures.

STEP 3. Use AI when you need to make a query with complicated conditions and can't think of it!

Write a query that lives in Seoul, is a woman in her 30s, is interested in data analysis, and is listening to lectures at Maso Campus! If so, wasn't it overwhelming? If so, ask AI! Chat GPT is hot and hot these days! Have you heard of it? Chat GPT makes it easy to create difficult query phrases.

Learning content

1. Simple understanding of databases

2. Installing MySQL

3. Create schemas and tables and enter data

4. Put data contained in a file into the DB

5. Easily create SQL with AI

Expected Questions Q&A

Q. Is player knowledge of SQL required?

A. That's not true. No prior knowledge of SQL is required, and the instructor is designed so that you can get a sense of SQL from basic DB understanding to SQL installation and practice, so don't worry.

Q. Are there any requirements or requirements to take the course?

A. Since this is a practice-oriented course, it is a good idea to prepare a dual monitor or an extra device that can separate the lecture screen from the practice screen. Also, since exercises are conducted based on Windows OS, we recommend taking courses in a Windows environment.

About knowledge sharers

Please check before taking the course!

- - Since this is a practice-oriented course, it is a good idea to prepare a dual monitor or an extra device that can separate the lecture screen from the practice screen.
  - Since the exercises are conducted based on Windows OS, we recommend taking courses in a Windows environment.
  - Lecture plan and practice files are <0. It is located in the Textbook Download Center> section.