Data Analysis Programming Level 3 Certification: JavaScript, SQL, MySQL & C++ Fundamentals

Bespoke Learning Solutions

Reed Courses Certificate of Completion

Digital certificate - Included

• Course 01: JavaScript with Data Visualisation Training 6:19:42

  • 1: Data Analysis: 1a Introduction to Getting Started Preview 01:58
  • 2: Data Analysis: b Course Curriculum Preview 05:06
  • 3: Data Analysis: How to Get Pre-Requisites Preview 01:39
  • 4: Data Analysis: 1d Getting Started on Windows, Linux or Mac 01:01
  • 5: Data Analysis: 1e How to ask a Great Questions 01:32
  • 6: Data Analysis: FAQ’s 01:05
  • 7: Data Analysis: 2a What is JavaScript Preview 08:54
  • 8: Data Analysis: 2b Choosing Code Editor 03:13
  • 9: Data Analysis: Installing Code Editor (Sublime Text) 03:49
  • 10: Data Analysis: Installing Code Editor(Visual Studio Code) Preview 06:33
  • 11: Data Analysis: 2e Hello World Program 13:33
  • 12: Data Analysis: 2f Getting Output 10:57
  • 13: Data Analysis: 2g Summary 01:38
  • 14: Data Analysis: 3a Introduction 02:22
  • 15: Data Analysis: 3b Internal JavaScript 13:29
  • 16: Data Analysis: 3c External JavaScript 08:49
  • 17: Data Analysis: 3d Inline JavaScript 03:45
  • 18: Data Analysis: 3e Async and defer 05:50
  • 19: Data Analysis: 3f Variables 12:41
  • 20: Data Analysis: 3g Data Types 09:41
  • 21: Data Analysis: Numbers 05:48
  • 22: Data Analysis: 3i Boolean 04:00
  • 23: Data Analysis: Arrays() 12:27
  • 24: Data Analysis: 3k Objects 06:20
  • 25: Data Analysis: 3l Comments 05:28
  • 26: Data Analysis: Summary 01:12
  • 27: Data Analysis: Introduction 01:47
  • 28: Data Analysis: 4b Strings 05:54
  • 29: Data Analysis: 4c String Formatting 05:15
  • 30: Data Analysis: 4d String Methods 11:56
  • 31: Data Analysis: 4e Summary 01:40
  • 32: Data Analysis: Introduction 01:42
  • 33: Data Analysis: Arithmetic operators 07:14
  • 34: Data Analysis: 5c Assignment operators 03:08
  • 35: Data Analysis: 5d Comparison operators 06:06
  • 36: Data Analysis: 5e Logical operators 07:45
  • 37: Data Analysis: 5f Summary 01:43
  • 38: Data Analysis: 6a Introduction 01:39
  • 39: Data Analysis: 6b If statement 04:23
  • 40: Data Analysis: 6c If-else statement 05:18
  • 41: Data Analysis: 6d If-else-if statement 04:28
  • 42: Data Analysis: 6e Switch-case statement 09:13
  • 43: Data Analysis: 6f Summary 01:20
  • 44: Data Analysis: 7a Introduction 01:40
  • 45: Data Analysis: 7b While loop 08:32
  • 46: Data Analysis: 7c Do-while loop 02:30
  • 47: Data Analysis: 7d For loop 07:57
  • 48: Data Analysis: 7e Break 02:06
  • 49: Data Analysis: 7f Continue 02:49
  • 50: Data Analysis: 7g Coding Exercise 01:36
  • 51: Data Analysis: 7h Solution for Coding Exercise 01:40
  • 52: Data Analysis: 7i Summary 01:31
  • 53: Data Analysis: 8a Introduction 01:36
  • 54: Data Analysis: 8b Creating a Function 07:23
  • 55: Data Analysis: 8c Function Call() 06:52
  • 56: Data Analysis: Function with parameters 05:09
  • 57: Data Analysis: 8e Function Bind() 05:49
  • 58: Data Analysis: 8f Summary 01:19
  • 59: Data Analysis: 9a Introduction 00:57
  • 60: Data Analysis: 9b How to Use Google chart script 03:52
  • 61: Data Analysis: 9c Line Graph chart 13:30
  • 62: Data Analysis: 9d Scatter plots chart 02:13
  • 63: Data Analysis: 9e Bar chart 03:30
  • 64: Data Analysis: 9f Pie chart 02:09
  • 65: Data Analysis: 9g 3D Pie chart 01:54
  • 66: Data Analysis: 9h Summary 01:05
  • 67: Data Analysis: 10a Introduction 01:22
  • 68: Data Analysis: 10b Try-catch 05:24
  • 69: Data Analysis: 10c Try-catch-finally 16:36
  • 70: Data Analysis: 10d Summary 01:08
  • 71: Data Analysis: 11a Introduction 01:11
  • 72: Data Analysis: 11b On Submit Validation 08:42
  • 73: Data Analysis: 11c Input Numeric Validation 12:16
  • 74: Data Analysis: 11d Login Form Validation 05:14
  • 75: Data Analysis: 11e Password Strength Check Validation 04:19
  • 76: Data Analysis: 11f Summary 01:05
  • 77: Data Analysis: 12a Bonus Lecture for Where to Go 01:25

