Inflearn brand logo image
Inflearn brand logo image
Inflearn brand logo image
Data Science

/

Data Analysis

Practical SQL Data Analysis: Efficient Data Processing and Generating Insights

From SQL basics to practical analysis! Learn powerful SQL skills to solve business problems by extracting, transforming, and analyzing data.

11 learners are taking this course

  • datascienceone
실습 중심
SQL
MySQL
DBMS/RDBMS

What you will learn!

  • From SQL basics to advanced analysis techniques, learn step-by-step

  • Aggregate Functions and Conditional Filtering

  • JOIN technique for efficiently connecting multiple tables

  • Advanced Queries: Subqueries and CTEs

  • Experience in business data analysis through hands-on projects (Airbnb, E-commerce)

"Do you feel that SQL queries are too difficult and complicated?"
“Do you want to extract and analyze data efficiently?”

In this course, you will learn how to efficiently extract, analyze, and report on data by utilizing various functions of SQL.

Specific outcomes you will achieve from this course:

  • Clean Data Sets : You can use advanced SQL techniques to extract and clean the data you need from your database.

  • Efficient analysis and reporting : Analyze data quickly and accurately and derive business insights by utilizing aggregate functions, joins, subqueries, etc.

  • Project Experience : Apply your SQL query writing and data analysis skills in real-world situations through a capstone project based on a real-world business scenario.

This course goes beyond simple SQL grammar explanations to cover how to effectively process and analyze data in practice. You will learn SQL skills that can be used immediately in real-world situations.


Why should I take this course?

💡 SQL is an essential tool for data analysis and management.
💡 You can immediately apply what you learn to your actual work through practical projects.
💡 This is a comprehensive SQL course that teaches you how to extract, refine, and analyze data all at once.

Become a data analysis expert using SQL right now! You can learn SQL skills that will maximize your work efficiency.

🔥 Features of this course 🔥

1. Balanced composition of 50% theory and 50% practice

2. Learning simulation projects based on real corporate data: e-commerce, Airbnb

3. A step-by-step learning process that systematically builds SQL skills.

4. Provides various practical examples and datasets

I recommend this to these people

Workers who need data extraction and analysis skills


Students and entry-level analysts who want to learn efficient data processing


Beginners interested in data analysis/data science/data engineering

"SQL basics that anyone can easily learn, from advanced queries, data analysis, and practical use!

This course is composed of 50% theory and 50% practice, so you can learn step by step. You can learn how to write SQL queries through various practical examples and learn how to apply them in practice.

After taking the course , you will be able to:

  • Data Extraction and Analysis
    Learn techniques to efficiently extract and analyze data by utilizing various functions of SQL. Learn query writing techniques that can be used immediately in practice, such as JOIN, GROUP BY, and aggregate functions.

  • Report writing and data visualization
    Learn how to process data through SQL queries and create analysis reports and visualizations based on them. Learn techniques to derive key insights from data.

  • Project performance and practical experience
    You can gain practical experience by applying SQL query writing, data analysis, and report writing skills by working on projects based on real business data. This will strengthen the skills required for the job.

#SQL #MySQL #DBMS/RDBMS #ERD #data-modelling #Practical experience

Learn about these things.

Database Design and Management

Learn the basic principles of database design and learn how to manage them efficiently. Understand the structure and rules of RDBMS (Relational Database Management System).

Data extraction (SQL SELECT), filtering, sorting, condition processing

Learn how to extract data using the SQL SELECT statement and process the data by applying filtering and sorting functions such as WHERE, ORDER BY, LIKE, and IN.

How to combine data and use JOIN / Aggregate functions and grouping

Learn how to combine data from multiple tables using the SQL JOIN statement, and learn how to group data and generate statistics using GROUP BY and aggregate functions (SUM, COUNT, AVG, etc.).

Subqueries and Advanced SQL Utilization

Learn how to perform complex data analysis tasks using subqueries and advanced SQL techniques.

