inflearn logo
inflearn logo

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

Level Beginner

Course period Unlimited

SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
SQL
SQL
MySQL
MySQL
DBMS/RDBMS
DBMS/RDBMS
날개 달린 동전

Recommend Course to grow and earn commission!

날개 달린 동전

Marketing Partners

Recommend Course to grow and earn commission!

What you will gain after the course

  • 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 DataScienceOne

83

Learners

10

Reviews

5

Answers

4.1

Rating

4

Courses

Data Science One | Taesun Yoo

LinkedIn Profile Instructor Introduction [Click]

Key Experience:

  • Senior Advisor at the Workplace Safety and Insurance Board (WSIB) of Ontario (1 year)

  • Workplace Safety and Insurance Board (WSIB) Senior Data Analyst (5 years of experience)


Education:

  • University of Toronto: Master of Health Informatics

  • Western University: Bachelor of Medical Physics


Areas of Expertise:

Data Analytics/Data Modeling/Business Analysis

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


Others: Data Science One YouTube Channel [Click]

  • I am uploading lectures for the purpose of sharing tips for getting hired as a data analyst, short data analysis portfolios, and Udemy course promotions!


Based on over 10 years of experience and know-how, I create courses to help those aspiring to become data analysts in North America sharpen their skills. My content covers everything from the basics to real-world use cases used in actual companies.

More

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!

DataScienceOne's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

$47.30