Skip to content

SQL Developer ( Complete Database MySQL Programming ) - CPD Certified

3 Courses Bundle | Microsoft SQL | SSMS | MySQL | CPDQE Accredited | Easy refund | Instant Access


Skill Arts

Summary

Price
Save 19%
£12 inc VAT (was £14.99)
Offer ends 31 July 2025
Study method
Online, On Demand What's this?
Duration
19.3 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Accredited Certificate on SQL Developer Course From SkillArts - Free
  • Reed Courses Certificate of Completion - Free
  • Reference Letter - £3
Additional info
  • Tutor is available to students

8 students purchased this course

Add to basket or enquire

Overview

Why Study This SQL Developer Course?

  • Similar to ASP.NET, SQL skills are in high demand. According to Reed (as of May 2024), there are over 40,000 SQL developer jobs advertised in the UK alone.
  • A study by Reed states that SQL Developers in the UK command an average salary of £58,000 per year (as of May 2024).

After Completing this course you will be able to know:

  • Building and maintaining of real-time and batch reporting systems
  • Development of SQL Server and SSRS elements
  • Full knowledge of SSMS, Microsoft SQL, MySQL
  • Data provisioning etc.

Learning Outcomes:

  • Master SQL syntax for powerful data manipulation and analysis.
  • Learn effective database design, maintenance, and optimization techniques.
  • Gain hands-on experience with MySQL, honing your skills in database programming.

CPDQE Accreditation

This SQL Developer - Certified Course is CPDQE accredited. CPD is a globally recognised parameter for continuous professional development acknowledged by thousands of professional bodies, employers and academic institutions in the UK and around the world.

Dual Certificates

After completing this SQL Programming Course, you will receive a course completion certificate from Reed. Also, you will receive an Accredited Certificate of Completion From SkillArts.

Certificates

Accredited Certificate on SQL Developer Course From SkillArts

Digital certificate - Included

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Reference Letter

Digital certificate - £3

Curriculum

