MySQL - Statistics for Data Science & Business Analytics

Focused View

Mahmoud Ali

14:20:53

136 View

1 - Course orientation

1 - Download Course Syllabus and contents.html

2 - What will you get from this course.mp4

04:22

3 - Bookmark and Accessing course slides codes apps and projects.html

4 - How to learn and get most of the course.mp4

06:15

5 - Download Cornell notes and learn how to use it.html

6 - Which part of the course matched to me.html

2 - An Introduction to SQL MySQL Data Science

7 - Available Jobs for data analysis or data science.mp4

04:47

7 - video1-intro.rar

8 - Comparison between SQL Python and R language.mp4

02:29

8 - video2.zip

9 - Understand Why MySQL for Data analysis.mp4

03:56

9 - video3.zip

10 - Learning programming for data analysis is something easy or complex to learn it.mp4

07:12

10 - video4.zip

11 - Highlevel overview about course projects.mp4

10:04

11 - video5.zip

12 - SQL language is the romance language of data.mp4

05:50

12 - video6.zip

13 - Relational databases versus Non relational database.mp4

11:54

13 - relational-databases.zip

14 - Understand What is DBMS.mp4

09:28

14 - dbms.zip

15 - What is after data analysis.mp4

05:21

15 - what-is-after-data-analysis.zip

16 - MySQL advantages and disadvantages.mp4

03:00

16 - pros-and-cons-of-mysql.zip

17 - MySQL installation on windows Machine.mp4

12:21

17 - download mysql version 8023 from this link directly.zip

17 - mysql-installation.zip

18 - install MySQL on MacOSx machine.mp4

07:33

18 - macosx.zip

3 - Your first MySQL Activity

19 - Learn how to Start stop MySQL server using Command Prompt.mp4

05:26

19 - start-stop-mysql-server.zip

20 - Learn how to Import external database to MySQL server.mp4

03:56

20 - video2.rar

4 - App 2 Pele versus Maradona Who was better

21 - Learn how to Create database and tables columns and inserting data.mp4

12:26

21 - video3.rar

22 - Use MySQL query to know which scored goals per game over 50.mp4

07:43

22 - video4.rar

5 - App 3 MySQL data types

23 - Understand data types and the difference between Float and Decimal.mp4

11:25

23 - video5.rar

6 - App 4 Select Statement in MySQL

24 - Understand how select statement works and the order to retrieve data.mp4

08:43

24 - video6.rar

7 - App 5 MySQL alter table

25 - Understand how to add delete rename and modify MySQL tables.mp4

15:34

25 - video7.rar

8 - App 6 primary and foreign key

26 - The idea behind foreign and primary key in MySQL database.mp4

07:53

26 - video8-the-idea-behind-primary-key.zip

27 - Learn how to create relational tables using primary and foreign key.mp4

19:33

27 - video9.rar

9 - App 7 MySQL where clause

28 - Understand MySQL where clause.mp4

03:46

28 - video10.rar

10 - App 8 ORDER BY clause

29 - Sorting table columns Ascending Order or Descending order.mp4

04:35

29 - video11.rar

11 - App 9 MySQL Logical operators AND OR

30 - Understand logical operators in MySQL like AND OR EQUAL NOT EQUAL.mp4

11:01

30 - video12.rar

12 - App 10 IN operator

31 - Learn how to use range of values using MySQL IN operator.mp4

06:54

31 - video13.rar

13 - App 11

32 - Understand Date variable and CAST from number to date.mp4

15:11

32 - video14.rar

14 - App 12 BETWEEN operator

33 - Find payments whose amount is between two values using between operator.mp4

04:03

Exercise Files.zip

15 - App 13 Limit clause

34 - Using limit clause syntax with two arguments.mp4

09:43

34 - video16.rar

16 - App 14 Joins

35 - Use JOIN clause to find ONLY common fruits types.mp4

11:54

35 - video17.rar

17 - App 15 joins

36 - Continue use JOIN clause to find common fruits types.mp4

16:29

36 - video18.rar

18 - MySQL aggregate functions

37 - Understand What is the benefit of Aggregate Functions in data analysis.mp4

16:44

37 - video19.rar

