+233 54 123 9290
support@festman.io
Select a Language
.png)
.png)
Analyzing Unicorns Data with SQL
As a participant in this challenge, you will learn how to use SQL to extract valuable insights from real-world data.
82
Students
42
Lectures
Thomas Festus Cudjoe
Instructor
About This Course
Festus is a Senior Data Analyst, Finance Professional, and Chartered Accountant (CIMA & ICAG) with 7+ years of experience in analytics and business intelligence.
He specializes in Power BI, SQL, Python, financial modeling, and AI-driven analytics.
At FestMan, he delivers practical, project-based training in Excel, Power BI, Python, SQL, and Applied AI for work. Festus is a Microsoft Certified Trainer, Power BI Certified Analyst, Microsoft Excel Expert, and a 4x Microsoft Data Platform MVP.
Curriculum Overview
This course includes 14 modules, 42 lessons, and 1:34 hours of materials.
Project Overview and requirements
2 Parts | 0:11 Hours
Project Overview
Learn more about the project requirements
Study Duration
5 Minutes
Attachments
0
Download datasets and import it into SSMS
Download datasets and import it into SSMS
Study Duration
6 Minutes
Attachments
0
Lab 01: How many unicorn companies are there?
3 Parts | 0:07 Hours
Your Submission
Submit your work for Lab 1 below.
Study Duration
3 Minutes
Attachments
0
Solution: Video Explanation🔒
Volume
18.77 MB
Solution: Code and Explaination
Step by Step Explaination
Study Duration
4 Minutes
Attachments
0
Lab 02: What is the average valuation and funding amount for unicorn companies?
3 Parts | 0:04 Hours
Your Submission
Submit your work for Lab 2 below.
Study Duration
2 Minutes
Attachments
0
Solution: Video Explanation
Volume
11.83 MB
Solution: Code and Explaination
Step by step explaination
Study Duration
2 Minutes
Attachments
0
Lab 03: How many companies became unicorns each year?
3 Parts | 0:03 Hours
Your submission
Submit your work for Lab 3 below.
Study Duration
2 Minutes
Attachments
0
Solution: Video Explanation
Volume
17.05 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
1 Minutes
Attachments
0
Lab 04: Which companies became unicorns in 2022 and what are their valuations?
3 Parts | 0:04 Hours
Your submission
Submit your work for Lab 4 below.
Study Duration
3 Minutes
Attachments
0
Solution: Video Explanation
Volume
15.80 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
1 Minutes
Attachments
0
Lab 05: What was the most valuable unicorn each year?
4 Parts | 0:11 Hours
Your submission
Submit your work for Lab 5 below.
Study Duration
2 Minutes
Attachments
0
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
3 Minutes
Attachments
0
Solution: Video Explanation
Volume
19.21 MB
Solution: Video Explanation Approach 2
Video Explanation Approach 2
Study Duration
6 Minutes
Attachments
0
Lab 06: Which industries have the highest number of unicorn companies?
3 Parts | 0:06 Hours
Your submission
Submit your work for Lab 6 below.
Study Duration
2 Minutes
Attachments
0
Solution: Video Explanation
Volume
10.71 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
4 Minutes
Attachments
0
Lab 07: What percentage of unicorns are from each industry?
4 Parts | 0:11 Hours
Your submission
Submit your work for Lab 7 below.
Study Duration
2 Minutes
Attachments
0
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
4 Minutes
Attachments
0
Solution: Video Explanation🔒
Volume
32.69 MB
Solution: Video Explanation 2🔒
Solution: Video Explanation🔒
Study Duration
5 Minutes
Attachments
0
Lab 08: Which countries have produced the most unicorn companies?
3 Parts | 0:07 Hours
Your Submission
Submit your work for Lab 8 below.
Study Duration
3 Minutes
Attachments
0
Solution: Video Explaination 🔒
Volume
8.82 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
4 Minutes
Attachments
0
Lab 09: What is the most valuable company in each country?
4 Parts | 0:10 Hours
Your submission
Submit your work for Lab 9 below.
Study Duration
3 Minutes
Attachments
0
Solution: Video Explanation 🔒
Volume
12.75 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
4 Minutes
Attachments
0
Solution: Video Explanation 2🔒
Solution: Video Explanation 🔒
Study Duration
3 Minutes
Attachments
0
Lab 10: How many unicorn companies reached a $1 billion valuation within five years of being founded?
3 Parts | 0:06 Hours
Your submission
Submit your work for Lab 10 below.
Study Duration
2 Minutes
Attachments
0
Solution: Video Explanation 🔒
Volume
11.17 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
4 Minutes
Attachments
0
Lab 11: Are there any cities emerging as FinTech hubs?
3 Parts | 0:07 Hours
Your Submission
Submit your work for Lab 11 below.
Study Duration
3 Minutes
Attachments
0
Solution: Video Explanation 🔒
Volume
12.75 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
4 Minutes
Attachments
0
Lab 12: Determine the Year on year growth in the number of unicorns.
3 Parts | 0:07 Hours
Your Submission
Submit your work for Lab 12 below.
Study Duration
2 Minutes
Attachments
0
Solution: Video Explanation 🔒
Volume
40.55 MB
Solution: Code and Explaination
Solution: Code and Explaination
Study Duration
5 Minutes
Attachments
0
Graded Assessment
1 Parts
Unicorns Qualified Assessment
Questions
4
Duration
Minutes
Passing Grade
40/40
Total Grade
40
Attempts
0/3
Certificates
1 Parts
Course Certificate
Course Certificate
If you pass all the lessons in this course, you will receive this certificate.
Type
Course Certificate
0
0 Reviews
Content Quality (0)
Instructor Skills (0)
Value for Money (0)
Support Quality (0)
Course Specifications
Sections
14
Lessons
42
Capacity
Unlimited
Duration
1:30 Hours
Students
82
Created Date
24 Sep 2023
Updated Date
13 Dec 2025
.png)
.png)
Send Course as Gift
Send as a gift to friends
You are viewing
Analyzing Unicorns Data with SQL
Subscribe to Our Newsletter
Receive expert insights, course updates, and learning resources directly in your inbox and get notified
Contact Us
© 2025 FestMan Learning. All Rights Reserved. Empowering digital pioneers.
.png)
.png)
Reply to Comment