Easy, core SQL data analysis for everyone

SQL and data analysis all in one!
SQL data analysis that even beginners can learn.

"Why learn something you're not going to use?"

The 'Easy to Understand the Essentials' series is a lecture series that focuses on the most useful things, excluding as much as possible things that are not necessary for practical use.

Lecture Planning 📖

• ✔️ This course is for absolute beginners and novices who need SQL analysis .
• ✔️ We teach you how to learn accurately and quickly.
• ✔️ Seen Through this course, you can kill two birds with one stone: learn the SQL language and how to analyze data with SQL .

"Easy SQL Data Analysis for Everyone: Focused on the Essentials" is a course designed for beginners and novices. The instructor, with over a decade of industry experience and core SQL expertise, provides an easy-to-understand introduction to SQL and data analysis. By conducting data analysis based on business data and working with analysis projects, you'll gain hands-on experience. This course is recommended for anyone who needs to learn SQL analysis but has struggled to figure out where to start.

※ The analysis scenario structure is closely related to the book "Everybody's SQL." Therefore, some content may overlap with it. Even if you haven't read the book, you can still learn without any problems, as the course materials and practice data are provided.

• SQL grammar only? No
• Data analysis theory only? No
• Learn how to analyze data using SQL.

Recommended for these people! 📌

I especially recommend this to those who have no choice but to study SQL and data analysis on their own.

SQL beginner

SQL, really
Someone who doesn't know anything

Junior Analyst

SQL analysis
For those who want to get a feel for it

students/examinees

SQL related
Those preparing for certification

beginner developer

SQL basic skills
Those who aim to improve

Oh, are you talking about me?

• I don't know SQL grammar, I don't know what's important in SQL grammar.
• I don't know how to use SQL, I don't know how to analyze data.
• I use SQL but I'm not sure if it's the right way.
• I want to get a feel for SQL data analysis.
• It's a situation where you have to solve everything yourself.

We will clearly solve your concerns.

• You can't learn all the SQL grammar at once. I'll teach you the core grammar like a pair of tongs.
• As we proceed with the analysis project , we create SQL analysis statements.
• We will teach you how to write and read SQL statements .
• We teach you how to derive insights from analysis results and apply them .
• Guide how to learn I'll give it to you.

Only in this lecture
Check out the features ✨

The author of the best-selling SQL introductory book, 'Everybody's SQL', has summarized and added key points to the book.

• Created by a professional with extensive experience in both SQL language and data analysis .
• Since it is aimed at beginners, it is explained in a simple way in beginner's language.
• We will boldly exclude things that are not used frequently and focus on the core .
• We'll show you how to learn on your own, based on the core.
• The lectures proceed according to analysis scenarios , not just rigid grammar, and also cover analysis graphs, etc.
• We provide a short video that summarizes only the core SQL.

How to conduct a lecture

• We start with the very basics, including installing the database and editing tools.
  • ① The assignment is given as an analysis project. → Get a feel for the analysis method.
  • ② Learn grammar appropriate for each project chapter → Learn SQL grammar
  • ③ Solve analysis projects using the grammar you've learned. → Analyze
• Repeat steps ① to ③ to proceed through a total of 6 chapters to derive analysis conclusions and insights.
• We also run campaigns based on the insights we derive.

#Analysis Project: Uncover insights and execute marketing strategies through 'Steak' menu analysis!

Chapters 1 through 6 each involve different analysis tasks based on restaurant business data. Through these analysis projects, students will gain a sense of business and SQL analysis methods.

#SQL Theory Study: Learn only the core SQL grammar with practice queries and textbooks.

We offer a variety of SQL practice queries and data analysis materials (available online). Solve analytical tasks while easily learning the core SQL theories and grammar relevant to each analysis task. You'll also learn how to interpret SQL statements.

Your final
We help you improve your skills. 📜

• You can learn the core SQL grammar.
• You can get a feel for analysis methods using SQL.
• Through analytics projects, you can experience businesses related to data analysis.
• You will be able to interpret and apply SQL.
• You can advance your skills from beginner to advanced level.

What you'll learn 📚

Each chapter provides analysis tasks. Learn the relevant SQL syntax and write SQL analysis statements. You'll interpret the SQL statements and discuss the analysis results.

Chapter 0. Preparation

This course explains the fundamentals of SQL and database theory and provides learning methods. Learn how to install Oracle Express 11g and SQL Developer.

Chapter 1. Basic Statistical Analysis

Learn how to use SQL Developer. You'll learn the most basic SQL statement, SELECT, perform simple analysis, and create box plots in R.

Chapter 2. Comparative Analysis

We will learn the essential functions used in SQL and conduct comparative analysis.

Chapter 3. Monthly Sales Trend Analysis and Product-Specific Sales Analysis

We'll learn about "tables" and "relationships," the core elements of a relational database, and explore ERDs and joins. We'll utilize the techniques we've learned to conduct analysis and create various graphs.

Chapter 4. Day of the Week Analysis and Demographic Analysis

Learn about SQL subqueries and explore date-related SQL. We'll analyze days of the week and demographics.

Chapter 5. Preparing for Marketing Campaign Analysis

Let's organize what we've analyzed so far and develop a hypothesis. We'll learn DDL and DML statements and execute a hypothetical marketing campaign.

Chapter 6. Marketing Campaign Analysis Results

Analyze the results of your marketing campaigns. This allows you to derive insights and organize your analysis.

Frequently Asked Questions
Check it out 💬

Who created this course
Introducing the knowledge sharer ✒️

Data Chef

I'm a lecturer who has dedicated my career to IT and data analysis. Based on IT technology, I've worked on a variety of projects across diverse fields, from CRM to big data and web analytics. I've accumulated extensive data and experience working for large corporations and specialized companies, and I'm distilling this experience into books and lectures.

History

• Author of 'Everyone's SQL', 'Everyone's R Data Analysis', and 'Everyone's Google Analytics 4'
• Working in data analysis/construction at large corporations and specialized companies

Main history

• L Electronics expands GA4 application
• Company A, Google Analytics implementation and analysis
• A cosmetics, CRM operations, data analysis
• I Hotel, Digital Marketing/CRM Manager
• K-Card, H-Card, and Text Mining Analysis Projects
• N Shopping, HR Operation System Development Project
• A Phone, D Computer, E Lux, and H Mart Business Collaboration
• D Electronics, CRM system operation, call center operation, program development

Other ✔️