19 - Project 1

38 - What you need before you start this project.html

39 - MySQL Business Case of DVD rental store.mp4

08:47

39 - mahmouddvd.zip

39 - video20.rar

20 - Project 2

40 - Part1 Investigate MySQL DB to help students in debt crisis.mp4

12:16

40 - video21.rar

41 - Part 2 Investigate MySQL DB to help students in debt crisis.mp4

09:27

41 - video22.rar

21 - Project 3

42 - Which State in USA Has The Worst Drivers.mp4

15:19

42 - video23.rar

22 - Bonus 1 Introduction to NOSQL MongoDB

43 - Understand Why Mongo DB in data analytics.mp4

04:49

43 - video1.zip

44 - Understand What is the best language used for MongoDB.mp4

03:02

44 - nosql-language.zip

45 - Advantages and disadvantages of MongoDB.mp4

03:35

45 - advantages-and-disdvanategs.zip

46 - Install Mongodb server on windows machine.mp4

04:33

46 - install-mongo-db-windows.zip

47 - Install MongoDB on MacOSX.mp4

05:50

47 - install-mongo-db-macosx.zip

48 - Learn Write your first MongoDB query using JavaScript.mp4

08:47

48 - video6.rar

23 - Project 4 data analysis project without programming

49 - Project-4.rar

49 - Which state in USA Has The Worst Drivers.mp4

08:05

24 - Project 5 data analysis project without programming

50 - Project-5.rar

50 - Statistical Analysis of the Work of Bob Ross.mp4

14:59

25 - Refresher Data analysis introduction

1 - Is programming for data science easy or hard.html

2 - Be patient for interview questions.html

51 - Refresher part.html

52 - Refresher Is programming for data science easy or hard.mp4

00:49

52 - lesson-1-video-3.zip

53 - Refresher Collection about important questions related to data science.mp4

02:11

54 - Refresher Be patient for interview questions.mp4

01:09

55 - Refresher People are panic from robot jobs.mp4

00:53

26 - Refresher Data Analytics Careers and robot jobs

3 - Robot jobs.html

4 - Data scientist is the sexiest job.html

5 - Robot jobs.html

6 - hire data analysis or data science engineer.html

7 - Learning programming.html

56 - Refresher part.html

57 - Refresher High demand for hiring data analysis engineer.mp4

01:35

57 - careers.zip

27 - Refresher Statistics for data analysis Example about programming and big data

58 - Refresher part.html

59 - Refresher Run your first SQL command without any previous experience.mp4

02:08

59 - lesson3.zip

60 - Refresher Note the difference between SQL and English language.mp4

01:00

61 - Refresher What is big data.mp4

00:44

62 - Refresher Professional answer about what is big data.mp4

01:12

63 - Refresher What is OVERLOADS in a big data.mp4

01:37

64 - Understand 3Vs Volume variety velocity in Big data.html

28 - Refresher What is after data analysis

65 - Refresher What is after data analysis.mp4

03:36

65 - lesson4.zip

66 - Refresher Your data is your treasure.mp4

01:10

29 - Refresher Start Descriptive statistics

67 - Refresher Our strategy to learn practical statistics.mp4

02:04

67 - -0-lesson-1-da.zip

68 - Refresher Four main things in practical statistics.mp4

00:53

30 - Refresher Comparison between inferential and descriptive statistics

69 - Simplified viewpoint about descriptive and inferential statistics.html

70 - Refresher Data before and after descriptive statistics.mp4

03:08

70 - -1-lesson-1types-of-statistics.zip

71 - Refresher Conclusions between inferential and descriptive statistics.mp4

01:25

72 - Refresher Population and sample in inferential statistics.mp4

03:33

31 - Refresher FAQ about descriptive statistics

73 - Refresher What will we learn in descriptive statistics.mp4

02:00

73 - lesson-2-video-3.zip

74 - Refresher Statistics between Lie and trustworthy.mp4

01:06

75 - Refresher Waitress should be friendly or friendlier.mp4

01:48

32 - Refresher Data types

76 - Refresher Introduction about data types.mp4

00:34

76 - lesson-2-video-4-and-5.zip

77 - Refresher the benefit of data types.mp4

