Skip to content
UdemyData SciencePaid courseAll LevelsCertificate

MySQL - Statistics for Data Science & Business Analytics (Udemy.com)

SQL - MySQL for Data Analytics - Beginners - Statistics for Data Science - MySQL for Data Analysis - with 25 projects

Created by: Mahmoud Ali

Last updated February 2025

icon
What you will learn

  • SQL - MySQL for Data science.
  • Write complex SQL queries across multiple tables.
  • Relational databases versus non relational databases.
  • Learn how to code in SQL
  • Sampling distribution with practical simulation apps and answering of important technical questions.
  • Confidence level and Confidence interval.
  • Distinguish and work with different types of distributions .
  • Inferential and Descriptive statistics with collection of important quizzes and examples .
  • One sample mean t test .
  • Two sample means t test .
  • How to calculate P value using manual and direct method ?
  • What is after data analysis ?
  • Null hypothesis and alternative hypothesis .
  • Understand What is P value ?
  • Data types and Why we need to study data types ?
  • What is Type one error ?
  • Relationship between Type one error and Alpha ( non confident probability )

How it compares

Against the other 461 rated Udemy courses in Data Science on CourseDuck:

  • Rating4.2 out of 5higher than 9% of them
  • Reviews554#224 of 462 by number of reviews
  • Length14.4 hourslonger than 69% of them
  • Last updatedFebruary 2025earlier than 62% of them

icon
Quality Score

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 84 / 100

icon
Course Description

300+ Lectures/Articles lectures include real life practical projects and examples for people need to learn SQL - MySQL  for data science and statistics
Enjoy practice  25 Apps/Projects in SQL - MySQL for data
analytics and learn Statistics  for data science .

This is the Complete 2021 Bootcamp , Two courses in ONE COURSE .

Do you like jobs in MySQL for data science ?
Do you like jobs in Machine learning ?
Do you like jobs in Marketing analyst ?
Do you like jobs in Programming for data science ?
Do you like jobs in Business analysis and business intelligence ?

If the answer is yes , then all of the above needs MySQL and Statistics for data science .


Who prepared this course material ?

This course material is prepared from highly experienced engineers worked in a leader companies like Microsoft , Facebook and google .

After hard working from five months ago we created 300+ Lectures/Articles to cover everything related to SQL - MySQL  & statistics for data science  .     
In no time with simple and easy way you will learn and love  SQL for data science and statistics .
We stress in this course to make it very spontaneous to make all students love SQL and statistics for data science . 


Who's teaching you in this course ?

I'm senior developer and chief data science engineer  . i worked for many projects related to expert systems and artificial intelligence .
Also i worked as Tutor and consultant trainer with a leader international companies located in USA and UK .

I spent over five  months  of hard working to create 300+ Lectures/Articles  in super high quality  to make all students enjoy and love  SQL for data science and statistics.   
I'm sharing a lot of practical experience from my own work with you in this  course .



Why learn MySQL  or SQL ? 

MySQL is a popular database platform for businesses because it is extremely easy to use. It is commonly used in combination with web development and data science . You hear “it’s easy to work with” a lot in relation to computer languages, but MySQL truly is simple.

For instance, someone with little to no knowledge of MySQL can easily establish a database .
Of course, a lot of hosting providers make this process even simpler by handling all the necessary tasks for new website administrators, but it doesn’t detract from the point that MySQL is relatively easy to use.
I could not imagine data science without databases .

What is my final goal after my students enroll in this course ? 

My final goal is to make all students and engineers  love SQL for data science and statistics .
My big challenge in this course is to make it professional course at the same time it should be very easy and simple for all People .
Therefore you will notice that i used a lot of  graphics and imaginary ideas to make you LOVE SQL for data science and statistics


So, what are you waiting for? Click the “Take this course” button, and let’s begin this journey together!


