MySQL – Statistics for Data Science & Business Analytics

Via Udemy

Udemy based on 553 ratings

Likes

Overview

SQL - My SQL for Data Analytics - Beginners - Statistics for Data Science - My SQL for Data Analysis - with 25 projects What you'll learn: SQL - My SQL for Data science. Write complex SQL queries across multiple tables. Relational databases versus non relational databases. Learn how to code in SQLSampling 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...

Syllabus

Course orientation
An Introduction to SQL - MySQL - Data Science
Your first MySQL Activity
App 2 ( Pele versus Maradona ) Who was better?
App 3 ( MySQL data types )
App 4 ( Select Statement in MySQL )
App 5 ( MySQL alter table )
App 6 ( primary and foreign key )
App 7 ( MySQL where clause )
App 8 ( ORDER BY clause )
App 9 (MySQL Logical operators "AND" ,"OR" )
App 10 ( IN operator )
App 11
App 12 ( BETWEEN operator )
App 13 ( Limit clause )
App 14 ( Joins )
App 15 ( joins )
MySQL aggregate functions
Project 1
Project 2
Project 3
Bonus 1 : Introduction to NOSQL ( MongoDB )
Project 4: data analysis project without programming
Project 5: data analysis project without programming
Refresher : Data analysis introduction
Refresher : Data Analytics - Careers and robot jobs
Refresher : Statistics for data analysis -Example about programming and big data
Refresher : What is after data analysis ?
Refresher : Start Descriptive statistics
Refresher : Comparison between inferential and descriptive statistics
Refresher : FAQ about descriptive statistics
Refresher: Data types
Refresher: Center of numerical data
Refresher: Why center of the data is very important ?
Refresher: Data dispersion and spread
Refresher: Which one is better ? Standard deviation or range ?
Refresher: Data shape
Refresher: Outlier
Refresher: Normal distribution lesson 1
Refresher: Normal distribution lesson 2
Start Inferential statistics ( Sampling distribution )
Continue Sampling distribution
Confidence interval and level first lesson
Confidence interval second lesson
Student's t distribution
Examples about confidence interval
Use Excel to calculate confidence interval
Inferential Statistics : TAKE YOUR BREATH BEFORE HYPOTHESIS TESTING
Calculate P value manual method
Use Excel to calculate P value
Mini story part 2 ( Two tailed t test )
Understanding two tail test results in Excel
Practical significance and statistical significance
Bonus 2 ( Machine learning introduction )