• Course 02: Diploma in Master SQL Database Queries 7:18:46

  • 78: 1a Introduction Preview 02:57
  • 79: 1b How to get course requirements 02:32
  • 80: 1c Getting started on Windows, Linux or Docker Preview 00:58
  • 81: 1d How to ask great questions 01:20
  • 82: 1e FAQ’s 01:09
  • 83: 2a Section Introduction 01:42
  • 84: 2b Microsoft SQL Server Installation 18:35
  • 85: 2c SQL Server Management Studio (SSMS) Installation 08:28
  • 86: 2d How to connect MS SQL (Windows Authentication) 03:40
  • 87: 2e How to connect MS SQL (SQL Server Authentication) 03:13
  • 88: 2f Download and Restore Sample Database 07:27
  • 89: 3a What is Azure Data Studio 06:25
  • 90: 3b Azure Data Studio Installation steps 07:09
  • 91: 3c Azure Data Studio to Connect SQL Server 09:00
  • 92: 3d Create a Database 06:32
  • 93: 3e Create a Table 08:46
  • 94: 3f Insert Data rows 06:37
  • 95: 3g view the Data returned by Query 03:05
  • 96: 4a Section Introduction 01:16
  • 97: 4b Overview of Databases 10:47
  • 98: 4c Creating Database 04:54
  • 99: 4d SQL Data Types 03:23
  • 100: 4e Column Data Types on SSMS 03:55
  • 101: 4f Creating Table 09:10
  • 102: 4g Overview of Primary Key and Foreign Key 04:05
  • 103: 4h Primary Key 04:06
  • 104: 4i Foreign Key 06:52
  • 105: 4j Creating Temporary tables 06:29
  • 106: 5a Section Introduction 00:49
  • 107: 5b Insert statement 08:25
  • 108: 5c Update statement 05:07
  • 109: 5d Delete statement 03:12
  • 110: 6a Section Introduction 00:54
  • 111: 6b CREATE table statement 02:58
  • 112: 6c DROP statement 02:10
  • 113: 6d ALTER statement 05:28
  • 114: 6e TRUNCATE statement 04:04
  • 115: 6f COMMENT in query 00:55
  • 116: 6g RENAME 01:41
  • 117: 7a Create Database user 03:55
  • 118: 7b GRANT permissions 06:09
  • 119: 7c REVOKE permissions 04:11
  • 120: 8a Section Introduction 01:14
  • 121: 8b SQL Statement basic 03:19
  • 122: 8c SELECT Statement 07:24
  • 123: 8d SELECT DISTINCT 02:42
  • 124: 8e SELECT with column headings 02:35
  • 125: 8f Column AS statement 02:05
  • 126: 9a SELECT WHERE Clause – theory 03:40
  • 127: 9b SELECT WHERE Clause – practical 07:15
  • 128: 10a Sum() 08:01
  • 129: 10b Min()-Max() 05:48
  • 130: 11a Order By statement 05:26
  • 131: 11b SELECT TOP clause in SQL 04:06
  • 132: 11c BETWEEN command 08:09
  • 133: 11d IN operator 04:04
  • 134: 11e Wildcard Characters and LIKE 04:53
  • 135: 12a Section Introduction 01:10
  • 136: 12b Group by – theory 03:11
  • 137: 12c Group by – practical 05:28
  • 138: 12d HAVING statement 03:32
  • 139: 13a Overview of Joins 01:56
  • 140: 13b What are Joins 02:16
  • 141: 13c Inner join 07:55
  • 142: 13d Left outer join 02:50
  • 143: 13e Right outer join 02:19
  • 144: 13f Full outer join 01:21
  • 145: 13g Union 02:46
  • 146: 13h Cross join 03:10
  • 147: 13i Query Exercise 01:06
  • 148: 13j Solution for Query Exercise 01:09
  • 149: 14a Section introduction 00:55
  • 150: 14b Check constraint 06:54
  • 151: 14c NOT NULL constraint 08:29
  • 152: 14d UNIQUE constraint 05:02
  • 153: 15a Creating Views 03:58
  • 154: 15b Reporting with multiple tables 03:05
  • 155: 16a Section Introduction 00:51
  • 156: 16b Timestamp 04:27
  • 157: 16c Extract from timestamp 03:11
  • 158: 16d Mathematical scalar functions 03:50
  • 159: 16e String functions 04:55
  • 160: 16f Sub Query 03:09
  • 161: 16g SELECT with calculations 06:18
  • 162: 17a Create stored procedure 04:36
  • 163: 17b Stored procedure with parameter 04:29
  • 164: 18a Installing SandDance Extension 02:37
  • 165: 18b Visualization Charts 04:57
  • 166: 18c Multiple Table Data Charts 06:02
  • 167: 19a Type Decision for Data Analysis 13:01
  • 168: 19b Data Analysis with Case Statement and String Text 09:15
  • 169: 20a Section Introduction 01:08
  • 170: 20b Import Flat File 05:03
  • 171: 20c Import .csv or excel file 02:40
  • 172: 20d Export Data to Excel or any format 06:08
  • 173: 21a Section Introduction 00:59
  • 174: 21b Creating Database backup 03:52
  • 175: 21c Restoring Database backup 03:35

