MySQL – Statistics for Data Science & Business Analytics

سرفصل های دوره

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

1 - Course orientation

1 - Download Course Syllabus and contents.html

2 - What will you get from this course

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

4 - How to learn and get most of the course

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

7 - video1-intro.rar

8 - Comparison between SQL Python and R language

8 - video2.zip

9 - Understand Why MySQL for Data analysis

9 - video3.zip

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

10 - video4.zip

11 - Highlevel overview about course projects

11 - video5.zip

12 - SQL language is the romance language of data

12 - video6.zip

13 - Relational databases versus Non relational database

13 - relational-databases.zip

14 - Understand What is DBMS

14 - dbms.zip

15 - What is after data analysis

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

16 - MySQL advantages and disadvantages

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

17 - MySQL installation on windows Machine

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

17 - mysql-installation.zip

18 - install MySQL on MacOSx machine

18 - macosx.zip

3 - Your first MySQL Activity

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

19 - start-stop-mysql-server.zip

20 - Learn how to Import external database to MySQL server

20 - video2.rar

4 - App 2 Pele versus Maradona Who was better

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

21 - video3.rar

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

22 - video4.rar

5 - App 3 MySQL data types

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

23 - video5.rar

6 - App 4 Select Statement in MySQL

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

24 - video6.rar

7 - App 5 MySQL alter table

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

25 - video7.rar

8 - App 6 primary and foreign key

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

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

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

27 - video9.rar

9 - App 7 MySQL where clause

28 - Understand MySQL where clause

28 - video10.rar

10 - App 8 ORDER BY clause

29 - Sorting table columns Ascending Order or Descending order

29 - video11.rar

11 - App 9 MySQL Logical operators AND OR

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

30 - video12.rar

12 - App 10 IN operator

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

31 - video13.rar

13 - App 11

32 - Understand Date variable and CAST from number to date

32 - video14.rar

14 - App 12 BETWEEN operator

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

Exercise Files.zip

15 - App 13 Limit clause

34 - Using limit clause syntax with two arguments

34 - video16.rar

16 - App 14 Joins

35 - Use JOIN clause to find ONLY common fruits types

35 - video17.rar

17 - App 15 joins

36 - Continue use JOIN clause to find common fruits types

36 - video18.rar

18 - MySQL aggregate functions

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

37 - video19.rar

19 - Project 1

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

39 - MySQL Business Case of DVD rental store

39 - mahmouddvd.zip

39 - video20.rar

20 - Project 2

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

40 - video21.rar

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

41 - video22.rar

21 - Project 3

42 - Which State in USA Has The Worst Drivers

42 - video23.rar

22 - Bonus 1 Introduction to NOSQL MongoDB

43 - Understand Why Mongo DB in data analytics

43 - video1.zip

44 - Understand What is the best language used for MongoDB

44 - nosql-language.zip

45 - Advantages and disadvantages of MongoDB

45 - advantages-and-disdvanategs.zip

46 - Install Mongodb server on windows machine

46 - install-mongo-db-windows.zip

47 - Install MongoDB on MacOSX

47 - install-mongo-db-macosx.zip

48 - Learn Write your first MongoDB query using JavaScript

48 - video6.rar

23 - Project 4 data analysis project without programming

49 - Project-4.rar

49 - Which state in USA Has The Worst Drivers

24 - Project 5 data analysis project without programming

50 - Project-5.rar

50 - Statistical Analysis of the Work of Bob Ross

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

52 - lesson-1-video-3.zip

53 - Refresher Collection about important questions related to data science

54 - Refresher Be patient for interview questions

55 - Refresher People are panic from robot jobs

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

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

59 - lesson3.zip

60 - Refresher Note the difference between SQL and English language

61 - Refresher What is big data

62 - Refresher Professional answer about what is big data

63 - Refresher What is OVERLOADS in a big data

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

28 - Refresher What is after data analysis

65 - Refresher What is after data analysis

65 - lesson4.zip

66 - Refresher Your data is your treasure

29 - Refresher Start Descriptive statistics

67 - Refresher Our strategy to learn practical statistics

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

68 - Refresher Four main things in practical statistics

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

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

71 - Refresher Conclusions between inferential and descriptive statistics

