Section 1 : Part 1 Introduction

lecture 1 About Certification Pdf

Section 2 : Intro to Data and Data Science The Different Data Science Fi

lecture 2 Why Are There So Many Business and Data Science Bu 5:22
lecture 3 Analysis vs Analytics 3:51
lecture 4 Intro to Business Analytics Data Analytics andData 8:26
lecture 5 Adding Business Intelligence (BI), Machine Learnin 9:31
lecture 6 An Overview of our Data Science Infographic 4:3

Section 3 : Intro to Data and Data Science The Relationship between Diff

lecture 7 When are Traditional data, Big Data, BI, Tradition 7:19

Section 4 : Intro to Data and Data Science What is the Purpose of each D

lecture 8 Why do we Need each of these Disciplines 4:45

Section 5 : Intro to Data and Data Science Common Data Science Technique

lecture 9 Traditional Data- Techniques 8:14
lecture 10 Traditional Data- Real-life Examples 1:45
lecture 11 Big Data- Techniques 4:26
lecture 12 Big Data- Real-life Examples 1:32
lecture 13 Business Intelligence (BI)- Techniques 6:46
lecture 14 Business Intelligence (BI)- Real-life Examples 1:43
lecture 15 Traditional Methods- Techniques 9:8
lecture 16 Traditional Methods- Real-life Examples 2:46
lecture 17 Machine Learning (ML)- Techniques 6:55
lecture 18 Machine Learning (ML)- Types of Machine Learning 8:13
lecture 19 Machine Learning (ML)- Real-life Examples 2:12

Section 6 : Intro to Data and Data Science Common Data Science Tools

lecture 20 Programming Languages & Software Employed in Data 5:51

Section 7 : Intro to Data and Data Science Data Science Career Paths

lecture 21 Data Science Job Positions- What do they Involve a 3:29

Section 8 : Intro to Data and Data Science Dispelling Common Misconcepti

lecture 22 Dispelling common Misconceptions 4:10

Section 9 : Part 2 Statistics PopulationandSample

lecture 23 Population vs sample 4:2

Section 10 : Statistics Descriptive Statistics

lecture 24 Types of Data 4:33
lecture 25 Levels of Measurement 3:44
lecture 26 Categorical Variables - Visualization Techniques 4:53
lecture 27 Categorical Variables Exercise Pdf
lecture 28 Numerical Variables - Frequency Distribution Table 3:10
lecture 29 Numerical Variables Exercise
lecture 30 The Histogram 2:14
lecture 31 Histogram Exercise Pdf
lecture 32 Cross Table and Scatter Plot 4:44
lecture 33 Cross Tables and Scatter Plots Exercise
lecture 34 Mean, median and mode 4:20
lecture 35 Mean, Median and Mode Exercise
lecture 36 Skewness 2:38
lecture 37 Skewness Exercise
lecture 38 Variance 5:55
lecture 39 Variance Exercise
lecture 40 Standard Deviation and Coefficient of Variation 4:41
lecture 41 Standard Deviation and CoefficientofVariationExerc
lecture 42 Covariance 3:24
lecture 43 Covariance Exercise
lecture 44 Correlation Coefficient 3:18
lecture 45 Correlation Coefficient Exercise

Section 11 : Statistics Practical ExampleDescriptive Statistics

lecture 46 Practical Example
lecture 47 Practical Example Exercise

Section 12 : StatisticsInferentialStatisticsFundamentals

lecture 48 Introduction 1:1
lecture 49 What is a Distribution 4:33
lecture 50 The Normal Distribution 3:54
lecture 51 The Standard Normal Distribution 3:31
lecture 52 The Standard Normal Distribution Exercise
lecture 53 Central Limit Theorem 4:20
lecture 54 Standard error 1:27
lecture 55 Estimators and Estimates 3:8

Section 13 : StatisticsInferentialStatisticsConfidenceIntervals