• Course 03: SQL Programming with MySQL Database Level 3 5:49:24

  • 176: 1a Introduction 02:23
  • 177: 1b How to get course requirements 01:23
  • 178: 1c Getting started on Windows, Linux or Mac 00:48
  • 179: 1d How to ask great questions 01:27
  • 180: 1e FAQ’s 01:03
  • 181: 1g source code file 08:47
  • 182: 2a Section Introduction 01:08
  • 183: 2b MySQL Server Installation 13:44
  • 184: 2c Connect MySQL Server Instance 05:50
  • 185: 2d MySQL Workbench overview 10:41
  • 186: 2e Download and Restore Sample Database 07:43
  • 187: 3a Section Introduction 01:10
  • 188: 3b Overview of Databases 09:16
  • 189: 3c Creating Database 06:34
  • 190: 3d SQL Data Types 03:47
  • 191: 3e Column Data Types on Workbench 07:23
  • 192: 3f Creating Table 03:45
  • 193: 3g Overview of Primary and Foreign Key 03:29
  • 194: 3h Primary Key 06:09
  • 195: 3i Foreign Key 11:34
  • 196: 3j Creating Temporary tables 12:23
  • 197: 3k EER – Enhanced Entity Relationship Diagrams 04:21
  • 198: 4a Section Introduction 01:17
  • 199: 4b Insert statement 07:12
  • 200: 4c Update statement 06:03
  • 201: 4d Delete statement 03:13
  • 202: 5a Section Introduction 01:11
  • 203: 5b CREATE table statement 07:51
  • 204: 5c DROP statement 02:59
  • 205: 5d ALTER statement 04:54
  • 206: 5e TRUNCATE statement 03:03
  • 207: 5f COMMENT in query 02:23
  • 208: 5g RENAME table 03:16
  • 209: 6a Create Database user 03:16
  • 210: 6b GRANT permissions 05:06
  • 211: 6c REVOKE permissions 03:47
  • 212: 7a Section Introduction 00:56
  • 213: 7b SQL Statement basic 03:17
  • 214: 7c SELECT Statement 03:12
  • 215: 7d SELECT DISTINCT 01:31
  • 216: 7e SELECT with column headings 01:28
  • 217: 7f Column AS statement 02:21
  • 218: 7g DASHBOARD Analytics 06:04
  • 219: 8a SELECT WHERE Clause – theory 03:04
  • 220: 8b SELECT WHERE Clause – practical 06:16
  • 221: 9a Sum() 06:20
  • 222: 9b Min()-Max() 02:40
  • 223: 10a Order By statement 04:43
  • 224: 10b SELECT TOP 3 records 01:44
  • 225: 10c BETWEEN command 05:46
  • 226: 10d IN operator 02:57
  • 227: 10e Search Data using LIKE cards 04:35
  • 228: 11a Section Introduction 00:43
  • 229: 11b Group by – theory 03:34
  • 230: 11c Data Analytics with Group By 03:59
  • 231: 11d HAVING statement 03:01
  • 232: 12a Overview of Joins 02:02
  • 233: 12b What are Joins 02:18
  • 234: 12c Inner join 06:43
  • 235: 12d Left outer join 02:05
  • 236: 12e Right outer join 01:53
  • 237: 12f Union 02:54
  • 238: 12g CERTESIAN Product or Cross Join 03:14
  • 239: 12h Query Exercise 01:16
  • 240: 12i Solution for Query Exercise 01:03
  • 241: 13a Section introduction 01:24
  • 242: 13b Check constraint 08:33
  • 243: 13c NOT NULL constraint 02:46
  • 244: 13d UNIQUE constraint 05:53
  • 245: 14a Creating Views 03:26
  • 246: 14b Data Analytic Views from multiple tables 03:15
  • 247: 15a Section Introduction 01:02
  • 248: 15b Timestamp 03:11
  • 249: 15c Extract from timestamp 03:01
  • 250: 15d Mathematical scalar functions 02:35
  • 251: 15e String functions 07:14
  • 252: 15f Advanced functions 03:59
  • 253: 15g Sub Queries 03:11
  • 254: 15h SELECT with calculations 04:45
  • 255: 16a Create stored procedure 05:39
  • 256: 16b Stored procedure with parameter 03:19
  • 257: 16c Drop Procedure 01:21
  • 258: 17a Section Introduction 01:09
  • 259: 17b Import .csv file 04:07
  • 260: 17c Export Data to .csv file 02:13
  • 261: 18a Section Introduction 00:45
  • 262: 18b Creating Database backup 02:28
  • 263: 18c Restoring Database backup 02:10