72 - Refresher Population and sample in inferential statistics

31 - Refresher FAQ about descriptive statistics

73 - Refresher What will we learn in descriptive statistics

73 - lesson-2-video-3.zip

74 - Refresher Statistics between Lie and trustworthy

75 - Refresher Waitress should be friendly or friendlier

32 - Refresher Data types

76 - Refresher Introduction about data types

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

77 - Refresher the benefit of data types

78 - Refresher Categorical data types

79 - Refresher Data types continuous vs discrete

80 - Refresher Difference between numerical and categorical data

81 - Refresher Quizzes and examples about data types

82 - Refresher The summary about data types

33 - Refresher Center of numerical data

83 - Refresher introduction about data center

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

84 - Refresher Characteristics of numerical data

85 - Refresher Categorical data characteristics considered to be limited

86 - Refresher Example about characteristics of categorical data

87 - Refresher What are measures of center

88 - Refresher Examples of mean

89 - Refresher Examples of median

90 - Refresher Examples of mode

91 - Im confused between mean median and mode

34 - Refresher Why center of the data is very important

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

92 - lesson-12-to.zip

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

94 - Refresher Final review about central tendency

35 - Refresher Data dispersion and spread

95 - Refresher basics of data dispersion and spread

95 - lesson-13.zip

96 - Refresher Measures of spread

97 - Refresher What is range

98 - Refresher What is interquartile range

99 - Refresher What is 5 number summary

100 - Refresher Example about 5 number summary

101 - Refresher 5 number summary with range and interquartile range

102 - Refresher Remember why we need 5 number summary

103 - Refresher Box plot with 5 number summary

36 - Refresher Which one is better Standard deviation or range

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

105 - Refresher The idea about how to represent your data

106 - Refresher Example about using graphs with 5 number summary

107 - Refresher Benefits of using box plot with histogram

108 - Refresher What is standard deviation

109 - Refresher Example about standard deviation

110 - Refresher Direct methods to calculate standard deviation

111 - Refresher Physical meaning of standard deviation

112 - Refresher a tricky question about standard deviation

113 - Refresher Example about center of data and standard deviation

114 - Refresher Standard deviation with financial analysis

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

37 - Refresher Data shape

116 - Refresher Introduction about data shape

116 - lesson-14.zip

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

118 - Refresher Important questions related to data shape

119 - Refresher Symmetric versus skewed distribution

120 - Refresher Example about symmetric distribution

121 - Refresher What is Gaussian and bell curve distribution

122 - Refresher Why normal distribution

123 - Refresher Normal versus standard normal distribution

124 - Refresher Left and right skewed distribution

125 - Refresher Remember what we studied about data shape

38 - Refresher Outlier

126 - Refresher Introduction about outlier

126 - lesson-15.zip

127 - Refresher Fast review about what we learned

128 - Refresher What do we mean by outlier

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

130 - Refresher Examples to find outlier

131 - Refresher What can i do with outlier

132 - Refresher What can i do if i removed outlier

133 - Refresher What professional people do with outlier

39 - Refresher Normal distribution lesson 1

134 - Refresher Introduction about normal distribution

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

135 - Refresher Four main things in data analysis

136 - Refresher Simplified viewpoint about normal distribution

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

138 - Refresher Why normal distribution is symmetric distribution

139 - Refresher Difference between normal distribution and standard normal

140 - Refresher What is the benefit of Z table

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

40 - Refresher Normal distribution lesson 2

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

143 - Refresher Examples about convert normal to standard normal

144 - Refresher FAQ related to normal distribution

41 - Start Inferential statistics Sampling distribution

145 - Introduction about sampling distribution

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

146 - The difference between population parameters and sample statistics

147 - Why we need sample statistics

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

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

150 - Why we need Mr Genie

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

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

153 - Solution two sampling distribution instead of Mr Genie

154 - The idea of sampling distribution

42 - Continue Sampling distribution

155 - Introduction about what will we learn

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

156 - Overview about sampling distribution simulation tool parts

157 - What is our final goal from this simulation tool

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

159 - Lets start working with simulation tool

160 - Comparison between population parameters and sampling distribution

161 - The idea of central limit theorem

162 - Summary about population parameters and sampling distribution estimators

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

