SQL Programming with MySQL Database for Data Science, Data Analytics & Data Visualization

Embark on an in-depth journey into SQL programming, specifically tailored for applications in Data Science, Data Analytics, and Data Visualization using MySQL and Microsoft SQL Server. Acquire robust SQL skills through a structured bootcamp and advanced query techniques, positioning you to manage and analyze vast datasets effectively.
Emerge as a proficient SQL programmer, equipped with the expertise to leverage SQL in MySQL databases for insightful data analysis and compelling data visualizations.

Key Performance Metrics:

• Master SQL fundamentals and advanced features in Microsoft SQL Server, tailored for 2024's technological demands.
• Develop expertise in crafting sophisticated SQL database queries to support complex data analysis and decision-making.
• Gain comprehensive SQL programming skills with MySQL, focusing on its application in Data Science and Analytics.
• Applying SQL knowledge to extract, analyze, and visualize data enhances your capabilities in data-driven environments.

Accreditation:

SQL Programming Course is CPDQE accredited, which serves as an impactful mechanism for skill enhancement.

Accredited Certificate from LearnDrive

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

Learndrive Special Bundle Certificate

Digital certificate - £7

• Course 01: Microsoft SQL Server Bootcamp 2024 6:10:07

  • 1: SQL: 1a Introduction 03:28
  • 2: SQL: 1b Course Curriculum 06:55
  • 3: SQL: 1c How to get course requirements 01:41
  • 4: SQL: 1d Getting started on Windows, Linux or Docker 00:57
  • 5: SQL: 1e How to ask great questions 01:19
  • 6: SQL: 1f FAQ’s 01:08
  • 7: SQL: 1g source code file 08:47
  • 8: SQL: 2a Section Introduction 01:42
  • 9: SQL: 2b Microsoft SQL Server Installation 18:34
  • 10: SQL: 2c SQL Server Management Studio (SSMS) Installation 08:28
  • 11: SQL: 2d How to connect MS SQL (Windows Authentication) 03:40
  • 12: SQL: 2e How to connect MS SQL (SQL Server Authentication) 03:13
  • 13: SQL: 2f Download and Restore Sample Database 07:26
  • 14: SQL: 3a Section Introduction 01:16
  • 15: SQL: 3b Overview of Databases 10:47
  • 16: SQL: 3c Creating Database 04:54
  • 17: SQL: 3d SQL Data Types 03:23
  • 18: SQL: 3e Column Data Types on SSMS 03:55
  • 19: SQL: 3f Creating Table 09:09
  • 20: SQL: 3g Overview of Primary Key and Foreign Key 04:04
  • 21: SQL: 3h Primary Key 04:05
  • 22: SQL: 3i Foreign Key 06:51
  • 23: SQL: 3j Creating Temporary tables 06:29
  • 24: SQL: 4a Section Introduction 00:48
  • 25: SQL: 4b Insert statement 08:25
  • 26: SQL: 4c Update statement 05:06
  • 27: SQL: 4d Delete statement 03:12
  • 28: SQL: 5a Section Introduction 00:54
  • 29: SQL: 5b CREATE table statement 02:58
  • 30: SQL: 5c DROP statement 02:10
  • 31: SQL: 5d ALTER statement 05:27
  • 32: SQL: 5e TRUNCATE statement 04:04
  • 33: SQL: 5f COMMENT in query 00:54
  • 34: SQL: 5g RENAME 01:41
  • 35: SQL: 6a Create Database user 03:54
  • 36: SQL: 6b GRANT permissions 06:09
  • 37: SQL: 6c REVOKE permissions 04:10
  • 38: SQL: 7a Section Introduction 01:13
  • 39: SQL: 7b SQL Statement basic 03:18
  • 40: SQL: 7c SELECT Statement 07:23
  • 41: SQL: 7d SELECT DISTINCT 02:42
  • 42: SQL: 7e SELECT with column headings 02:34
  • 43: SQL: 7f Column AS statement 02:05
  • 44: SQL: 8a SELECT WHERE Clause – theory 03:40
  • 45: SQL: 8b SELECT WHERE Clause – practical 07:15
  • 46: SQL: 9a Sum() 08:00
  • 47: SQL: 9b Min()-Max() 05:47
  • 48: SQL: 10a Order By statement 05:25
  • 49: SQL: 10b SELECT TOP clause in SQL 04:05
  • 50: SQL: 10c BETWEEN command 08:08
  • 51: SQL: 10d IN operator 04:04
  • 52: SQL: 10e Wildcard Characters and LIKE 04:53
  • 53: SQL: 11a Section Introduction 01:10
  • 54: SQL: 11b Group by – theory 03:11
  • 55: SQL: 11c Group by – practical 05:28
  • 56: SQL: 11d HAVING statement 03:32
  • 57: SQL: 12a Overview of Joins 01:56
  • 58: SQL: 12b What are Joins 02:15
  • 59: SQL: 12c Inner join 07:55
  • 60: SQL: 12d Left outer join 02:49
  • 61: SQL: 12e Right outer join 02:18
  • 62: SQL: 12f Full outer join 01:21
  • 63: SQL: 12g Union 02:46
  • 64: SQL: 12h Cross join 03:10
  • 65: SQL: 12i Query Exercise 01:05
  • 66: SQL: 12j Solution for Query Exercise 01:08
  • 67: SQL: 13a Section introduction 00:54
  • 68: SQL: 13b Check constraint 06:54
  • 69: SQL: 13c NOT NULL constraint 08:28
  • 70: SQL: 13d UNIQUE constraint 05:02
  • 71: SQL: 14a Creating Views 03:58
  • 72: SQL: 14b Reporting with multiple tables 03:05
  • 73: SQL: 15a Section Introduction 00:51
  • 74: SQL: 15b Timestamp 04:26
  • 75: SQL: 15c Extract from timestamp 03:11
  • 76: SQL: 15d Mathematical scalar functions 03:50
  • 77: SQL: 15e String functions 04:55
  • 78: SQL: 15f Sub Query 03:09
  • 79: SQL: 15g SELECT with calculations 06:18
  • 80: SQL: 16a Create stored procedure 04:36
  • 81: SQL: 16b Stored procedure with parameter 04:29
  • 82: SQL: 17a Section Introduction 01:07
  • 83: SQL: 17b Import Flat File 05:03
  • 84: SQL: 17c Import .csv or excel file 02:40
  • 85: SQL: 17d Export Data to Excel or any format 06:08
  • 86: SQL: 18a Section Introduction 00:59
  • 87: SQL: 18b Creating Database backup 03:51
  • 88: SQL: 18c Restoring Database backup 03:34

