SQL Superhero Training Program for Businesses

Instructor:

Nick Holt

Category:

SQL

Last Update:

August 30th, 2024

Ratings:

SQL Superhero Training Program for Businesses

About Course

Elevate Your Team’s Performance with Bespoke SQL Training

The SQL Superhero Program was created for teams of data analysts, business intelligence analysts and developers, trainee data engineers and software developers who need to learn SQL, an essential skill for working with data.

What Can You Do with SQL?

For anyone who works with data, SQL knowledge is a must. Many fields and disciplines use this language to manage and maintain data in relational databases. With SQL, you can extract data from complex databases, filter, clean, manipulate and aggregate the data, then feed it into a third party tool like Power BI, Tableau or Excel.

SQL is an integral tool in creating data pipelines to move data from one place to another, and is at the heart of data management, data analysis and data processing.

Topics of the program

Wake
Ok, let's get started, but before we can start learning SQL, we need to download and install the software. It's a thing called SQL Server Management Studio and it's one of the most widely used database systems on the planet. Are you ready? Then let's dive in.

Introduction to The SQL Superhero Program
00:00
Download and Install SQL Server
00:55
Set up Databases in SQL Server
00:00
Overview of the Databases
00:00

Walk
Let's learn some SQL. We'll begin with some simple stuff, and by the end of this module, you'll be well on your way. Each lesson contains challenges to make sure you're on track. Don't forget to jump on those group calls for additional support or if you have any questions.

Run
We're really getting into this now. By the mid point in this module, you'll have reached the point where you could pass a technical interview assessment. Keep going, and get yourself on those group calls if you have any questions.

Fly
There's some quite advanced topics in this module. You've smashed intermediate SQL, now you're flying! Again, please join the group calls to discuss any of these topics.

Soar
Now you've completed the core modules in the program, you can have a look at some additional resources to help you on your journey. You never stop learning you know!

Challenge Yourself
You never stop learning, and the best way to learn is by facing challenges. Here we've put together some nice tasty head-scratchers for you to have a think about. Any problems with these, and you can hop on those group calls. We look forward to seeing you there.

Student Ratings & Reviews

No Review Yet

Your Instructor

Nick Holt

SQL Coach and Mentor

Share This Course

SQL Superhero Training Program for Businesses

SQL Superhero Training Program for Businesses

About Course

Elevate Your Team’s Performance with Bespoke SQL Training

What Will You Learn?

Topics of the program

Wake Ok, let's get started, but before we can start learning SQL, we need to download and install the software. It's a thing called SQL Server Management Studio and it's one of the most widely used database systems on the planet. Are you ready? Then let's dive in.

Introduction to The SQL Superhero Program

Download and Install SQL Server

Set up Databases in SQL Server

Overview of the Databases

Walk Let's learn some SQL. We'll begin with some simple stuff, and by the end of this module, you'll be well on your way. Each lesson contains challenges to make sure you're on track. Don't forget to jump on those group calls for additional support or if you have any questions.

Querying One or Two Tables

Table Joins

The Where Clause

Date and Time Functions

The Case Statement

Aggregation and Grouping

String Handling, Cast & Convert and Data Types

Number Calculations

Nulls

Combining Datasets

Run We're really getting into this now. By the mid point in this module, you'll have reached the point where you could pass a technical interview assessment. Keep going, and get yourself on those group calls if you have any questions.

Derived Tables and Subqueries

CTEs and Temp Tables

Variables and Parameters

Window Functions

Views

Temp Tables and Data Manipulation

The PIVOT and UNPIVOT Commands

Recursive CTEs

Superhero Challenge Zone Part 2

Superhero Challenge Zone Part 2 – Solutions

Fly There's some quite advanced topics in this module. You've smashed intermediate SQL, now you're flying! Again, please join the group calls to discuss any of these topics.

The MERGE Statement

Reports and Stored Procedures

Scalar User Defined Functions

Table Valued UDFs and the APPLY Command

Data Warehousing, ETL and SPs

Indexing Overview

Performance and Optimisation Overview

Collation

Loops and Dynamic SQL

Superhero Challenge Zone Part 3

Superhero Challenge Zone Part 3 Solutions

Soar Now you've completed the core modules in the program, you can have a look at some additional resources to help you on your journey. You never stop learning you know!

Bulk Insert from External CSV File

Some Additional Cool Commands

Inner Joining onto a Left Join

SQL Career Spotlight – Data Migration

Challenge Yourself You never stop learning, and the best way to learn is by facing challenges. Here we've put together some nice tasty head-scratchers for you to have a think about. Any problems with these, and you can hop on those group calls. We look forward to seeing you there.

Atif’s Dilemma

An Age Old Problem

Joins and WHERE review

12 Days of Christmas

Student Ratings & Reviews

Your Instructor

Nick Holt

£1,250.00 per attendee

Requirements

Material Includes

Audience

Courses You May Like

SQL Superhero Program

The BI School by Nick Holt

Useful Links

Newsletter

Wake
Ok, let's get started, but before we can start learning SQL, we need to download and install the software. It's a thing called SQL Server Management Studio and it's one of the most widely used database systems on the planet. Are you ready? Then let's dive in.

Walk
Let's learn some SQL. We'll begin with some simple stuff, and by the end of this module, you'll be well on your way. Each lesson contains challenges to make sure you're on track. Don't forget to jump on those group calls for additional support or if you have any questions.

Run
We're really getting into this now. By the mid point in this module, you'll have reached the point where you could pass a technical interview assessment. Keep going, and get yourself on those group calls if you have any questions.

Fly
There's some quite advanced topics in this module. You've smashed intermediate SQL, now you're flying! Again, please join the group calls to discuss any of these topics.

Soar
Now you've completed the core modules in the program, you can have a look at some additional resources to help you on your journey. You never stop learning you know!

Challenge Yourself
You never stop learning, and the best way to learn is by facing challenges. Here we've put together some nice tasty head-scratchers for you to have a think about. Any problems with these, and you can hop on those group calls. We look forward to seeing you there.