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
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
Quality Score
Overall Score : 84 / 100
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 :How Mr. Genie helped us to find all fishes in the sea ?
Mr. Genie power versus statistics power
The double edged sword of statistics
Help fisherman to catch Tuna using sampling distribution
Ice Cola example with student's t distribution .
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
Project one is how Sarah used "one sample mean t test" for Ice Cola factory to prove that her brother Ibrahim is innocent ?
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
Instructor Details
- 4.2 Rating
554 Reviews
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!
Reviews
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