What is course contents ?

  • Starting introduction to data science and data analysis .

  • Understand programming basics for data science 

  • learn SQL - MySQL basics .

  • Write all the SQL joins

  • Create Foreign key and primary key in MySQL databases . 

  • Learn how to start and stop MySQL server .

  • Analyze data using Aggregate Functions .

  • Read and import external CSV files into MySQL database .

  • Export MySQL database table contents into CSV file .
    Awesome Projects and examples like :

    1. How Mr. Genie helped us to find all fishes in the sea ?

    2. Mr. Genie power versus statistics power

    3. The double edged sword of statistics

    4. Help fisherman to catch Tuna using sampling distribution

    5. Ice Cola example with student's t distribution .

    6. Estimation of goals in premier league ( using confidence interval ) .

  • TAKE YOUR BREATH BEFORE HYPOTHESIS TESTING

  • One sample mean t test .

  • Two sample mean t test .

  • Null hypothesis and alternative hypothesis .

  • What is P value ?

  • How to calculate P value using manual and direct method ?

  • Two mini stories for TWO PROJECTS  related to hypothesis testing 

    1. Project one is how Sarah used "one sample mean  t test" for Ice Cola factory  to prove that her brother Ibrahim is innocent ?

    2. Project two how Sarah used "two sample mean t test" for Ice Cola factory to help her brother Ibrahim to increase Ice Cola sales in winter ?

  • ... more and more

  • .... and more and more course contents


#SQL #MySQL #MySQL-for-data-science #SQL-for-Data-science

icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Mahmoud Ali

My name is Aly and i'm very happy that you are reading this!

Professionally, I come from Artificial intelligence world with experience in mobility , medical , retail and automotive .
I learned and was trained by the professional professors in Munich , Germany , then i decided to share what i learned from my professors by creating courses at Udemy

From my courses you will straight away notice how I combine my real-life experience and academic background in Physics and Mathematics to deliver professional step-by-step coaching in the space of Data Science. One of the strongest sides of my teaching style is that I focus on intuitive explanations, so you can be sure that you will truly understand even the most complex topics.

To sum up, I am absolutely and utterly passionate about Data Science and I am looking forward to sharing my passion and knowledge with you!



icon
Reviews

4.2

554 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Ricardo Diaz on 4/4/2023

It's all very basic information, nothing special. Instructor delivery is good but the information is just too basic plus the fact for some reason they are too many videos (1min -2min)... unnecessary

By JKrajnak on 7/29/2020

It seemed much like a run-on-sentence, but the reason for so many examples was explained in the last video lecture as the Instructor's goals was to make learning Statistics enjoyable, and not just deal with textbook cutout problems which would probably make the analysis boring. It was a good general run-through of many statistical topics but not necessarily in order of connected relevant areas.

By Robert Nickson on 6/19/2020

Unpolished diamond. Persevere. Concepts which I have found very difficult to understand despite studying for a while have been explained succinctly. I just had to overlook some of the dodgy dated graphics/presentation. Thank you for the content.

By Katie Neal on 4/21/2020

last project about two sample means is excellent , i was struggled about how and when to use two sample mean test , the last project helped me to do that , highly recommended in statistics for data science

By EVAN Otis on 4/18/2020

It was someone complex for me to understand the difference between P value and type one error , P value is an evidence and after follow up the lessons i got it , great course in statistics for data science

By Hai Elden on 4/11/2020

I tried to understand the difference between sample mean and sampling means , it was complex for me . after i enrolled in this course the instructor used a simile like Mr. Genie to give the idea about sampling distribution in statistics for data science.

By Hemesh Ashok Sawakar on 3/28/2020

It was excellent course and I appreciate the efforts of tutor Mr Mehmud for this well structured course. It was really beneficial to me. I thoroughly enjoyed all videos and easy explanations with real llife fun case studies.

By Smruti Mohapatra on 1/16/2020

This is a very good course. The instructor has worked very hard on the presentation and examples. I will recommend this course to students who are new to statistics and are looking for a quick guide to understand the key concepts in statistics.

By Jon Stopple on 1/16/2020

Way too broad without enough detail or worked out examples for students to do. Wasted my money.

By Jaswinder on 11/28/2019

It was really good, the way was very interesting, there is need of more quiz in this. Instructor proved that language is not a bar for learning, in the beginning it was difficult for me to understand but within few lecture he proved his worth.

By Paul Mark

Statistics for data science lessons are well organized , the instructor managed to offer topics in a simple way to learn statistics for data analysis - great and professional course material for data analysis

By Georoge Donald

Starting from introduction about data analysis and what is after data analysis , then gradually i learn advanced topics about data analysis and statistics for data analysis , very highly recommended for data analysis topics and advanced topics in statistics for data analysis

Showing 12 of 57 reviews