Course Content
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.
0/4
Introduction to The SQL Superhero Program
03:17
Download and Install SQL Server
09:18
Set Up the Training Databases in SQL Server
07:37
Overview of the Databases
22:33
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.
0/11
Querying One or Two Tables
31:08
Table Joins
29:33
The WHERE Clause
32:37
Date and Time Functions
52:57
The Case Statement
39:53
Aggregation and Grouping
25:46
String Handling, Cast & Convert and Data Types
01:00:52
Number Calculations
36:24
Nulls
23:23
Combining Datasets
24:39
Superhero Challenge Zone
37:15
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.
0/10
Derived Tables and Subqueries
45:29
CTEs and Temp Tables
45:21
Variables and Parameters
31:37
Window Functions
46:49
Views
16:46
Temp Tables and Data Manipulation
30:30
The PIVOT and UNPIVOT Commands
25:14
Recursive CTEs
12:24
Superhero Challenge Zone Part 2
07:49
Superhero Challenge Zone Part 2 – Solutions
35:30
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.
0/11
The MERGE Statement
38:08
Reports and Stored Procedures
33:02
Scalar User Defined Functions
34:49
Table Valued UDFs and the APPLY Command
27:07
Data Warehousing, ETL and SPs
46:42
Indexing Overview
21:33
Performance and Optimisation Overview
25:51
Collation
10:01
Loops and Dynamic SQL
27:38
Superhero Challenge Zone Part 3
05:26
Superhero Challenge Zone Part 3 Solutions
59:22
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!
0/4
Bulk Insert from External CSV File
06:26
Some Additional Cool Commands
17:06
Inner Joining onto a Left Join
02:13
SQL Career Spotlight – Data Migration
12:02
Interview Preparation
If you're applying for jobs, then you'll have interviews. There's no need to be afraid, especially when you're fully prepared. Here's some vital information that help you get ready for those occasions.
0/5
SQL Technical Interview Assessment Types
05:10
The Verbal (Spoken) Interview
09:24
The Written Assessment
03:30
The Hands-On Technical Assessment
04:12
Online Assessments & General Interview Prep
08:38
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.
0/4
Atif’s Dilemma
03:42
An Age Old Problem
03:22
Joins and WHERE review
13:37
12 Days of Christmas
07:33
Epilogue
A farewell, and a few thoughts to send you on your way
0/1
Epilogue
10:03
SQL Superhero Program
About Lesson

In lesson one we saw a basic table join for extracting data from two related tables. We just used the word “JOIN”, but now I’m going to tell you not to do that. There are six table joins that we need to learn, and “JOIN” isn’t one of them!

Exercise Files
0202 Lesson Files.zip
Size: 1.45 KB
Previous
Next
0% Complete

The BI School by Nick Holt

Founded in 2022 by Nick Holt, The BI School offers a unique method for individuals and businesses to learn SQL.

Follow Us On:

Newsletter

Copyright © 2024 The BI School by Nick Holt. All rights reserved.