01:10

78 - Refresher Categorical data types.mp4

02:13

79 - Refresher Data types continuous vs discrete.mp4

03:03

80 - Refresher Difference between numerical and categorical data.mp4

02:33

81 - Refresher Quizzes and examples about data types.mp4

10:42

82 - Refresher The summary about data types.mp4

01:38

33 - Refresher Center of numerical data

83 - Refresher introduction about data center.mp4

00:52

83 - lesson-2-videos-11-to.zip

84 - Refresher Characteristics of numerical data.mp4

01:59

85 - Refresher Categorical data characteristics considered to be limited.mp4

00:48

86 - Refresher Example about characteristics of categorical data.mp4

01:05

87 - Refresher What are measures of center.mp4

00:44

88 - Refresher Examples of mean.mp4

02:41

89 - Refresher Examples of median.mp4

02:25

90 - Refresher Examples of mode.mp4

03:04

91 - Im confused between mean median and mode.mp4

00:31

34 - Refresher Why center of the data is very important

92 - Refresher introduction about a lot of ways to find center of the data.mp4

00:42

92 - lesson-12-to.zip

93 - Refresher Mode Median and mean in Financial application our life Society.mp4

03:48

94 - Refresher Final review about central tendency.mp4

00:53

35 - Refresher Data dispersion and spread

95 - Refresher basics of data dispersion and spread.mp4

00:49

95 - lesson-13.zip

96 - Refresher Measures of spread.mp4

01:07

97 - Refresher What is range.mp4

00:44

98 - Refresher What is interquartile range.mp4

02:25

99 - Refresher What is 5 number summary.mp4

01:18

100 - Refresher Example about 5 number summary.mp4

07:11

101 - Refresher 5 number summary with range and interquartile range.mp4

02:28

102 - Refresher Remember why we need 5 number summary.mp4

00:16

103 - Refresher Box plot with 5 number summary.mp4

00:49

36 - Refresher Which one is better Standard deviation or range

104 - Refresher Concepts about standard deviation range and 5 number summary.mp4

00:47

105 - Refresher The idea about how to represent your data.mp4

01:46

106 - Refresher Example about using graphs with 5 number summary.mp4

01:27

107 - Refresher Benefits of using box plot with histogram.mp4

04:11

108 - Refresher What is standard deviation.mp4

00:59

109 - Refresher Example about standard deviation.mp4

04:22

110 - Refresher Direct methods to calculate standard deviation.mp4

00:59

111 - Refresher Physical meaning of standard deviation.mp4

02:21

112 - Refresher a tricky question about standard deviation.mp4

06:52

113 - Refresher Example about center of data and standard deviation.mp4

02:07

114 - Refresher Standard deviation with financial analysis.mp4

00:59

115 - Refresher Choose between standard deviation and range to measure data spread.mp4

02:40

37 - Refresher Data shape

116 - Refresher Introduction about data shape.mp4

00:42

116 - lesson-14.zip

117 - Refresher Fast review about what we learned about data aspects.mp4

03:26

118 - Refresher Important questions related to data shape.mp4

00:39

119 - Refresher Symmetric versus skewed distribution.mp4

01:52

120 - Refresher Example about symmetric distribution.mp4

02:25

121 - Refresher What is Gaussian and bell curve distribution.mp4

01:16

122 - Refresher Why normal distribution.mp4

02:05

123 - Refresher Normal versus standard normal distribution.mp4

02:14

124 - Refresher Left and right skewed distribution.mp4

01:15

125 - Refresher Remember what we studied about data shape.mp4

02:00

38 - Refresher Outlier

126 - Refresher Introduction about outlier.mp4

00:59

126 - lesson-15.zip

127 - Refresher Fast review about what we learned.mp4

02:40

128 - Refresher What do we mean by outlier.mp4

02:05

129 - Refresher What is our rule of thump to find outlier.mp4

05:35

130 - Refresher Examples to find outlier.mp4

05:55

131 - Refresher What can i do with outlier.mp4

00:55

132 - Refresher What can i do if i removed outlier.mp4

00:27

133 - Refresher What professional people do with outlier.mp4

01:10

