Skip to content
  1. Online
  2. Coding
  3. MySQL
SQL Programming with MySQL Database for Data Science, Data Analytics & Data Visualization cover image

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

Accredited Certificate from LearnDrive | Instant Access | 03 Courses Bundle

Summary

Price
Save 21%
£15 inc VAT (was £19)
Offer ends 31 July 2026
Study method
Online, On Demand 
Course format
275 Videos (with subtitles and transcripts) and 2 PDFs
Duration
19.3 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Accredited Certificate from LearnDrive - Free
  • Reed Courses Certificate of Completion - Free
  • Learndrive Special Bundle Certificate - £7
Additional info
  • Tutor is available to students
6 students purchased this course

Add to basket or enquire

Overview

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.

Certificates

Curriculum

This course contains

Format: 275 Videos (with subtitles and transcripts) and 2 PDFs

Duration: 19h and 20m

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

    • 90: Way to GO! 00:11

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

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

    • 277: Claim Your Free Accredited Certificate 01:00

Description

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.

Career path

  • 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.

Questions and answers

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

Ask a question

Reviews

Currently there are no reviews for this course. Be the first to leave a review.

Leave a review

Legal information

This course is advertised on Reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.

FAQs

Study method describes the format in which the course will be delivered. At Reed Courses, courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on Reed Courses, many of which can be completed online.

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body's logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.
View all
Similar subjects: MySQL, SQL, Coding
Related searches: Data science courses, Data analysis courses, Database courses, Online courses

Interest free credit agreements provided by Zopa Bank Limited trading as DivideBuy are not regulated by the Financial Conduct Authority and do not fall under the jurisdiction of the Financial Ombudsman Service. Zopa Bank Limited trading as DivideBuy is authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority, and entered on the Financial Services Register (800542). Zopa Bank Limited (10627575) is incorporated in England & Wales and has its registered office at: 1st Floor, Cottons Centre, Tooley Street, London, SE1 2QG. VAT Number 281765280. DivideBuy's trading address is First Floor, Brunswick Court, Brunswick Street, Newcastle-under-Lyme, ST5 1HH. © Zopa Bank Limited 2026. All rights reserved.