4
sections
276
lectures
19h 19m
total
    • 1: SQL: Introduction 03:28
    • 2: SQL: Course Curriculum 06:55
    • 3: SQL: How to get course requirements 01:41
    • 4: Care for a feedback 01:00 PDF
    • 5: SQL: Getting started on Windows, Linux or Docker 00:57
    • 6: SQL: How to ask great questions 01:19
    • 7: SQL: FAQ’s 01:08
    • 8: SQL: source code file 08:47
    • 9: SQL: Section Introduction 01:42
    • 10: SQL: Microsoft SQL Server Installation 18:34
    • 11: SQL: SQL Server Management Studio (SSMS) Installation 08:28
    • 12: SQL: How to connect MS SQL (Windows Authentication) 03:40
    • 13: SQL: How to connect MS SQL (SQL Server Authentication) 03:13
    • 14: SQL: Download and Restore Sample Database 07:26
    • 15: SQL: Section Introduction 01:16
    • 16: SQL: Overview of Databases 10:47
    • 17: SQL: Creating Database 04:54
    • 18: SQL: SQL Data Types 03:23
    • 19: SQL: Column Data Types on SSMS 03:55
    • 20: SQL: Creating Table 09:09
    • 21: SQL: Overview of Primary Key and Foreign Key 04:04
    • 22: SQL: Primary Key 04:05
    • 23: SQL: Foreign Key 06:51
    • 24: SQL: Creating Temporary tables 06:29
    • 25: SQL: Section Introduction 00:48
    • 26: SQL: Insert statement 08:25
    • 27: SQL: Update statement 05:06
    • 28: SQL: Delete statement 03:12
    • 29: SQL: Section Introduction 00:54
    • 30: SQL: CREATE table statement 02:58
    • 31: SQL: DROP statement 02:10
    • 32: SQL: ALTER statement 05:27
    • 33: SQL: TRUNCATE statement 04:04
    • 34: SQL: COMMENT in query 00:54
    • 35: SQL: RENAME 01:41
    • 36: SQL: Create Database user 03:54
    • 37: SQL: GRANT permissions 06:09
    • 38: SQL: REVOKE permissions 04:10
    • 39: SQL: Section Introduction 01:13
    • 40: SQL: SQL Statement basic 03:18
    • 41: SQL: SELECT Statement 07:23
    • 42: SQL: SELECT DISTINCT 02:42
    • 43: SQL: SELECT with column headings 02:34
    • 44: SQL: Column AS statement 02:05
    • 45: SQL: SELECT WHERE Clause – theory 03:40
    • 46: SQL: SELECT WHERE Clause – practical 07:15
    • 47: SQL: Sum() 08:00
    • 48: SQL: Min()-Max() 05:47
    • 49: SQL: Order By statement 05:25
    • 50: SQL: SELECT TOP clause in SQL 04:05
    • 51: SQL: BETWEEN command 08:08
    • 52: SQL: IN operator 04:04
    • 53: SQL: Wildcard Characters and LIKE 04:53
    • 54: SQL: Section Introduction 01:10
    • 55: SQL: Group by – theory 03:11
    • 56: SQL: Group by – practical 05:28
    • 57: SQL: HAVING statement 03:32
    • 58: SQL: Overview of Joins 01:56
    • 59: SQL: What are Joins 02:15
    • 60: SQL: Inner join 07:55
    • 61: SQL: Left outer join 02:49
    • 62: SQL: Right outer join 02:18
    • 63: SQL: Full outer join 01:21
    • 64: SQL: Union 02:46
    • 65: SQL: Cross join 03:10
    • 66: SQL: Query Exercise 01:05
    • 67: SQL: Solution for Query Exercise 01:08
    • 68: SQL: Section introduction 00:54
    • 69: SQL: Check constraint 06:54
    • 70: SQL: NOT NULL constraint 08:28
    • 71: SQL: UNIQUE constraint 05:02
    • 72: SQL: Creating Views 03:58
    • 73: SQL: Reporting with multiple tables 03:05
    • 74: SQL: Section Introduction 00:51
    • 75: SQL: Timestamp 04:26
    • 76: SQL: Extract from timestamp 03:11
    • 77: SQL: Mathematical scalar functions 03:50
    • 78: SQL: String functions 04:55
    • 79: SQL: Sub Query 03:09
    • 80: SQL: SELECT with calculations 06:18
    • 81: SQL: Create stored procedure 04:36
    • 82: SQL: Stored procedure with parameter 04:29
    • 83: SQL: Section Introduction 01:07
    • 84: SQL: Import Flat File 05:03
    • 85: SQL: Import .csv or excel file 02:40
    • 86: SQL: Export Data to Excel or any format 06:08
    • 87: SQL: Section Introduction 00:59
    • 88: SQL: Creating Database backup 03:51
    • 89: SQL: Restoring Database backup 03:34
    • 90: SQL: Introduction 02:56
    • 91: SQL: How to get course requirements 02:31
    • 92: SQL: Getting started on Windows, Linux or Docker 00:57
    • 93: SQL: How to ask great questions 01:19
    • 94: SQL: FAQ’s 01:08
    • 95: SQL: Section Introduction 01:42
    • 96: SQL: Microsoft SQL Server Installation 18:34
    • 97: SQL: SQL Server Management Studio (SSMS) Installation 08:28
    • 98: SQL: How to connect MS SQL (Windows Authentication) 03:40
    • 99: SQL: How to connect MS SQL (SQL Server Authentication) 03:13
    • 100: SQL: Download and Restore Sample Database 07:26
    • 101: SQL: What is Azure Data Studio 06:25
    • 102: SQL: Azure Data Studio Installation steps 07:08
    • 103: SQL: Azure Data Studio to Connect SQL Server 09:00
    • 104: SQL: Create a Database 06:32
    • 105: SQL: Create a Table 08:46
    • 106: SQL: Insert Data rows 06:36
    • 107: SQL: view the Data returned by Query 03:05
    • 108: SQL: Section Introduction 01:16
    • 109: SQL: Overview of Databases 10:47
    • 110: SQL: Creating Database 04:54
    • 111: SQL: SQL Data Types 03:23
    • 112: SQL: Column Data Types on SSMS 03:55
    • 113: SQL: Creating Table 09:09
    • 114: SQL: Overview of Primary Key and Foreign Key 04:04
    • 115: SQL: Primary Key 04:05
    • 116: SQL: Foreign Key 06:51
    • 117: SQL: Creating Temporary tables 06:29
    • 118: SQL: Section Introduction 00:48
    • 119: SQL: Insert statement 08:25
    • 120: SQL: Update statement 05:06
    • 121: SQL: Delete statement 03:12
    • 122: SQL: Section Introduction 00:54
    • 123: SQL: CREATE table statement 02:58
    • 124: SQL: DROP statement 02:10
    • 125: SQL: ALTER statement 05:27
    • 126: SQL: TRUNCATE statement 04:04
    • 127: SQL: COMMENT in query 00:54
    • 128: SQL: RENAME 01:41
    • 129: SQL: Create Database user 03:54
    • 130: SQL: GRANT permissions 06:09
    • 131: SQL: REVOKE permissions 04:10
    • 132: SQL: Section Introduction 01:13
    • 133: SQL: SQL Statement basic 03:18
    • 134: SQL: SELECT Statement 07:23
    • 135: SQL: SELECT DISTINCT 02:42
    • 136: SQL: SELECT with column headings 02:34
    • 137: SQL: Column AS statement 02:05
    • 138: SQL: SELECT WHERE Clause – theory 03:40
    • 139: SQL: SELECT WHERE Clause – practical 07:15
    • 140: SQL: Sum() 08:00
    • 141: SQL: Min()-Max() 05:47
    • 142: SQL: Order By statement 05:25
    • 143: SQL: SELECT TOP clause in SQL 04:05
    • 144: SQL: BETWEEN command 08:08
    • 145: SQL: IN operator 04:04
    • 146: SQL: Wildcard Characters and LIKE 04:53
    • 147: SQL: Section Introduction 01:10
    • 148: SQL: Group by – theory 03:11
    • 149: SQL: Group by – practical 05:28
    • 150: SQL: HAVING statement 03:32
    • 151: SQL: Overview of Joins 01:56
    • 152: SQL: What are Joins 02:15
    • 153: SQL: Inner join 07:55
    • 154: SQL: Left outer join 02:49
    • 155: SQL: Right outer join 02:18
    • 156: SQL: Full outer join 01:21
    • 157: SQL: Union 02:46
    • 158: SQL: Cross join 03:10
    • 159: SQL: Query Exercise 01:05
    • 160: SQL: Solution for Query Exercise 01:08
    • 161: SQL: Section introduction 00:54
    • 162: SQL: Check constraint 06:54
    • 163: SQL: NOT NULL constraint 08:28
    • 164: SQL: UNIQUE constraint 05:02
    • 165: SQL: Creating Views 03:58
    • 166: SQL: Reporting with multiple tables 03:05
    • 167: SQL: Section Introduction 00:51
    • 168: SQL: Timestamp 04:26
    • 169: SQL: Extract from timestamp 03:11
    • 170: SQL: Mathematical scalar functions 03:50
    • 171: SQL: String functions 04:55
    • 172: SQL: Sub Query 03:09
    • 173: SQL: SELECT with calculations 06:18
    • 174: SQL: Create stored procedure 04:36
    • 175: SQL: Stored procedure with parameter 04:29
    • 176: SQL: Installing SandDance Extension 02:36
    • 177: SQL: Visualization Charts 04:56
    • 178: SQL: Multiple Table Data Charts 06:01
    • 179: SQL: Type Decision for Data Analysis 13:01
    • 180: SQL: Data Analysis with Case Statement and String Text 09:14
    • 181: SQL: Section Introduction 01:07
    • 182: SQL: Import Flat File 05:03
    • 183: SQL: Import .csv or excel file 02:40
    • 184: SQL: Export Data to Excel or any format 06:08
    • 185: SQL: Section Introduction 00:59
    • 186: SQL: Creating Database backup 03:51
    • 187: SQL: Restoring Database backup 03:34
    • 188: SQL: Introduction 02:22
    • 189: SQL: How to get course requirements 01:23
    • 190: SQL: Getting started on Windows, Linux or Mac 00:48
    • 191: SQL: How to ask great questions 01:27
    • 192: SQL: FAQ’s 01:02
    • 193: SQL: source code file 08:47
    • 194: SQL: Section Introduction 01:07
    • 195: SQL: MySQL Server Installation 13:44
    • 196: SQL: Connect MySQL Server Instance 05:49
    • 197: SQL: MySQL Workbench overview 10:41
    • 198: SQL: Download and Restore Sample Database 07:43
    • 199: SQL: Section Introduction 01:09
    • 200: SQL: Overview of Databases 09:15
    • 201: SQL: Creating Database 06:34
    • 202: SQL: SQL Data Types 03:47
    • 203: SQL: Column Data Types on Workbench 07:23
    • 204: SQL: Creating Table 03:44
    • 205: SQL: Overview of Primary and Foreign Key 03:29
    • 206: SQL: Primary Key 06:08
    • 207: SQL: Foreign Key 11:33
    • 208: SQL: Creating Temporary tables 12:23
    • 209: SQL: EER – Enhanced Entity Relationship Diagrams 04:21
    • 210: SQL: Section Introduction 01:17
    • 211: SQL: Insert statement 07:12
    • 212: SQL: Update statement 06:02
    • 213: SQL: Delete statement 03:13
    • 214: SQL: Section Introduction 01:11
    • 215: SQL: CREATE table statement 07:51
    • 216: SQL: DROP statement 02:58
    • 217: SQL: ALTER statement 04:54
    • 218: SQL: TRUNCATE statement 03:02
    • 219: SQL: COMMENT in query 02:22
    • 220: SQL: RENAME table 03:15
    • 221: SQL: Create Database user 03:16
    • 222: SQL: GRANT permissions 05:06
    • 223: SQL: REVOKE permissions 03:46
    • 224: SQL: Section Introduction 00:56
    • 225: SQL: SQL Statement basic 03:16
    • 226: SQL: SELECT Statement 03:12
    • 227: SQL: SELECT DISTINCT 01:30
    • 228: SQL: SELECT with column headings 01:27
    • 229: SQL: Column AS statement 02:21
    • 230: SQL: DASHBOARD Analytics 06:04
    • 231: SQL: SELECT WHERE Clause – theory 03:03
    • 232: SQL: SELECT WHERE Clause – practical 06:16
    • 233: SQL: Sum() 06:20
    • 234: SQL: Min()-Max() 02:40
    • 235: SQL: Order By statement 04:43
    • 236: SQL: SELECT TOP 3 records 01:43
    • 237: SQL: BETWEEN command 05:45
    • 238: SQL: IN operator 02:57
    • 239: SQL: Search Data using LIKE cards 04:35
    • 240: SQL: Section Introduction 00:43
    • 241: SQL: Group by – theory 03:34
    • 242: SQL: Data Analytics with Group By 03:59
    • 243: SQL: HAVING statement 03:01
    • 244: SQL: Overview of Joins 02:01
    • 245: SQL: What are Joins 02:18
    • 246: SQL: Inner join 06:43
    • 247: SQL: Left outer join 02:04
    • 248: SQL: Right outer join 01:53
    • 249: SQL: Union 02:54
    • 250: SQL: CERTESIAN Product or Cross Join 03:14
    • 251: SQL: Query Exercise 01:16
    • 252: SQL: Solution for Query Exercise 01:02
    • 253: SQL: Section introduction 01:23
    • 254: SQL: Check constraint 08:32
    • 255: SQL: NOT NULL constraint 02:45
    • 256: SQL: UNIQUE constraint 05:53
    • 257: SQL: Creating Views 03:25
    • 258: SQL: Data Analytic Views from multiple tables 03:14
    • 259: SQL: Section Introduction 01:02
    • 260: SQL: Timestamp 03:10
    • 261: SQL: Extract from timestamp 03:01
    • 262: SQL: : Mathematical scalar functions 02:35
    • 263: SQL: String functions 07:14
    • 264: SQL: Advanced functions 03:58
    • 265: SQL: Sub Queries 03:11
    • 266: SQL: SELECT with calculations 04:44
    • 267: SQL: Create stored procedure 05:39
    • 268: SQL: Stored procedure with parameter 03:19
    • 269: SQL: Drop Procedure 01:20
    • 270: SQL: Section Introduction 01:08
    • 271: SQL: Import .csv file 04:07
    • 272: SQL: Export Data to .csv file 02:13
    • 273: SQL: Section Introduction 00:44
    • 274: SQL: Creating Database backup 02:28
    • 275: SQL: Restoring Database backup 02:09
    • 276: Claim Your Free Certificate 01:00 PDF

Course media

Description

This bundle comes up with the following courses:

Course 01: Microsoft SQL Server Bootcamp 2024 This course provides a comprehensive overview of Microsoft SQL Server, a powerful relational database management system. Learn how to design and administer databases, write SQL queries, and optimize database performance using Microsoft SQL Server.

Course 02: Master SQL Database Queries Delve into the intricacies of SQL database querying in this advanced course. Explore techniques for retrieving and manipulating data from databases using SQL commands. Gain practical experience through hands-on exercises and real-world examples.

Course 03: SQL Programming with MySQL Database Focus specifically on SQL programming with MySQL, a widely used open-source relational database management system. Learn how to work with MySQL databases, write SQL queries, and develop database-driven applications. Gain insights into MySQL features and functionalities to effectively manage data and optimize performance.

Who is this course for?

  • Data Analysts and Business Analysts
  • Database Administrators (DBAs)
  • Developers
  • IT Professionals

Career path

  • SQL Developer
  • Data Analyst
  • MySQL Developer

Questions and answers

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

Reviews

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

FAQs

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 2025. All rights reserved.