Community DevTerms Resources|Login

Loading

Sql Roadmap

Join the 100 day Sql coding challenge. Master Sql with daily challenges, projects, and expert guidance.
Start coding today!

Day 1: Create Database

Day 2: List Databases

Day 3: Rename Database

Day 4: Drop Database

Day 5: Select Database

Day 6: Select Query

Day 7: Select columns

Day 8: WHERE clause

Day 9: Sort Results

Day 10: Limit Results

Day 11: INNER JOIN between two tables

Day 12: Average on numeric column

Day 13: Count rows

Day 14: Group rows

Day 15: DISTINCT keyword

Day 16: Sum of a numeric column

Day 17: Filter data

Day 18: BETWEEN operator

Day 19: Find minimum and maximum values

Day 20: Count unique values in a column

Day 21: LEFT JOIN operation

Day 22: Data from multiple tables

Day 23: IN operator

Day 24: Average and total sum in one query

Day 25: Retrieve highest values in a column

Day 26: LIKE operator

Day 27: LIMIT clause

Day 28: NULL values in a column

Day 29: OUTER JOIN operation

Day 30: NULL operators

Day 31: Median value

Day 32: INNER JOIN

Day 33: ORDER BY with multiple columns

Day 34: Standard deviation of a numeric column

Day 35: Date column operations

Day 36: EXISTS operator

Day 37: NOT LIKE operator

Day 38: Percentage using window functions

Day 39: ROW_NUMBER()

Day 40: UNION and UNION ALL set operators

Day 41: COALESCE function

Day 42: Second highest value in a column

Day 43: RANK() window function

Day 44: Cumulative sum using window functions

Day 45: Difference between consecutive rows

Day 46: Date range

Day 47: Complex filtering

Day 48: LEAD() and LAG() window functions

Day 49: 75th percentile of a numeric column

Day 50: Weighted average of a numeric column

Day 51: COALESCE function

Day 52: Top N records

Day 53: NTILE() window function

Day 54: Average with exclusion of outliers

Day 55: Self-join

Day 56: Median absolute deviation (MAD)

Day 57: FIRST_VALUE and LAST_VALUE window functions

Day 58: ROWS BETWEEN clause

Day 59: Geometric mean of a numeric column

Day 60: Date range

Day 61: Interquartile range (IQR)

Day 62: NTH_VALUE window function

Day 63: ARRAY functions

Day 64: Gini coefficient

Day 65: Top N distinct

Day 66: Moving average

Day 67: Advanced querying

Day 68: PERCENTILE_CONT and PERCENTILE_DISC

Day 69: Identify duplicates

Day 70: CAGR (Compound Annual Growth Rate)

Day 71: HISTOGRAM window function

Day 72: JSON functions

Day 73: Fuzzy text matching

Day 74: Coefficient of variation (CV)

Day 75: Advanced sorting

Day 76: Full-text search

Day 77: Create a query to handle data imputation and missing value estimation

Day 78: ARRAY_AGG and OBJECT_AGG functions

Day 79: Temporal data analysis

Day 80: Probability density function (PDF)

Day 81: Integrate machine learning predictions

Day 82: Location-based queries

Day 83: Network analysis

Day 84: Text similarity

Day 85: Time-series analysis

Day 86: Advanced statistical and mathematical functions

Day 87: Sentiment analysis

Day 88: Calculate and visualize data distribution using histogram charts

Day 89: External data sources and APIs

Day 90: Time-based data comparisons

Sponsor Us|Community|Blog|Youtube|DLP Careers Contact Us Disclaimer Privacy Policy Terms of Service
Have Feedback or want to contribute? Email: hello[@]100DaysOfCode.io
100DaysOfCode@2024