• Course 04: C++ Fundamentals for Beginners 5:40:42

  • 264: 1a intoduction 03:10
  • 265: 1b Course Curriculum 04:56
  • 266: 1c Getting started on Windows, Mac or Linux 00:48
  • 267: 1d How to ask great questions 01:06
  • 268: 1e FAQ’s 01:02
  • 269: 2a Introduction 01:17
  • 270: 2b CPP Futures 03:09
  • 271: 2C Why it Popular in Coding 03:31
  • 272: 2d Popular IDEs for Coding 02:51
  • 273: 2e Get and Installing Visual Studio Editor 11:05
  • 274: 2f Creating First Project 08:26
  • 275: 2g Your First CPP Program 08:22
  • 276: 2h Compiling and Run a CPP Program 03:45
  • 277: 3a Introduction 01:06
  • 278: 3b Creating Variables 11:52
  • 279: 3c Creating Multiple Variables 07:01
  • 280: 3d Constants 06:05
  • 281: 3e Identifiers 05:43
  • 282: 3f Naming Convention 04:29
  • 283: 3g Working with standard library 03:28
  • 284: 3h Output Text and New Lines 07:10
  • 285: 3i Reading User Input 07:37
  • 286: 3j Simple Calculator Program 05:40
  • 287: 3k Comments 03:09
  • 288: 4a Introduction 01:33
  • 289: 4b Data type basics 05:18
  • 290: 4c Numeric types 06:14
  • 291: 4d String types 04:13
  • 292: 4e Character types 03:49
  • 293: 4f Boolean types 03:39
  • 294: 5a Introduction 00:52
  • 295: 5b Arithmetic operators 05:01
  • 296: 5c Assignment operators 03:59
  • 297: 5d Comparison operators 05:17
  • 298: 5e Logical operators 09:19
  • 299: 6a Introduction 01:01
  • 300: 6b Strings 06:12
  • 301: 6c Concatenation and append 10:16
  • 302: 6d String Built-in Functions 08:57
  • 303: 6e String Indexing 03:47
  • 304: 6f String Formatting 05:26
  • 305: 6g String Keyboard Input getline() 04:28
  • 306: 6h Using namespace 02:04
  • 307: 7a Introduction 00:54
  • 308: 7b If statement 04:19
  • 309: 7c else statement 02:46
  • 310: 7d else if statement 03:58
  • 311: 7e Ternary operator 03:55
  • 312: 7f Switch-case statement 06:32
  • 313: 8a Introduction 01:50
  • 314: 8b While loop 05:32
  • 315: 8c Do-while loop 02:00
  • 316: 8d For loop 08:15
  • 317: 8e Customize loop running 02:37
  • 318: 8f Break statement 02:06
  • 319: 8g Continue statement 03:07
  • 320: 8h Nested loops 05:59
  • 321: 8i Prime Number Program 06:47
  • 322: 8j Coding exercise 01:48
  • 323: 8k Solution for coding exercise 01:23
  • 324: 9a Introduction 00:50
  • 325: 9b Array statement 06:16
  • 326: 9c Change array data item 02:05
  • 327: 9d Read array data using loops 03:56
  • 328: 9e Multidimensional Array 04:38
  • 329: 9f Update Multidimensional Array 02:04
  • 330: 9g Loop through Multidimensional Array 04:26
  • 331: 10a Introduction 01:08
  • 332: 10b Creating a function 03:07
  • 333: 10c Calling a function 05:25
  • 334: 10d Function with parameter 04:19
  • 335: 10e Default parameter 01:43
  • 336: 10f Multiple parameters 04:56
  • 337: 10g Return keyword 05:11
  • 338: 10h Call by value 01:55
  • 339: 10i Call by reference 02:18
  • 340: 10j Pass by Group items 04:06
  • 341: 10k Function overloading 05:54
  • 342: 10l Recursion 04:24