39 - Refresher Normal distribution lesson 1

134 - Refresher Introduction about normal distribution.mp4

00:35

134 - z-at-the-end-lesson-1-normal-distribution.zip

135 - Refresher Four main things in data analysis.mp4

00:51

136 - Refresher Simplified viewpoint about normal distribution.mp4

02:12

137 - Refresher Why normal distribution called Gaussian or bell curve distribution.mp4

01:27

138 - Refresher Why normal distribution is symmetric distribution.mp4

00:48

139 - Refresher Difference between normal distribution and standard normal.mp4

05:12

140 - Refresher What is the benefit of Z table.mp4

09:06

141 - Refresher There is an issue if you do not have standard normal distribution.mp4

01:39

40 - Refresher Normal distribution lesson 2

142 - Refresher Why we need to convert normal to standard normal distribution.mp4

03:03

143 - Refresher Examples about convert normal to standard normal.mp4

12:19

144 - Refresher FAQ related to normal distribution.mp4

01:40

41 - Start Inferential statistics Sampling distribution

145 - Introduction about sampling distribution.mp4

00:48

145 - -01-z-at-the-end-lesson-1-sampling-distribution.zip

146 - The difference between population parameters and sample statistics.mp4

04:14

147 - Why we need sample statistics.mp4

00:42

148 - Find the mean length of all fishes in the sea.mp4

01:38

149 - Solution one Mr Genie will help you find the length of all fishes.mp4

00:30

150 - Why we need Mr Genie.mp4

01:30

151 - What is our final distribution we get it from Mr Genie.mp4

00:26

152 - Mr Genie has power to offer TRUE population parameters not estimation.mp4

00:45

153 - Solution two sampling distribution instead of Mr Genie.mp4

00:44

154 - The idea of sampling distribution.mp4

00:49

42 - Continue Sampling distribution

155 - Introduction about what will we learn.mp4

00:32

155 - -1-Continue-Sampling-distribution.rar

156 - Overview about sampling distribution simulation tool parts.mp4

01:13

157 - What is our final goal from this simulation tool.mp4

00:38

158 - How to take a sample for all fishes in the sea.mp4

01:03

159 - Lets start working with simulation tool.mp4

07:15

160 - Comparison between population parameters and sampling distribution.mp4

02:05

161 - The idea of central limit theorem.mp4

02:44

162 - Summary about population parameters and sampling distribution estimators.mp4

00:48

163 - Example Help fisher man to catch Tuna fishes with length over 1 meter.mp4

02:53

164 - How to find sampling mean in our example.mp4

01:15

43 - Confidence interval and level first lesson

165 - Introduction about the importance of confidence interval.mp4

00:49

165 - -2-Confidence-interval-and-level-first-lesson.rar

166 - What do we mean by confidence.mp4

01:21

167 - Collection of important questions related to Confidence interval.mp4

00:25

168 - Simplified viewpoint about confidence interval and confidence level.mp4

02:56

169 - Difference between 99 and 95 confidence level.mp4

03:44

170 - Important definitions about confidence interval in simulation tool.mp4

00:52

171 - What is sample error.mp4

02:36

172 - Start simulation of 95 confidence interval.mp4

07:26

173 - What is success rate.mp4

00:39

174 - What is failures.mp4

05:07

175 - What is the difference between confidence level and success rate.mp4

00:53

176 - What happens if we changed confidence level from 95 to 99.mp4

02:32

177 - Important tips and questions in this lesson.mp4

00:30

44 - Confidence interval second lesson

178 - Introduction about using confidence interval in real life scenarios.mp4

00:55

178 - -3-Confidence-interval-second-lesson.rar

179 - Make a decision based on High width or low width confidence interval.mp4

04:34

180 - Tradeoff between useless information and high risk in confidence interval.mp4

01:31

181 - What effects the width of confidence interval.mp4

02:26

182 - Effect of standard deviation on confidence interval.mp4

02:41

183 - Relationship between standard error and margin of error in confidence interval.mp4

16:22

184 - Quick Review about what we learned in confidence interval.mp4

04:46

185 - What do we mean by we are lucky or not lucky.mp4

01:48

186 - Review about our answers in confidence interval.mp4

