![[改訂版] Python機械学習完全ガイド강의 썸네일](https://cdn.inflearn.com/public/courses/324238/cover/7e380aa0-48ba-4ee7-a6b2-8da7900568d6/324238-eng.png?w=420)
[改訂版] Python機械学習完全ガイド
dooleyz3525
理論中心の機械学習講座から脱却し、機械学習の核心的な概念を簡単に理解できるだけでなく、実践的な機械学習アプリケーションの実装能力を身につけることができます。
초급
Python, Machine Learning(ML), Statistics
By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.
1,580 learners

Practical service analysis cases such as sales, order, and web log analysis
Understand key metrics for analysis such as RFM, DAU/MAU, churn rate, retention rate, and conversion funnel, and implement them in SQL.
Utilization and practical application techniques of Join, Group by, and Window functions
Ability to freely derive desired analysis results through SQL
Strengthening core SQL data analysis capabilities based on practical data similar to actual work
Chart visualization of analysis data
Learn SQL with practical data analysis!
You can become a leading data expert 🏃♂️
The demand for data professionals with both exceptional SQL skills and a deep understanding of company operations and services is growing. Therefore, for data analysts, data scientists, analytics developers, and data engineers , possessing superior SQL skills and the ability to derive and support analytical results that can improve products and services is a crucial competitive advantage.
SQL skills should be developed through solving challenging problems in real-world situations. However, the SQL I've encountered in lectures and books so far has been quite different from the SQL used in real-world situations.
This course is filled with theoretical and practical SQL queries used in real-world analytics , something you won't find in existing lectures or books. Furthermore, it covers domain-specific topics like sales and order analysis, as well as various analytical metrics utilized in Google Analytics and growth hacking, all implemented using sophisticated SQL. This approach aims to simultaneously improve both analytical and SQL skills .
By the end of this course, which implements many analytical indicators used in actual work using SQL, you will become a SQL expert who can freely derive the desired analysis results.
Additionally, the various analysis cases covered in this course will help you understand how to design metrics and conduct analyses to drive business and service growth.
Unfortunately, this course is intended for those who have taken the course ' Data Analysis SQL Fundamentals ' .
If you have practical experience with SQL but have not taken the Data Analysis SQL Fundamentals course, please review the course curriculum and be sure to refer to the ' Course Introduction ' video in Section 0 and the ' Course Selection Guide for Those Who Have Not Taken Data Analysis SQL Fundamentals ' video to determine if the course is suitable for your skills before deciding to take the course.
We would like to inform you in advance that you may have difficulty understanding the contents of this lecture if you have not taken ' Data Analysis SQL Fundamentals '.
Explanation of different types of key analytical indicators +
A hands-on exercise to implement analytical metrics using SQL queries.
We'll cover key metrics for various types of sales analysis, cross-selling, order analysis like RFM, and more, as well as DAU/WAU/MAU, stickiness, channel analysis, entry/exit page analysis, bounce rate, retention rate, and conversion funnel analysis, all of which are well-utilized in Google Analytics and growth hacking.
Difficult SQL exercises based on real-world datasets:
We'll help you improve your SQL skills to the max!
Instead of toy data, you'll implement challenging SQL on a Google Analytics data set for practice. To actively improve implementation skills, most of the course is structured around live coding . By the end of the course, you'll become a SQL expert, capable of freely deriving the desired analysis results.
Detailed and thorough explanation of complex logic
To make complex and lengthy SQL queries easier to understand, we'll break down each processing logic step by step, using detailed diagrams and charts. Through this course, you'll gain the ability to understand and apply even the most complex SQL queries step by step.
Practice implementing chart visualizations to aid intuitive understanding
You can visualize the analyzed SQL results in charts to intuitively understand the analysis results. You'll also learn how to visualize the analysis results using charts to communicate them more effectively. (The visualization code is implemented using Python's Plotly.)
PostgreSQL is used as the practice environment DBMS, and DBeaver is used as the SQL editor.
PostgreSQL is a free, open-source DBMS that boasts stability, performance, and, most importantly, rich SQL support. It complies with the ANSI SQL standard and offers a wide range of SQL functions and analytical capabilities, making it widely used not only online but also as an analytical DBMS.
DBeaver Community Edition is free, but it offers superior features, faster performance, and greater stability than most commercial SQL editors. DBeaver supports various DBMSs, including PostgreSQL, MySQL, and Oracle.
Additionally, I use Jupyter Notebook and Plotly for chart visualization.
Although the video was created based on a Windows environment, it can also be performed without any problems in a Mac environment.
📢 Instructions for downloading lecture materials
Who is this course right for?
People who perform analysis tasks using SQL
Those who want to experience various practical data analysis cases
Anyone who wants to greatly improve their SQL skills
Data Scientists and Data Analysts Leveraging SQL
Data engineers who need to perform data processing/extraction/refinement based on SQL to create tables for analysis or marts
Need to know before starting?
Data Analysis SQL Fundamentals lecture understanding required
26,945
Learners
1,369
Reviews
4,011
Answers
4.9
Rating
14
Courses
(전) 엔코아 컨설팅
(전) 한국 오라클
AI 프리랜서 컨설턴트
파이썬 머신러닝 완벽 가이드 저자
All
91 lectures ∙ (15hr 10min)
Course Materials:
All
44 reviews
5.0
44 reviews
Reviews 27
∙
Average Rating 4.9
5
尊敬します。ありがとうございます。大好きです。私のランソンシューティングゲームです。
良い評価でしばらく気分が良くなりました。ありがとうございます。 。
Reviews 1
∙
Average Rating 5.0
5
本当に最高のSQLデータ分析の講義の一つと断言できそうです。 基本的なSQL文法を学びましたが、何か曖昧なSQL実力を様々な実践事例を通じて確実に向上させたい方に強力強力おすすめです。 講師様のすばらしい講義力と非常に充実した講義の内容のおかげでSQLについて新たに目を覚ましたような気持ちであり、講義を聞きながら実習も着実に並行していれば無条件実力が向上するしかないほどクオリティの高い講義です。 また、講義の中で気になる部分についても親切にお答えいただき、倍増して良かったです。本当におすすめです。ありがとうございます。
SQLの強力さに新たに目を覚ましたなんて私も大きなやりがいを感じます。すばらしい受講に感謝します。
Reviews 5
∙
Average Rating 5.0
Reviews 2
∙
Average Rating 5.0
Reviews 30
∙
Average Rating 5.0
5
昨年この時、データエンジニアの新入社に入社 講師様のSQLファンデーション+データ分析講義を両方見たいという覇気で同時に購入した一人です '私はこちらの分野に才能がないのか。と言い、SQLファンデーションだけを復習し、イリチュイとジョリチで1年が過ぎて少し慣れてきたか昨日から講師のsqlデータ分析講義を始めました 移動平均だから加重平均だから… 無制限だから本当に嬉しいです。.ㅎㅎ 他のデータ分析SQLの講義は見られませんでしたが、その講義も最も簡単に説明してくれたと信じています。 ゆっくりと着実に頑張ります。 一つの願いなら 売上のようなビジネス会計、統計すべてが見慣れているので、BIアナリストが望む方向にETLしてデータを積み重ねるにも大きすぎる困難がありますねㅎㅎ 誰でも見ることができるsqlファンデーションレベルほどのように会計、統計学、工学数学などが出てくればとても幸せそうです こんな質の良い講義を低い値にご提供いただきありがとうございますいつも応援します!
ああ、長文の受講坪以上ありがとうございます。着実にこの講義の練習を繰り返し続けてみると、どこでも認められるSQL分析の専門家になることができます。
$68.20
Check out other courses by the instructor!
Explore other courses in the same field!