[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.
This course is prepared for Intermediate 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 and how to use it.
If you are 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!
Our goal is to show how to apply it to real work .
Utilize and analyze SQL
It's a matter of getting used to it.
Attention these people! ✅
- Those who were curious about how to conduct analysis using SQL in actual work
- For those who want to experience data and projects most similar to actual work
- For those who are wondering how to build practical data analysis capabilities
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 real-world situations? This lecture is for those who are curious about how to use SQL to analyze real-world service data . In order to do so, you need to experience data and projects that are most similar to actual work .
In this lecture, we will work on three projects that allow you to check data in a similar way to the actual work using data that has the same structure as Yammer , a corporate social network service. If you want to know how analysts actually use SQL in their work, try this lecture!
Closest to practical use!
To take a class
Install 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,
Datalian tells you
Bonus points for the juicy analysis tips !
As a mini project
Have fun learning!
Describes the platform Mode solution for project progress.
We are conducting a project to analyze the causes of the decline in user engagement of Yammer services.
Analyze the effectiveness of the search function in Yammer services and suggest improvements related to the search function.
Let's check the results of the A/B test conducted on the Yammer service's post upload function. We will check for errors during the experiment and think about the conditions for conducting accurate tests.
Helpful for learning
I will give you the class materials.
This course is a mini-course based on Analytics Training provided by Mode. The data and analysis process used in the three projects are all based on materials provided by Mode.
A summary of the three analysis projects conducted 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 that 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 accumulated in a company looks like 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 do data analysis. Can I ask you?
For those who are interested in analytics but have not yet studied SQL, we have separated the SQL-related content into separate lectures within the section so that you can skip the SQL part of each session and listen to it. I recommend that you first skip the SQL part of each session and then study SQL and then look at the SQL part together.
Q. Do I need to set up a separate environment to take the course?
No, there is no need to set up a separate environment or install a program for data extraction. Instead, please take the course in an environment with a good internet connection, and if you want to study all of the SQL parts, be sure to register as a member on the Mode site.
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 Datalian
SQL series: Seeing once is better than hearing a hundred times.
Datalian SQL Lecture Roadmap 💌
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)
30,096
Students
2,616
Reviews
23
Answers
4.9
Rating
39
Courses
Co-instructor
