Skip to content
Play overlay
Preview this course

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

100% Pass Rate | Assignment Included in Course Price | Free Certificate | Lifetime Course Access

Empower UK Employment Training

Summary

Price
£15 inc VAT
Study method
Online, On Demand What's this?
Duration
19.9 hours · Self-paced
Qualification
No formal qualification
Certificates
  • Empower UK Diploma Certificate - Free
  • Reed Courses Certificate of Completion - Free
Additional info
  • Tutor is available to students

Add to basket or enquire

Buy with Apple Pay Buy with Google Pay

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
  • Compatible with iPhone & Android Devices
  • Moneyback Guarantee

Certificates

Empower UK Diploma Certificate

Digital certificate - Included

You must submit the assignment to order the Free Empower UK Diploma Certificate.
* Assessment Fee: £5

Reed Courses Certificate of Completion

Digital certificate - Included

Will be downloadable when all lectures have been completed.

Curriculum

5
sections
279
lectures
19h 53m
total

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

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

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

    • 275: SQL - Course Assignment 01:00
    • 276: Course Assignment Worksheet 10:00 PDF
    • 277: Empower UK Submit Your Assignment 01:00 PDF

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

Currently there are 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, Analytics courses, Online courses