The Data Analysis Programming Level 3 Certification: JavaScript, SQL, MySQL & C++ Fundamentals is an intensive and comprehensive bundle that equips learners with key programming and data analysis skills needed to thrive in the world of data-driven decision-making. This certification includes courses on JavaScript, SQL, MySQL, and C++, each carefully structured to help learners develop expertise in writing powerful scripts, querying and analysing databases, and building dynamic data visualizations.

The JavaScript course covers everything from the fundamentals of coding, including functions, strings, operators, and error handling, to more advanced topics such as data visualization using Google Charts. This enables learners to build interactive web applications and effectively present data insights.

The SQL course introduces learners to the world of relational databases and their practical application in data analysis. From basic SQL queries to more advanced concepts such as JOINs, stored procedures, and Azure Data Studio visualizations, learners gain the skills to handle complex datasets and carry out efficient data analysis.

The MySQL course builds on SQL fundamentals and explores advanced techniques in database management, including Data Manipulation Language (DML), Data Definition Language (DDL), Data Control Language (DCL), and the use of SQL constraints, views, and stored procedures for optimal data analysis.

Lastly, the C++ fundamentals course introduces programming basics, including variables, data types, loops, functions, and arrays, offering the foundation needed for more complex applications in data science and programming.

This course bundle is perfect for anyone looking to master the essential tools for data analysis programming, offering the knowledge and hands-on experience necessary to tackle real-world data challenges.

Learning Outcome

• Develop data analysis skills using JavaScript for data visualisation.
• Master SQL to manage, query, and manipulate large datasets.
• Gain proficiency in MySQL for advanced data processing and analysis.
• Understand C++ fundamentals to implement efficient algorithms for data analysis.
• Apply data analysis techniques to complex datasets across various platforms.

• Aspiring Data Analysts
• Software Developers
• Data Scientists
• IT Professionals
• Project Managers in Data-Driven Environments
• Business Analysts
• Database Administrators
• Anyone interested in Data Analysis Programming

This course will pave the way for higher study in the field of Data Analysis. You can enrol on higher level Data Analysis courses, such as:

• Level 3 Diploma in Data Analysis
• Level 4 Diploma in Data Analysis
• Level 5 Diploma in Data Analysis
• Level 6 Diploma in Data Analysis
• Level 7 Diploma in Data Analysis and Machine Learning
• Level 8 Diploma in Data Analysis and Machine Learning

• No formal prerequisites required
• Basic understanding of computer operations and programming concepts is helpful

• Data analyst - £34,100 per annum
• Data Scientist - £50,618 per annum
• Data Engineer - £60,084per annum
• Data Analytics Consultant - £56,444 per annum
• Machine Learning Engineer - £56,631 per annum
• Data science intern - £20,203 per annum

Currently there are no Q&As for this course. Be the first to ask a question.