• Way to GO! 00:11

  • 89: Way to GO! 00:11

• Course 02: Master SQL Database Queries 7:18:03

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

• Course 03: SQL Programming with MySQL Database 5:48:48

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

• Claim Your Free Accredited Certificate 01:00

  • 276: Claim Your Free Accredited Certificate 01:00

This SQL bundle comes up with the following courses:

➥ Course 01: Microsoft SQL Server Bootcamp 2024

• Delve into the latest features and capabilities of Microsoft SQL Server, learning SQL setup, administration, and security best practices.
• Explore SQL Server's tools and services that facilitate data management, querying, and optimization for advanced analytics.

➥ Course 02: Master SQL Database Queries

• Focus on advanced SQL query writing, including complex joins, subqueries, and window functions, to manipulate and extract data efficiently.
• Learn how to optimize SQL queries for performance, which is critical for handling large-scale data operations in analytics and visualization projects.

➥ Course 03: SQL Programming with MySQL Database

• Intensive training in SQL programming within the MySQL environment, emphasizing its use in data science and analytics.
• Study MySQL-specific features like indexing, stored procedures, and triggers to improve database performance and analytic capabilities.

• SQL Developer: Yearly £40,000 to £50,000 approx.
• SQL Database Administrator: Yearly £40,000 to £60,000 approx.
• SQL Data Analyst: Yearly £20,000 to £40,000 approx.

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