The Unabridged SQL Algorithms Epic Bundle
Created by Team Mammoth
·
54 lectures
01
Skill level
All levels
02
Sections
5
03
Lectures
54
04
Instructor
Team Mammoth
What's inside
This course includes.
✓
5
Sections
✓
Certificate of completion
Included
✓
Mobile and desktop access
Included
✓
AI learning assistance
Included
Unlock all courses with our Subscription Bundle! Get unlimited access to entire course library, books and assets. Learn more and subscribe today!
Course content
Curriculum & lectures.
+ 00 Course Overview 1 lecture Preview
00 Course Overview
Locked
+ 01 Restrict and Soft Data Question 11 lectures
01-00 Build A Table And Display All Records
Locked
01-01 List Alphabetically
Locked
01-02 List All Not In Specified Range
Locked
01-03 List All In Range By Multiple Properties
Locked
01-04 Display All With Characters In Property
Locked
01-05 Select From Where In This And Not In That
Locked
01-06 List All With Exact Number Of Characters
Locked
01-07 List All With Specific Second Character
Locked
01-08 List All Distinct Ids Available
Locked
01-09 Calculate Percentage
Locked
01-10 Consecutive Numbers
Locked
+ 02 Join Data Questions 11 lectures
02-01 List Streams With Viewer Information
Locked
02-02 Join Two Tables
Locked
02-03 Find Same Value In Another Property
Locked
02-04 List Values Across Tables
Locked
02-05 Join Three Tables
Locked
02-06 Find Average Across Tables
Locked
02-07 Display Difference Across Tables
Locked
02-08 Find More Than Value Across Tables
Locked
02-09 Product Sales Analysis
Locked
02-10 List All After A Certain Date
Locked
02-11 Capital Gain Loss
Locked
+ 03 Aggregate Functions Questions 13 lectures
03-01 Count Distinct Properties
Locked
03-02 List Total Sum
Locked
03-03 Get Minimum
Locked
03-04 Get Maximum From A Distinct Type
Locked
03-05 Get Average And Count At An ID
Locked
03-06 Get Number Of Same Type
Locked
03-07 Get Difference Between Max And Min
Locked
03-08 Find Minimum Of Each Type
Locked
03-09 Get Sum At Each ID
Locked
03-10 Get Average For Each ID
Locked
03-11 Get Different Properties
Locked
03-12 List Where Maximum Is Greater Than
Locked
03-13 List Average Where Greater Than
Locked
+ 04 SubQuery Questions 18 lectures
04-01 Find Higher Values
Locked
04-02 Find All Of A Type
Locked
04-03 List All Above Average
Locked
04-04 List All Greater Than Minimum
Locked
04-05 List All Part Of Any
Locked
04-06 List All Who Have More
Locked
04-07 List All With Same As Minimum
Locked
04-08 List All Above Average In Their Group
Locked
04-09 Get Kth Maximum Value
Locked
04-10 Get Kth Minimum Value
Locked
04-11 Select Last K Records From A Table
Locked
04-12 List All Not In A Group
Locked
04-13 Get K Maximum Values
Locked
04-14 Get K Minimum Values
Locked
04-15 Products Never Sold
Locked
04-16 Winning Candidate
Locked
04-17 Search Across Three Tables
Locked
04-18 Find One Property In Another
Locked
Instructors
Taught by people who ship.
Team Mammoth
Instructor
Produced by a team of Mammoth Club industry experts. Over 14 years, Mammoth Club has built a global student community in 190+ countries with 9+ million courses sold, releasing over 1,000+ courses and 5,000+ hours of video content.
Ready to start building?
Join Mammoth Club and move through the course with structured lessons, previews, and certificates.