강의

멘토링

로드맵

Data Science

/

Data Analysis

[A Hundred Words are Not as Good as Seeing Once] SQL Practical Guide for Data Analysis (Free Mini Course)

Datalian's SQL practical lecture with over 10,000 cumulative students and rich online/offline lecture experience. How is SQL used in practice? Let's become a data analyst who solves problems using real data from Microsoft's Yammer service.

(4.8) 76 reviews

8,458 learners

SQL
kakao-service

Reviews from Early Learners

What you will learn!

  • Practical Analysis Using SQL

  • Data Analysis Project

  • Data Analyst Portfolio

Seeing is believing! SQL & Data Analysis
Learn more about practical application ✨

SQL for data analysis,
Are you confident in your work?

I learned SQL because I thought it was necessary for data analysis, and I took several analysis classes... 🤔
I learned SQL, but I don't know where or how to use it.
If you're not sure how actual service data analysis is done !


Using SQL
A taste of real-world analysis.

For data analysis capabilities
Learn real-world SQL!

Microsoft Yammer(야머) 로고

Our goal is to show how to apply it to real work .
Utilize and analyze SQL
It's about getting used to it.

Attention, these people! ✅

  • Those who were curious about how to conduct analysis using SQL in actual work
  • Those who want to experience data and projects most similar to actual work
  • Those who are wondering how to build practical data analysis skills

So, you need to learn this. 📖

  • Extracting and processing actual service data using SQL
  • Real-world data analysis using actual service data

How do data analysts analyze data in the real world? This course is for those who have been curious about how to use SQL to analyze real-world service data . To do so, you need to experience data and projects that are as similar to real-world applications as possible .

In this lecture, we'll work through three projects that use data structured identically to Yammer , an enterprise social networking service, to explore data in a way similar to real-world scenarios. If you're interested in learning how analysts actually use SQL in their work, give this lecture a try!


Closest to practical use!

When taking classes
Installing a separate program or
No setup required .

My SQL skills in practice
How much is it?
You can test it.

Through actual service data
Data analysis practice
You can taste it.

Field Data Analyst,
Datarian tells us
Bonus points for valuable analysis tips !


As a mini project
Have fun learning!

Warm-up - SQL Analytics Training
Describes the platform Mode solution for project progress.
Project 1 - Analyzing the Causes of Declining User Engagement
We are conducting a project to analyze the causes of the decline in user engagement in Yammer services.
Project 2 - Search Function Analysis
Analyze the effectiveness of the search function in Yammer services and suggest improvements related to the search function.
Project 3 - A/B Testing
Let's review the results of an A/B test conducted on the Yammer post upload feature. We'll identify errors during the experiment and consider the conditions for conducting accurate testing.

Helpful for learning
I will give you the class materials.

This course is a mini-course based on the Analytics Training provided by Mode. The data and analysis used in all three projects are based on materials provided by Mode.

A summary of the three analysis projects covered in the lecture can be found inthe [Analysis] Project Summary (Text Lecture) .


Expected Questions Q&A 💬

Q. Who will benefit from this lecture?

1) Those who are curious about the work of field analysts
2) Those who know they need to study SQL, but don't know why they need to learn it or how to use it.
3) I recommend this to those who are curious about what data actually accumulates in a company and have no idea what they can do with that data.

Q. I don't know much about SQL, and I'm curious about how to analyze data. Can I learn more?

For those interested in analytics but haven't yet studied SQL, we've separated the SQL-related content into separate lectures within each session, allowing you to skip the SQL portion. We recommend starting by skipping the SQL portion of each session and then completing the SQL portion after you've studied SQL.

Q. Do I need to set up any special settings to take the course?

No, there's no need to set up any special settings or install any programs for data extraction. Instead, please take the course in an environment with a good internet connection. If you'd like to study the entire course, including the SQL section, be sure to register on the Mode website.

Q. Is there anything I need to prepare before taking the class?

For a more accurate understanding of the project, we recommend that you carefully read the original Analytics Training materials provided by Mode before attending the lecture.

Please check before taking the class!

  • This course is based on Analytics Training provided by Mode.
  • Any unauthorized distribution or public posting of class content and materials is strictly prohibited.

With Datarian
SQL series: Seeing once is better than hearing a hundred times.

Datalian SQL Lecture Roadmap 💌

SQL for Data Analysis Series (3 volumes: Theory)
One concept, one problem!
Learn SQL theory from the ground up. (Click)

SQL for Data Analysis Series (5 Volumes: Complete Edition)
From theoretical explanations to additional problem solving,
Make SQL your own. (Click)

Recommended for
these people

Who is this course right for?

  • For those of you who are curious about how SQL is actually used in the field

  • For those who want to understand how this technology is used in practice before learning SQL

  • For those who have learned all the way to advanced SQL and now want to know how to use it

Need to know before starting?

  • Datalian's SQL Advanced Course Level SQL Knowledge (Subqueries, Window Functions Required)

Hello
This is

32,064

Learners

2,773

Reviews

23

Answers

4.9

Rating

37

Courses

실무 경험이 탄탄한 현업 분석가들이 데이터 분석 교육을 기획하고, 직접 강의합니다.

데이터리안에 대해서 더 알아보고 싶다면

👉 https://datarian.io/

Curriculum

All

38 lectures ∙ (4hr 52min)

Published: 
Last updated: 

Reviews

All

76 reviews

4.8

76 reviews

  • jjuna91님의 프로필 이미지
    jjuna91

    Reviews 3

    Average Rating 5.0

    5

    100% enrolled

    It was difficult because I tried it with a real project, but it was good because I learned how to think and solve it.

    • duqrlqkr880452님의 프로필 이미지
      duqrlqkr880452

      Reviews 2

      Average Rating 4.5

      4

      100% enrolled

      It's fun!

      • rlaalstn30551596님의 프로필 이미지
        rlaalstn30551596

        Reviews 1

        Average Rating 5.0

        5

        29% enrolled

        I didn't expect much because it was free, but I was surprised that it really followed the actual process flow and checked it in detail. I'm really grateful that it's a free lecture.

        • hyongsu44님의 프로필 이미지
          hyongsu44

          Reviews 868

          Average Rating 5.0

          5

          100% enrolled

          I listened to the SQL lecture well. It was really helpful because it was related to my major studies. Happy New Year.

          • coen님의 프로필 이미지
            coen

            Reviews 50

            Average Rating 5.0

            5

            5% enrolled

            thank you

            Free

            datarian's other courses

            Check out other courses by the instructor!

            Similar courses

            Explore other courses in the same field!