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
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.
0/10
Querying One or Two Tables
00:09
Table Joins
00:00
The Where Clause
00:00
Date and Time Functions
00:00
The Case Statement
00:00
Aggregation and Grouping
00:00
String Handling, Cast & Convert and Data Types
00:00
Number Calculations
00:00
Nulls
00:00
Combining Datasets
00:00
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
00:55
CTEs and Temp Tables
00:00
Variables and Parameters
00:00
Window Functions
00:00
Views
00:00
Temp Tables and Data Manipulation
00:00
The PIVOT and UNPIVOT Commands
00:00
Recursive CTEs
00:00
Superhero Challenge Zone Part 2
00:00
Superhero Challenge Zone Part 2 – Solutions
00:00
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
00:00
Reports and Stored Procedures
00:00
Scalar User Defined Functions
00:00
Table Valued UDFs and the APPLY Command
00:00
Data Warehousing, ETL and SPs
00:00
Indexing Overview
00:00
Performance and Optimisation Overview
00:00
Collation
00:00
Loops and Dynamic SQL
00:00
Superhero Challenge Zone Part 3
00:00
Superhero Challenge Zone Part 3 Solutions
00:00
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
00:00
Some Additional Cool Commands
00:00
Inner Joining onto a Left Join
00:00
SQL Career Spotlight – Data Migration
00:00
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
00:00
An Age Old Problem
00:00
Joins and WHERE review
00:00
12 Days of Christmas
00:00
SQL Superhero Training Program for Businesses
    About Lesson

    Ok let’s dive in. In this tutorial I explain how to get started querying a database and selecting data from one table, and then two tables joined together.

    This video is 31 minutes, plus there are three challenges so I’d suggest giving yourself 60-90 minutes or so to get through this one. I saved my notes and the challenge solutions, and these can be downloaded from this page, but these are only there for your reference. It is important that you code along with me and try to figure it out for yourself.

    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.