Trials Division
SwiftLink Training Program
B
0 pts
0/46 cleared
*bleep* Zero points. The clock is ticking, trainee.
Learning Path
0%
1Trial 1: DISTINCT Values2Trial 2: MAX & MIN3Trial 3: SUM & AVG4Trial 4: Multi-Column ORDER BY5Trial 5: Data Reconnaissance6Trial 6: BETWEEN Ranges7Trial 7: LIKE Pattern Matching8Trial 8: IN Operator9Trial 9: NULL Handling10Trial 10: COUNT DISTINCT11Trial 11: Conditional Counting12Trial 12: Compound WHERE Clauses13Trial 13: Date Part Extraction14Trial 14: Aggregate Strike15Trial 15: Multi-Column GROUP BY16Trial 16: Daily Price Range17Trial 17: String Functions18Trial 18: CAST & Type Conversion19Trial 19: COALESCE & Default Values20Trial 20: NOT IN Exclusion21Trial 21: Ratio & Division22Trial 22: Conditional Logic23Trial 23: Join Operations50 pts24Trial 24: LEFT JOIN Gaps50 pts25Trial 25: Multi-Table Joins50 pts26Trial 26: Percentage Calculations50 pts27Trial 27: Date Arithmetic50 pts28Trial 28: HAVING vs WHERE50 pts29Trial 29: UNION Combine50 pts30Trial 30: Subquery Showdown50 pts31Trial 31: Filter by Aggregate50 pts32Trial 32: GROUP_CONCAT50 pts33Trial 33: Temporal Analysis50 pts34Trial 34: Advanced Analytics50 pts35Trial 35: EXISTS & NOT EXISTS50 pts36Trial 36: Window Mastery50 pts37Trial 37: LAG & LEAD50 pts38Trial 38: Running Totals50 pts39Trial 39: NTILE Buckets50 pts40Trial 40: DENSE_RANK vs RANK150 pts41Trial 41: Top N Per Group150 pts42Trial 42: Self-Join Comparison150 pts43Trial 43: Approximate Median150 pts44Trial 44: Pivot with CASE150 pts45Trial 45: Cross-Domain Analysis150 pts46Trial 46: The Final Boss150 pts
Completed
Unlocked
Locked
Bonus
Mission Checklist
0/46- Trial 1: DISTINCT Values
- Trial 2: MAX & MIN
- Trial 3: SUM & AVG
- Trial 4: Multi-Column ORDER BY
- Trial 5: Data Reconnaissance
- Trial 6: BETWEEN Ranges
- Trial 7: LIKE Pattern Matching
- Trial 8: IN Operator
- Trial 9: NULL Handling
- Trial 10: COUNT DISTINCT
- Trial 11: Conditional Counting
- Trial 12: Compound WHERE Clauses
- Trial 13: Date Part Extraction
- Trial 14: Aggregate Strike
- Trial 15: Multi-Column GROUP BY
- Trial 16: Daily Price Range
- Trial 17: String Functions
- Trial 18: CAST & Type Conversion
- Trial 19: COALESCE & Default Values
- Trial 20: NOT IN Exclusion
- Trial 21: Ratio & Division
- Trial 22: Conditional Logic
- Trial 23: Join Operations
- Trial 24: LEFT JOIN Gaps
- Trial 25: Multi-Table Joins
- Trial 26: Percentage Calculations
- Trial 27: Date Arithmetic
- Trial 28: HAVING vs WHERE
- Trial 29: UNION Combine
- Trial 30: Subquery Showdown
- Trial 31: Filter by Aggregate
- Trial 32: GROUP_CONCAT
- Trial 33: Temporal Analysis
- Trial 34: Advanced Analytics
- Trial 35: EXISTS & NOT EXISTS
- Trial 36: Window Mastery
- Trial 37: LAG & LEAD
- Trial 38: Running Totals
- Trial 39: NTILE Buckets
- Trial 40: DENSE_RANK vs RANK
- Trial 41: Top N Per Group
- Trial 42: Self-Join Comparison
- Trial 43: Approximate Median
- Trial 44: Pivot with CASE
- Trial 45: Cross-Domain Analysis
- Trial 46: The Final Boss
*bleep* Zero missions complete. The SwiftLink training program awaits, human.
Trial 1: DISTINCT Values
Beginner
Skills: selectgroupcountorderlimit
Quiz*bleep* Tackle this next.
Trial 2: MAX & MIN
Beginner
Skills: selectgroupmaxminorderlimit
QuizTrial 3: SUM & AVG
Beginner
Skills: selectgroupsumavgcountorder
QuizTrial 4: Multi-Column ORDER BY
Beginner
Skills: selectorderlimit
QuizTrial 5: Data Reconnaissance
Intermediate
Skills: selectwhereorderlimit
QuizTrial 6: BETWEEN Ranges
Intermediate
Skills: selectwherebetweenorderlimit
QuizTrial 7: LIKE Pattern Matching
Intermediate
Skills: selectwherelikegrouporder
QuizTrial 8: IN Operator
Intermediate
Skills: selectwhereinorderlimit
QuizTrial 9: NULL Handling
Intermediate
Skills: selectjoinwhereis_nullorderlimit
QuizTrial 10: COUNT DISTINCT
Intermediate
Skills: selectgroupcountorderlimit
QuizTrial 11: Conditional Counting
Intermediate
Skills: selectcasecountsum
QuizTrial 12: Compound WHERE Clauses
Intermediate
Skills: selectwhereandororderlimit
QuizTrial 13: Date Part Extraction
Intermediate
Skills: selectgroupdate_functionscountorder
QuizTrial 14: Aggregate Strike
Intermediate
Skills: selectgroupcountorderlimit
QuizTrial 15: Multi-Column GROUP BY
Intermediate
Skills: selectgroupsumcountorderlimit
QuizTrial 16: Daily Price Range
Intermediate
Skills: selectgroupavgmaxmincountorderlimit
QuizTrial 17: String Functions
Intermediate
Skills: selectstring_functionsorderlimit
QuizTrial 18: CAST & Type Conversion
Intermediate
Skills: selectgroupcastavgmaxorderlimit
QuizTrial 19: COALESCE & Default Values
Intermediate
Skills: selectjoincoalesceorderlimit
QuizTrial 20: NOT IN Exclusion
Intermediate
Skills: selectwherenot_inorderlimit
QuizTrial 21: Ratio & Division
Intermediate
Skills: selectgroupsumdivisionorder
QuizTrial 22: Conditional Logic
Intermediate
Skills: selectcaseorderlimit
QuizTrial 23: Join Operations
Advanced
Skills: selectjoingroupcountorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 24: LEFT JOIN Gaps
Advanced
Skills: selectjoingroupcountorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 25: Multi-Table Joins
Advanced
Skills: selectjoingroupcountorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 26: Percentage Calculations
Advanced
Skills: selectgroupcasecountorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 27: Date Arithmetic
Advanced
Skills: selectdate_functionsorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 28: HAVING vs WHERE
Advanced
Skills: selectgrouphavingavgorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 29: UNION Combine
Advanced
Skills: selectunioncteorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 30: Subquery Showdown
Advanced
Skills: selectwheresubqueryorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 31: Filter by Aggregate
Advanced
Skills: selectwheresubqueryavgorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 32: GROUP_CONCAT
Advanced
Skills: selectgroupgroup_concatcountorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 33: Temporal Analysis
Advanced
Skills: selectgroupavgsumhavingorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 34: Advanced Analytics
Advanced
Skills: selectcteavggroupsubquery
Requires Intermediate — earn 50 total pts tier
Trial 35: EXISTS & NOT EXISTS
Advanced
Skills: selectexistssubqueryorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 36: Window Mastery
Advanced
Skills: selectcteavggroupwindowrank
Requires Intermediate — earn 50 total pts tier
Trial 37: LAG & LEAD
Advanced
Skills: selectwindowlagorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 38: Running Totals
Advanced
Skills: selectgroupctewindowsumorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 39: NTILE Buckets
Advanced
Skills: selectwindowntileorderlimit
Requires Intermediate — earn 50 total pts tier
Trial 40: DENSE_RANK vs RANK
Expert
Skills: selectgroupwindowrankorderlimit
Requires Advanced — earn 150 total pts tier
Trial 41: Top N Per Group
Expert
Skills: selectctewindoworderlimit
Requires Advanced — earn 150 total pts tier
Trial 42: Self-Join Comparison
Expert
Skills: selectjoinwhereorderlimit
Requires Advanced — earn 150 total pts tier
Trial 43: Approximate Median
Expert
Skills: selectctewindowcount
Requires Advanced — earn 150 total pts tier
Trial 44: Pivot with CASE
Expert
Skills: selectgroupcasesumorder
Requires Advanced — earn 150 total pts tier
Trial 45: Cross-Domain Analysis
Expert
Skills: selectctejoincasegrouporder
Requires Advanced — earn 150 total pts tier
Trial 46: The Final Boss
Expert
Skills: selectjoingroupctecasewindowrank
Requires Advanced — earn 150 total pts tier