Modules
Data Analyst
Data Engineer
Product Data Scientist
AI Engineer
Machine Learning Engineer
Prompt Engineer
We will learn a lot of stuff in the Expert Level and you will have all what is needed to master SQL:
Shall we?
Intro to Window Functions
Using Window Function for Aggregate Functions
Running Total Salary by Job Title
Earliest Join Date for Each Job Title
Using the Frame Clause
Frame Clause in SQL
Maximum Spend Within Each User Region
Number of Orders and Cumulative Sum
Average Order Amount Window
Using ROW_NUMBER
Top Product by Department
First Order Details
Using RANK() and DENSE_RANK()
Top 2 Sold Products
Leaderboard Soccer Ranking
Top Watched Videos
Using LAG and LEAD
MoM Change in Revenue
Revenue Change by Product Vertical
Congratulations
What are percentiles
Using Percentiles
Median Salary
Median Salaries By Company
Top Companies by Highest 5% Salaries
Using PERCENT_RANK
Top 5% Users List
Top 10% For Each Country
Congratulations
Intro to Text Analysis
Using LEFT, RIGHT and LENGTH
First Letter Extraction
Last 4 Digits of your SSN
Middle Part of the SSN
Find The Longest Names
Using TRIM
Cleaning Product Names
Most Frequently Entered Products
Using CONCAT
Full Name Creation
Linkedin URL
Using String Aggregation
Product Lists by Sale ID
Unique Product List by Country
Unnesting
Twitter Hashtag Analysis
Top 3 Hashtags
Congratulations