lecture 56 What are Confidence Intervals 2:42
lecture 57 Confidence Intervals; Population Variance Known; z 8:2
lecture 58 ConfidenceIntervalsPopulationVarianceKnownzscoreEx
lecture 59 Confidence interval clarifications 4:39
lecture 60 Student's T Distribution 3:23
lecture 61 Confidence Intervals; Population Variance Unknown; 4:37
lecture 62 Confidence IntervalsPopulationVarianceUnknowntscor
lecture 63 Margin of Error 4:53
lecture 64 Confidence intervals. Two means. Dependent samples 6:4
lecture 65 Confidence intervalsTwomeansDependentsamplesExerci
lecture 66 Confidence intervals. Two means. Independent sampl 4:31
lecture 67 Confidenceintervals.TwomeansIndependentsamples (Pa
lecture 68 Confidence intervals. Two means. Independent sampl 3:58
lecture 69 ConfidenceintervalsTwomeansIndependentsamples (Par
lecture 70 Confidence intervals. Two means. Independent sampl 1:27

Section 14 : Statistics Practical ExampleInferentialStatistics

lecture 71 Practical Example- Inferential Statistics 10:6
lecture 72 Practical ExampleInferentialStatisticsExercise

Section 15 : StatisticsHypothesisTesting

lecture 73 The Null vs Alternative Hypothesis 5:52
lecture 74 Further ReadingonNullandAlternativeHypothesis Text
lecture 75 Rejection Region and Significance Level 7:6
lecture 76 Type I Error and Type II Error 4:14
lecture 77 Test for the Mean. Population Variance Known 6:35
lecture 78 Test for theMeanPopulationVarianceKnownExercise
lecture 79 p-value 4:49
lecture 80 Remove - INTRODUCTION TO BRAINMEASURES PROCTOR SYS Pdf
lecture 81 Test for the Mean.PopulationVarianceUnknownExercis
lecture 82 Test for the Mean. Dependent Samples 5:18
lecture 83 Test for the Mean. Dependent SamplesExercise
lecture 84 Test for the mean. Independent samples (Part 1) 4:22
lecture 85 Test for the mean.Independentsamples(Part 1).Exerc
lecture 86 Test for the mean. Independent samples (Part 2) 4:27
lecture 87 Test for the mean.Independentsamples(Part 2)

Section 16 : Statistics Practical ExampleHypothesisTesting

lecture 88 Practical Example- Hypothesis Testing 7:16
lecture 89 Practical ExampleHypothesisTestingExercise

Section 17 : Part 3 RelationalDatabaseTheory&IntroductiontoSQL

lecture 90 Why use SQL 3:18
lecture 91 Why use MySQL 1:57
lecture 92 Introducing Databases 4:44
lecture 93 Relational Database Fundamentals 4:51
lecture 94 Comparing Databases and Spreadsheets 7:5
lecture 95 Important Database Terminology 4:17
lecture 96 The Concept of Relational Schemas- Primary Key
lecture 97 The Concept of Relational Schemas- Foreign Key 4:59
lecture 98 The Concept of Relational Schemas- Unique Key and 3:8
lecture 99 The Concept of Relational Schemas- Relationships 4:39

Section 18 : SQLInstallandgettoknowMySQL

lecture 100 Installing MySQL Workbench and Server 10:49
lecture 101 Installing Visual C Text
lecture 102 Installing MySQL on macOS and Unixsystems Text
lecture 103 The Client-Server Model Pdf
lecture 104 Linking GUI with the MySQL Server 2:34
lecture 105 Read me!! Text
lecture 106 Creating a New User and a New Connection to it 6:18
lecture 107 Familiarize Yourself with the MySQL Interface 5:9

Section 19 : SQL Best SQLPractices

lecture 108 Coding Tips and Best Practices - I. 5:34
lecture 109 Coding Tips and Best Practices - II 4:12
lecture 110 Remove - INTRODUCTION TO BRAINMEASURES PROCTOR SYS Pdf

Section 20 : SQL Loading the employeesDatabase

lecture 111 Loading the 'employees' Database Pdf

Section 21 : SQL PracticalApplicationoftheSQLSELECTStatement

lecture 112 Using SELECT - FROM 4:57
lecture 113 Using SELECT - FROM - Exercise Text
lecture 114 Using SELECT - FROM - Solution Text
lecture115 Using WHERE 2:30
lecture 116 Using WHERE - Exercise Text
lecture 117 Using WHERE - Solution Text
lecture 118 Using AND 2:14
lecture 119 Using AND - Exercise Text
lecture 120 Using AND - Solution Text
lecture 121 Using OR 3:36
lecture 122 Using OR - Exercise Text
lecture 123 Using OR - Solution Text
lecture 124 Operator Precedence and Logical Order 3:36
lecture 125 Operator PrecedenceandLogicalOrderExercise Text
lecture 126 Operator PrecedenceandLogicalOrderSolution Text
lecture 127 Using IN - NOT IN 3:12
lecture 128 Using IN - NOT IN - Exercise 1 Text
lecture 129 Using IN - NOT IN - Solution 1 Text
lecture 130 Using IN - NOT IN - Exercise 2 Text
lecture 131 Using IN - NOT IN - Solution 2 Text
lecture 132 Using LIKE - NOT LIKE 3:36
lecture 133 Using LIKE - NOT LIKE - Exercise Text
lecture 134 Using LIKE - NOT LIKE - Solution Text
lecture 135 Using LIKE - NOT LIKE - Solution Text
lecture 136 Using Wildcard characters - Exercise Text
lecture 137 UsingWildcardcharactersSolution Text
lecture 138 UsingWildcardcharactersSolution Text
lecture 139 Using BETWEEN - AND - Exercise Text
lecture 140 Using BETWEEN - AND - Solution Text
lecture 141 Using IS NOT NULL - IS NULL 1:38
lecture 142 Using IS NOT NULL - IS NULL - Exercise Text
lecture 143 Using IS NOT NULL - IS NULL - Solution Text
lecture 144 Using Other Comparison Operators 4:30
lecture 145 Using Other Comparison OperatorsExercise.docx Text
lecture 146 Using Other Comparison OperatorsSolution Text
lecture 147 Using SELECT DISTINCT 2:6
lecture 148 Using SELECTDISTINCTExercise Text
lecture 149 Using SELECT DISTINCT - Solution Text
lecture 150 Getting to Know Aggregate Functions 5:25
lecture 151 Getting to Know Aggregate Functions Exercise Text
lecture 152 Getting to Know Aggregate FunctionsSolution Text
lecture 153 Using ORDER BY 3:46
lecture 154 Using ORDER BY - Exercise Text
lecture 155 Using ORDER BY - Solution Text
lecture 156 Using GROUP BY 6:0
lecture 157 Using Aliases (AS) 2:9
lecture 158 Using Aliases (AS) - Exercise Text
lecture 159 Using Aliases (AS) - Solution Text
lecture 160 Using HAVING 3:26
lecture 161 Using HAVING - Exercise Text
lecture 162 Using HAVING - Solution Text
lecture 163 Using WHERE vs HAVING - Part I
lecture 164 Using WHERE vs HAVING - Part II 3:8
lecture 165 Using WHERE vs HAVING - Part II - Exercise Text
lecture 166 Using WHERE vs HAVING - Part II - Solution Text
lecture 167 Using LIMIT 4:52
lecture 168 Using LIMIT - Exercise Text
lecture 169 Using LIMIT - Solution Text

Section 22 : SQL ExpandingonMySQLAggregateFunctions

lecture 170 Applying COUNT( 4:1
lecture 171 Applying COUNT() - Exercise Text
lecture 172 Applying COUNT() - Solution Text
lecture 173 Applying SUM() 1:31
lecture 174 Applying SUM() - Exercise Text
lecture 175 Applying SUM() - Solution Text
lecture 176 MIN() and MAX() 1:15
lecture 177 MIN() and MAX() - Exercise Text
lecture 178 MIN() and MAX() - Solution Text
lecture 179 Applying AVG() 1:58
lecture 180 Applying AVG() - Exercise Text
lecture 181 Applying AVG() - Solution Text
lecture 182 Rounding Numbers with ROUND() 2:6
lecture 183 Rounding Numbers with ROUND() - Exercise Text
lecture 184 Rounding Numbers with ROUND() Solution Text

Section 23 : SQL SQL JOINs

lecture 185 What are JOINs 4:23
lecture 186 What are JOINs? - Exercise 1 Text
lecture 187 What are JOINs? - Exercise 2 Text
lecture 188 The Functionality of INNER JOIN - Part I 6:3
lecture 189 The Functionality of INNER JOIN - Part II 5:34
lecture 190 The FunctionalityofINNER JOIN PART II Exercise Text
lecture 191 The Functionality of INNER JOIN PART II Solution Text
lecture 192 Extra Info on Using Joins 4:10
lecture 193 Duplicate Rows 4:21
lecture 194 The Functionality of LEFT JOIN - Part I 4:31
lecture 195 The Functionality of LEFT JOIN - Part II 5:46
lecture 196 The Functionality of LEFT JOIN Part II Exercise Text
lecture 197 The Functionality of LEFT JOIN - Part II Solution Text
lecture 198 The Functionality of RIGHT JOIN 4:31
lecture 199 Differences between the New and the Old Join Synta 4:18
lecture 200 Differences between the New andtheOldJoinSyntaxEx Text
lecture 201 Differences between the New andtheOldJoinSyntaxSol Text
lecture 202 Using JOIN and WHERE Together 2:54
lecture 203 Important Prevent Error Code 1055 Text
lecture 204 Using JOIN and WHERE Together Exercise Text
lecture 205 Using JOIN and WHERE Together Solution Text
lecture 206 The Functionality of CROSS JOIN 7:42
lecture 207 The Functionality of CROSS JOIN Exercise 1 Text
lecture 208 The Functionality of CROSS JOIN Solution 1 Text
lecture 209 The Functionality of CROSS JOIN Exercise 2 Text
lecture 210 The Functionality of CROSS JOIN Solution 2 Text
lecture 211 Combining Aggregate Functions with Joins
lecture 212 JOIN More than Two Tables 4:27
lecture 213 JOIN More than Two Tables Exercise Text
lecture 214 JOIN More than Two Tables - Solution Text
lecture 215 Remove - INTRODUCTION TO BRAINMEASURES PROCTOR SYS Pdf
lecture 216 Top Tips for Joins - Exercise Text
lecture 217 Top Tips for Joins - Solution Text
lecture 218 The Differences Between UNION and UNION ALL 5:45
lecture 219 The Differences Between UNION andUNIONALLExercise Text
lecture 220 The DifferencesBetweenUNIONandUNIONALLSolution Text

Section 24 : SQL SQL Subqueries

lecture 221 SQL Subqueries with IN Embedded Inside WHERE 4:32
lecture 222 SQL Subqueries with INEmbeddedInsideWHERE Exercise Text
lecture 223 SQL Subqueries with IN Embedded InsideWHERE Soluti Text
lecture 224 SQL Subqueries with EXISTS-NOT EXISTS Embedded Ins 3:43
lecture 225 SQL Subqueries with EXISTSNOTEXISTSEmbedded Inside Text
lecture 226 SQL Subqueries with EXISTSNOTEXISTSEmbedded Insid Text
lecture 227 SQL Subqueries Nested in SELECT and FROM 7:57
lecture 228 SQL Subqueries Embedded inSELECT andFROM Exercise Text
lecture 229 SQL Subqueries Embedded inSELECT andFROM Exercise Text
lecture 230 SQL SubqueriesNestedinSELECTandFROM Solution 2

Section 25 : SQL Stored Routines

lecture 231 Defining Stored Routines 3:26
lecture 232 Create Stored Procedures with MySQL Syntax 4:32
lecture 233 An Example of Stored Procedures Part I 4:32
lecture 234 An Example of Stored Procedures Part II 4:49
lecture 235 An Example ofStoredProceduresPartIIExercise Text
lecture 236 An Example ofStoredProceduresPartIISolution Text
lecture 237 Creating a Procedure in MySQL Another Way 3:19
lecture 238 Create Stored Procedures with an Input Parameter 3:54
lecture 239 Create Stored Procedures with an Output Parameter 3:20
lecture 240 Create Stored Procedures withanOutputParameterExer Text
lecture 241 Stored Procedures with anOutputParameterSolution Text
lecture 242 SQL Variables 6:50
lecture 243 SQL Variables Exercise Text
lecture 244 SQL VariablesSolution Text
lecture 245 The Benefit of User-Defined Functions in MySQL 6:14
lecture 246 Error Code 1418 Text
lecture 247 The Benefit of UserDefined FunctionsinMySQL Exerci Text
lecture 248 The Benefit ofUserDefinedFunctionsinMySQL Solution Text
lecture 249 Concluding Stored Routines 3:55

Section 26 : SQL The CASE Statement

lecture 250 The SQL CASE Statement 5:57
lecture 251 The SQL CASE Statement Exercise 1 Text
lecture 252 THE SQL CASE Statement - Solution 1 Text
lecture 253 THE SQL CASE Statement - Exercise 2 Text
lecture 254 THE SQL CASE Statement - Solution 2 Text
lecture 255 THE SQL CASE Statement Exercise 3 Text
lecture 256 THE SQL CASE Statement - Solution 3 Text

Section 27 : Part 4 Introduction to Tableau

lecture 257 Why Use Tableau- Make Your Data Make an Impact 4:23
lecture 258 Let's Download Tableau Public 2:3
lecture 259 Connecting Data in Tableau 1:4
lecture 260 Remove - INTRODUCTION TO BRAINMEASURES PROCTOR SYS Pdf
lecture 261 Let's Create our first Chart in Tableau! 7:12

Section 28 : Tableau Tableau functionalities

lecture 262 Duplicating a Sheet 2:49
lecture 263 Creating a Table 4:49
lecture 264 Creating Custom Fields 2:29
lecture 265 Creating a Custom Field and Adding Calculations to 3:41
lecture 266 Adding Totals and Subtotals 2:3
lecture 267 Adding a Custom Calculation 3:12
lecture 268 Inserting a Filter 2:21
lecture 269 Working with Joins in Tableau 4:33
lecture 269 Working with Joins in Tableau 4:33

Section 29 : Tableau The Tableau Exercise

lecture 270 Introduction to the Exercise 2:6
lecture 271 Let's Create a Dashboard - Visualizing the Three C
lecture 272 Using Joins in Tableau 5:16
lecture 273 Performing a Numbers Check - Attempt #1 3:49
lecture 274 Blending Data in Tableau 5:49
lecture 275 Performing a Numbers Check - Attempt #2 3:41
lecture 276 First Chart 4:5
lecture 277 Second Chart 3:7
lecture 278 Third Chart 2:39
lecture 279 Creating and Formatting a Dashboard 4:26
lecture 280 Adding Interactive Filters for Improved Analysis 3:55
lecture 281 Interactive Filters - fix 1:38

Section 30 : Part 5CombiningSQLandTableau Introduction

lecture 282 Introduction to Software Integration 5:20
lecture 283 Combining SQL and Tableau 4:51
lecture 284 Loading the Database 1:24
lecture 285 Loading the Database Pdf

Section 31 : CombiningSQLandTableauProblem 1

lecture 286 Problem 1- Task 3:16
lecture 287 Problem 1 Task Text Text
lecture 288 Important clarification! Zip
lecture 289 Problem 1- Solution in SQL 4:42
lecture 290 Problem 1 Solution in SQL Code Text
lecture 291 Exporting Your Output from SQL and Loading it in T 4:13
lecture 292 Chart 1- Visualizing the Solution in Tableau - Pa 6:18
lecture 293 Chart 1- Visualizing the Solution in Tableau - Par 5:25

Section 32 : CombiningSQLandTableauProblem 2

lecture 294 Problem 2- Task 3:50
lecture 295 Problem 2 Task - Text Text
lecture 296 Problem 2- Solution in SQL 3:43
lecture 297 Problem 2 Solution in SQL Code Text
lecture 298 Chart 2- Visualizing the Solution in Tableau 6:9

Section 33 : CombiningSQLandTableauProblem 3

lecture 299 Problem 3- Task 2:21
lecture 300 Problem 3 Task Text Text
lecture 301 Problem 3- Solution in SQL 3:15
lecture 302 Problem 3 Solution in SQLCode Text
lecture 303 Chart 3- Visualizing the Solution in Tableau 4:57

Section 34 : Combining SQL andTableauProblem 4

lecture 304 Problem 4- Task 2:46
lecture 305 Problem 4 Task Text Text
lecture 306 Problem 4- Solution in SQL 2:48
lecture 307 Problem 4 Solution in SQL Code Text
lecture 308 Chart 4- Visualizing the Solution in Tableau 3:22

Section 35 : CombiningSQLandTableauProblem 5

lecture 309 Problem 5- Organizing Charts 1-4 into a Beautiful 6:4

Section 36 : Part 6 Introduction toProgrammingwithPython

lecture 310 A 5-minute explanation of Programming 5:4
lecture 311 Why use Python 5:11
lecture 312 Why use Jupyter 3:29
lecture 313 How to Install Python and Jupyter 6:49
lecture 314 Understanding Jupyter’s Interface – Dashboard 3:16
lecture 315 Understanding Jupyter’s Interface – Prerequisites 6:15
lecture 316 Python 2 vs Python 3 2:47

Section 37 : Python Python Variables andData Types

lecture 317 Python Variables 4:52
lecture 318 Understanding Numbers and Boolean Values 3:6
lecture 319 Strings 5:44

Section 38 : PythonPythonSyntaxFundamentals

lecture 320 The Arithmetic Operators of Python 3:24
lecture 321 What is the Double Equality Sign 1:34
lecture 322 How to Reassign Values 1:8
lecture 323 How to Add Comments 1:25
lecture 324 Understanding Line Continuation 0:50
lecture 325 How to Index Elements 1:18
lecture 326 How to Structure Your Code with Indentation 1:45

Section 39 : Python Other Python Operators

lecture 327 Python's Comparison Operators 2:10
lecture 328 Python's Logical and Identity Operator 5:36

Section 40 : Python Conditional Statements

lecture 329 Getting to know the IF Statement 3:4
lecture 330 Adding an ELSE statement 2:39
lecture 331 Else if, for Brief – ELIF 5:33
lecture 332 An Additional Explanation of Boolean Values 2:13

Section 41 : Python Functions

lecture 333 How to Define a Function in Python 2:3
lecture 334 How to Create a Function with a Paramete 3:49
lecture 335 Define a Function in Another Way 2:35
lecture 336 How to use a Function within a Function 1:49
lecture 337 Use Conditional Statements and Functions Together 3:7
lecture 338 How to Create Functions Which Contain a Few Argume 1:14
lecture 339 Built-In Functions in Python Worth Knowing 3:56

Section 42 : Python Python Sequences

lecture 340 Introduction to Lists 4:2
lecture 341 Using Methods in Python 3:22
lecture 342 What is List Slicing 4:31
lecture 343 Working with Tuples 3:13
lecture 344 Python Dictionaries 4:4

Section 43 : Python Using Iterations

lecture 345 Using For Loops 2:27
lecture 346 Using While Loops and Incrementing 2:27
lecture 347 Use the range() Function to Create Lists 2:23
lecture 348 Combine Conditional Statements and Loops 3:6
lecture 349 All In – Conditional Statements, Functions, and Lo 2:27
lecture 350 How to Iterate over Dictionaries 3:8