00:49

45 - Students t distribution

187 - Introduction.mp4

00:45

187 - -4-Students-t-distribution.rar

188 - Collection of important questions about t distribution.mp4

00:55

189 - Why did we call t distribution by student.mp4

01:11

190 - What did Mr William tell us about his findings.mp4

01:23

191 - Comparison between t distribution and normal distribution.mp4

01:44

192 - degree of freedom with t distribution.mp4

00:24

193 - What do we mean by degree of freedom.mp4

04:08

194 - The benefit of degree of freedom with t distribution.mp4

02:23

195 - What do you think if DF 30.mp4

00:35

196 - t score and t table.mp4

07:04

197 - Do not use t distribution for higher values of degree of freedom.mp4

01:16

198 - Calculate t value directly using t calculator.mp4

01:05

199 - Remember when to use t or z distribution.mp4

00:38

200 - Summary about confidence interval with t and z distribution.mp4

00:40

46 - Examples about confidence interval

201 - Example 1 Margin of error with confidence interval 99.mp4

00:34

201 - -5-Examples-about-confidence-interval.rar

202 - Repeat the same example with CL 95.mp4

08:40

203 - What is the lower limit point of CL 90.mp4

04:26

204 - Repeat the same example with sample standard deviation.mp4

03:26

205 - Final results with t calculator.mp4

03:44

206 - Premier league football scorers with confidence interval.mp4

02:21

207 - Final results with t calculator.mp4

02:22

208 - Two important equations for Z and T distributions.mp4

01:04

47 - Use Excel to calculate confidence interval

209 - Introduction about using Excel to find confidence interval.mp4

00:40

209 - -6-Use-Excel-to-calculate-confidence-interval.rar

210 - Step 1 Make sure that Data analysis tool pack is installed in your Excel.mp4

01:29

211 - Get all your results about confidence interval from one click only.mp4

02:01

212 - Comparison between manual method results and excel sheet results.mp4

01:52

213 - The end of Confidence interval and what is next.mp4

00:32

48 - Inferential Statistics TAKE YOUR BREATH BEFORE HYPOTHESIS TESTING

214 - 1.zip

214 - Introduction about hypothesis testing.mp4

00:52

215 - Understand H0 and H1.html

216 - Principles in hypothesis testing like H0 H1 and P value.mp4

01:55

217 - P value is the most important thing we should focus on it.mp4

00:35

218 - Mini story part 1 to understand what is P value.mp4

01:25

219 - Complaint against Cola factory owner.mp4

01:31

220 - analysis with H0 and H1 about Cola drink to see if the complaint is a fake.mp4

01:01

221 - Understand how to find H0 and H1 from Cola drinks.mp4

01:54

222 - on what basis Ibrahim will be innocent or guilty.mp4

00:42

223 - What happened to Ibrahim in the court.mp4

00:43

224 - Ibrahim asked his sister Sarah to help him.mp4

01:15

225 - What is Sarahs idea to save her brother Ibrahim.mp4

01:36

226 - First results from Sarah about water percentage in Excel sheet.mp4

01:34

227 - First trial from Sarah is not valid because we need strong evidence.mp4

00:30

228 - Another trial from Sarah using P value to get evidence.mp4

02:24

229 - Alpha and type one error.mp4

03:32

230 - Comparing between Alpha and P value.mp4

01:01

231 - Why Sarah is happy if P value greater than Alpha.mp4

02:11

232 - P value with weak and strong evidence.mp4

02:57

233 - After Sarah is happy remember what is P value.mp4

00:47

234 - Sarah asked her brother about profit share from Cola sales.mp4

01:20

235 - Questions about what we learned from mini story part 1.mp4

03:52

49 - Calculate P value manual method

236 - Introduction and steps to calculate P value.mp4

02:43

236 - -8-Calculate-P-value-manual-method.rar

237 - Step 1 Find H0 and H1.mp4

01:33

238 - Step 2 Find Sample Size SD and mean of sample.mp4

00:53

239 - Fast review about how to get sample mean and SD from Excel file.mp4

02:15

240 - Step 3 Find Degree of freedom.mp4

00:23

241 - Step 4 Choose between t or z distribution.mp4