164 - How to find sampling mean in our example

43 - Confidence interval and level first lesson

165 - Introduction about the importance of confidence interval

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

166 - What do we mean by confidence

167 - Collection of important questions related to Confidence interval

168 - Simplified viewpoint about confidence interval and confidence level

169 - Difference between 99 and 95 confidence level

170 - Important definitions about confidence interval in simulation tool

171 - What is sample error

172 - Start simulation of 95 confidence interval

173 - What is success rate

174 - What is failures

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

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

177 - Important tips and questions in this lesson

44 - Confidence interval second lesson

178 - Introduction about using confidence interval in real life scenarios

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

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

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

181 - What effects the width of confidence interval

182 - Effect of standard deviation on confidence interval

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

184 - Quick Review about what we learned in confidence interval

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

186 - Review about our answers in confidence interval

45 - Students t distribution

187 - Introduction

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

188 - Collection of important questions about t distribution

189 - Why did we call t distribution by student

190 - What did Mr William tell us about his findings

191 - Comparison between t distribution and normal distribution

192 - degree of freedom with t distribution

193 - What do we mean by degree of freedom

194 - The benefit of degree of freedom with t distribution

195 - What do you think if DF 30

196 - t score and t table

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

198 - Calculate t value directly using t calculator

199 - Remember when to use t or z distribution

200 - Summary about confidence interval with t and z distribution

46 - Examples about confidence interval

201 - Example 1 Margin of error with confidence interval 99

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

202 - Repeat the same example with CL 95

203 - What is the lower limit point of CL 90

204 - Repeat the same example with sample standard deviation

205 - Final results with t calculator

206 - Premier league football scorers with confidence interval

207 - Final results with t calculator

208 - Two important equations for Z and T distributions

47 - Use Excel to calculate confidence interval

209 - Introduction about using Excel to find confidence interval

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

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

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

212 - Comparison between manual method results and excel sheet results

213 - The end of Confidence interval and what is next

48 - Inferential Statistics TAKE YOUR BREATH BEFORE HYPOTHESIS TESTING

214 - 1.zip

214 - Introduction about hypothesis testing

215 - Understand H0 and H1.html

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

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

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

219 - Complaint against Cola factory owner

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

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

222 - on what basis Ibrahim will be innocent or guilty

223 - What happened to Ibrahim in the court

224 - Ibrahim asked his sister Sarah to help him

225 - What is Sarahs idea to save her brother Ibrahim

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

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

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

229 - Alpha and type one error

230 - Comparing between Alpha and P value

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

232 - P value with weak and strong evidence

233 - After Sarah is happy remember what is P value

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

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

49 - Calculate P value manual method

236 - Introduction and steps to calculate P value

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

237 - Step 1 Find H0 and H1

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

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

240 - Step 3 Find Degree of freedom

241 - Step 4 Choose between t or z distribution

242 - Step 5 Calculate t or Z value

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

244 - Step 7 Make a decision

50 - Use Excel to calculate P value

245 - Prepare your excel sheet with sample results

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

246 - Write your P value equation in Excel file

247 - Make a decision by comparing Alpha and P value

248 - Question about one and two tail

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

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

250 - One tail versus two tail test

251 - The summary about one tail and two tail test

252 - Starting Mini story part 2

253 - Ibrahim i seeking about increase Cola sales in winter

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

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

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

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

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

259 - What is alternative hypothesis

260 - Use Excel file with two samples mean t test

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

262 - Ibrahim does not understand final results from Excel file

263 - Examples about what we learned in hypothesis testing

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

52 - Understanding two tail test results in Excel

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

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

266 - Important graph to tell us about our evidence strength

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

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

53 - Practical significance and statistical significance

269 - 6-statistics-reliability.zip

269 - Choose between practical significance or statistical significance

270 - Statistics is a liar or trustworthy

54 - Bonus 2 Machine learning introduction

271 - 1-machine-learning-intro.zip

271 - Gentle introduction about Machine learning

272 - 2-yourfirstml-algorithm.zip

272 - Create your first Machine learning method algorithm

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

273 - Understand Machine learning testing and training data set

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

274 - Understand Why we need testing data

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

275 - Understand machine learning predictions about the future

53,700 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy-Training