Skip to content
  1. Online
  2. Coding
  3. MySQL
Database Developer ( Data Analyst, SQL Expert ) - Accredited Course cover image
Play overlay
Preview this course

Database Developer ( Data Analyst, SQL Expert ) - Accredited Course
Empower UK Employment Training

100% Pass Rate | Assignment Available | Free Certificate | Lifetime Course Access

Summary

Price
£15.50 inc VAT
Study method
Online, On Demand 
Course format
275 Videos (with subtitles and transcripts), 7 PDFs, 2 Articles, 2 Resources and 2 Quizzes
Duration
19.9 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Empower UK Accredited Certificate - Free
  • Reed Courses Certificate of Completion - Free
  • CPDQE Certificate and Transcript - £12
Additional info
  • Tutor is available to students
29 students purchased this course

Add to basket or enquire

Overview

SQL for Data Science + Data Analytics + Data Visualization and SQL Server Bootcamp 2024

Enter the world of databases with our comprehensive course package: SQL for Data Science + Data Analytics + Data Visualization and SQL Server Bootcamp 2024. This course is designed to equip you with a mastery of SQL, from foundational server management to advanced data manipulation and analysis using SQL Server and MySQL.

Learning Outcomes

  • Gain a robust understanding of SQL Server management and administration to support SQL-driven data science applications.
  • Develop expert-level SQL querying skills to extract and manipulate data effectively for analytical purposes.
  • Enhance your SQL programming capabilities in MySQL, focusing on creating efficient database solutions for data science and analytics.

Key Employment Opportunities:

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

More Benefits:

  • Assignment on the SQL Bootcamp 2024 course
  • Free Digital Reed Certificate on SQL Bootcamp 2024 course
  • Discount and Offer on Other Certificates
  • Compatible with iPhone & Android Devices
  • Moneyback Guarantee

Certificates

Curriculum

This course contains

Format: 275 Videos (with subtitles and transcripts), 7 PDFs, 2 Articles, 2 Resources and 2 Quizzes

Duration: 19h and 55m

    • 1: SQL: Introduction Preview 03:28
    • 2: SQL: Course Curriculum Preview 06:55
    • 3: SQL: How to get course requirements 01:41
    • 4: SQL: Getting started on Windows, Linux or Docker 00:57
    • 5: SQL: How to ask great questions 01:19
    • 6: SQL: FAQ’s Preview 01:08
    • 7: SQL: Source code file Preview 08:47
    • 8: SQL: Section Introduction 01:42
    • 9: SQL: Microsoft SQL Server Installation 18:34
    • 10: SQL: SQL Server Management Studio (SSMS) Installation 08:28
    • 11: SQL: How to connect MS SQL (Windows Authentication) 03:40
    • 12: SQL: How to connect MS SQL (SQL Server Authentication) 03:13
    • 13: SQL: Download and Restore Sample Database 07:26
    • 14: SQL: Section Introduction 01:16
    • 15: SQL: Overview of Databases 10:47
    • 16: SQL: Creating Database 04:54
    • 17: SQL: SQL Data Types 03:23
    • 18: Time for Survey 01:00
    • 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: Instructions for Taking the Exam 01:00
    • 91: Assignment Worksheet 02:00
    • 92: Submit Your Assignment 01:00

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

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

    • 283: Ordering CPDQE Certificate and Transcript is Optional 01:00
    • 284: Order CPDQE Certificate and Transcript 01:00

Course media

Description

Key Lesson Snippets:

➥ Course 01: Microsoft SQL Server Bootcamp 2024
This intensive bootcamp introduces you to Microsoft SQL Server 2024, focusing on the setup, maintenance, and security of SQL Server environments. Learn SQL server architecture, indexing, and query optimization to ensure efficient data management and retrieval, essential for supporting large-scale data science applications.

➥ Course 02: Master SQL Database Queries
Master advanced SQL database querying techniques to handle complex data analysis tasks. This course covers a wide range of SQL commands and functions to perform data aggregation, filtering, and transformation, preparing you for roles that require high-level data analytics skills.

➥ Course 03: SQL Programming with MySQL Database
Delve into SQL programming for MySQL, a popular database for web and server applications. You will learn to write sophisticated SQL scripts and statements that facilitate data analysis, reporting, and integration, crucial for leveraging data in real-world data science and analytics scenarios.

Who is this course for?

  • SQL Developer
  • Data Analyst
  • MySQL Developer

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

  • OCR Level 3 Qualification in Advanced Database Design and Development (QCF)

  • OCR Level 3 Qualification in Relational Databases (QCF)

  • AQA Level 3 Award in Database Design and Development (QCF)

  • AQA Level 3 Certificate in Database Design and Development (QCF)

Questions and answers

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

Ask a question

Reviews

3.8
Course rating
80%
Service
80%
Content
70%
Value

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 analysis courses, Database courses, Analytics courses, Online courses

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: Zopa Bank, Level 12, 20 Water Street, Canary Wharf, London E14 5GX. VAT Number 281765280.