00:31

242 - Step 5 Calculate t or Z value.mp4

01:56

243 - Step 6 find P value from t calculator or t table.mp4

02:09

244 - Step 7 Make a decision.mp4

02:38

50 - Use Excel to calculate P value

245 - Prepare your excel sheet with sample results.mp4

03:32

245 - -9-Use-Excel-to-calculate-P-value.rar

246 - Write your P value equation in Excel file.mp4

04:48

247 - Make a decision by comparing Alpha and P value.mp4

01:29

248 - Question about one and two tail.mp4

00:32

51 - Mini story part 2 Two tailed t test

8 - t value for one and two tail 95 and 90 confidence interval.html

249 - For the second time Ibrahim asked his sister Sarah to help him.mp4

00:37

249 - -10-Mini-story-part-2-Two-tailed-t-test.rar

250 - One tail versus two tail test.mp4

05:48

251 - The summary about one tail and two tail test.mp4

02:24

252 - Starting Mini story part 2.mp4

00:24

253 - Ibrahim i seeking about increase Cola sales in winter.mp4

00:45

254 - Sarah was surprised when Ibrahim asked her to increase sales in winter.mp4

00:46

255 - Sarah told her brother about offer free coupons for Cola drinks.mp4

00:53

256 - Sarah is using two samples mean t test to prove idea of free cola coupons.mp4

01:20

257 - Important things we should understand it when calculate P value in Excel.mp4

00:45

258 - What is null hypothesis for two samples mean t test.mp4

01:57

259 - What is alternative hypothesis.mp4

01:38

260 - Use Excel file with two samples mean t test.mp4

06:40

261 - P value from t calculator versus P value from Excel.mp4

01:15

262 - Ibrahim does not understand final results from Excel file.mp4

00:31

263 - Examples about what we learned in hypothesis testing.mp4

03:29

264 - Simple practice about t distribution table with different confidence level.mp4

02:44

52 - Understanding two tail test results in Excel

265 - Explain all results from Excel file about two samples mean t test.mp4

05:06

265 - -11-Understanding-two-tail-test-results-in-Excel.rar

266 - Important graph to tell us about our evidence strength.mp4

01:17

267 - Ibrahim is happy now after he his sister explained excel file results.mp4

00:19

268 - Ibrahim give Sarah some money to avoid disputes with her.mp4

01:24

53 - Practical significance and statistical significance

269 - 6-statistics-reliability.zip

269 - Choose between practical significance or statistical significance.mp4

00:49

270 - Statistics is a liar or trustworthy.mp4

03:46

54 - Bonus 2 Machine learning introduction

271 - 1-machine-learning-intro.zip

271 - Gentle introduction about Machine learning.mp4

04:44

272 - 2-yourfirstml-algorithm.zip

272 - Create your first Machine learning method algorithm.mp4

02:36

273 - 3-testing-and-training-data.zip

273 - Understand Machine learning testing and training data set.mp4

06:18

274 - 4-why-we-need-testing-data.zip

274 - Understand Why we need testing data.mp4

00:52

275 - 5-why-we-need-testing-data.zip

275 - Understand machine learning predictions about the future.mp4

01:36

Description

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

What You'll 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 )
Is Normal distribution and t distributions are cousins ?
Projects like Estimation of goals in premier league ( using confidence interval ) , and more .. and more to learn it
What is "double edged sword of statistics" ?
Practical significance versus statistical significance , and more and more to learn it

Who is this for?

People interested to learn programming and SQL for data science

Beginners in programming

Beginners in data science

Beginners in MySQL databases for data science

Anyone needs to learn statistics from beginner to advanced level .

Statistics for data science

Statistics for data analysis

Marketing analyst

AP statistics

beginner in business intelligence

More details

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
Who this course is for:
People interested to learn programming and SQL for data science
Beginners in programming
Beginners in data science
Beginners in MySQL databases for data science
Anyone needs to learn statistics from beginner to advanced level .
Statistics for data science
Statistics for data analysis
Marketing analyst
AP statistics
beginner in business intelligence

User Reviews

Rating

average 0

Total votes0

Focused display

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 UdemyFrom 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!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.