Introducing the knowledge sharer (instructor)

Education:

  • Master of Health Informatics (University of Toronto)

  • Bachelor of Science in Medical Physics (Western University)

personal history:

  • Dec 2018 - Present: Ontario Workers Insurance Corporation - Senior Data Analyst

  • Sep 2015 - Mar 2018: CAMH Hospital - Lead Business Intelligence QA Analyst


bailiwick:

  • Business Intelligence / Data Modeling

  • Business Analysis / Data Analysis

  • Data Visualization / Product Development


Personal YouTube Channel:

  • Founder of YouTube Channel Data Science One


Things to note before attending the lecture

💻 Class environment information

  • Operating System and Version (OS) : Windows 10 or later, macOS

  • Tools used : MySQL (MySQL Workbench)

  • PC specifications : Minimum performance computer capable of running SQL

  • Target Audience : The course is structured so that even those with no programming experience can follow along, but you will learn more smoothly if you have an understanding of basic table structures.

Learning Materials

  • Download Materials : All materials are provided in the [Section 0. Download Lecture Package] for practice materials.

  • Practical examples and datasets : Provides sample datasets for various data analysis practices.

  • Template : SQL query practice examples, capstone project template

  • Solution: SQL query practice examples, capstone project model answers


Player Knowledge and Notes

  • Install MySQL Server and Workbench :


    You can install the community version of MySQL from the Oracle website (it's free).

  • Understanding SQL Basics: Before taking the SQL course, it is helpful to have an understanding of the basic concepts of databases, but it is not required. A basic knowledge of what a database is, table structure, data relationships, etc. is useful.


  • Understanding SQL Basic Grammar: If you understand basic SQL grammar (SYNTAX), you can proceed with the class more effectively. For example, it would be good to understand the use of basic SQL queries such as SELECT, INSERT, UPDATE, DELETE, etc.

  • Unauthorized distribution of lecture materials is prohibited: The materials in this lecture are copyrighted, so please be careful not to distribute them without permission.

  • Regarding video and audio quality : Some videos have noise. Please take note before taking the class.

Recommended for
these people

Who is this course right for?

  • Data analysis beginners

  • Office workers/students wanting to learn SQL but unsure where to start

  • Analyst who wants to manage business data more efficiently

  • A person who wants to improve data analysis skills while preparing for a career change

Need to know before starting?

  • None, structured for SQL beginners to follow

  • Understanding Basic Data Structures and Tables

Hello
This is

77

Learners

8

Reviews

5

Answers

3.9

Rating

4

Courses

데이터싸이언스원 | Taesun Yoo

링크딘 프로필 강사소개 [클릭]

주요 경력:

  • 온타리오주 근로자 보험 공단 (WSIB) 시니어 어드바이저 (1년)

  • 온타리오주 근로자 보험 공단 (WSIB) 시니어 데이터 분석가 (경력 5년)


학력:

  • 토론토 대학교: 보건 정보학 석사

  • 웨스턴 대학교: 의학 물리학 학사


전문 분야:

Data Analytics/Data Modeling/Business Analysis

Business Intelligence/Data Visualization/Product Development (Power BI)


기타: 데이터싸이언스원 유튜브 채널 [클릭]

  • 데이터 분석가로 취업에 도움이 되는 팁, 짧은 데이터 분석 포트폴리오, 유데미 코스 프로모션 등을 목적으로 강의를 업로드하고 있습니다!


10년 이상의 경력과 노하우를 바탕으로, 북미에서 데이터 분석가로 취업을 원하시는 분들을 위해 기술을 갈고 닦을 수 있게 강의를 만들고 있습니다. 기초부터 실제 기업에서 사용하는 응용 문제(Use Cases)까지 다루고 있습니다.

Curriculum

All

77 lectures ∙ (12hr 58min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

Limited time deal ends in 7 days

$36.30

23%

$47.30

datascienceone's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!