user100DaysOfCode
CommunityDevTermsResources|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

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

Day 1 - Create Database

Create two databases 'project' and 'myproject' using CREATE DATABASE statement

Day 2 - List Databases

List all the databases using SHOW DATABASES statement

Day 3 - Rename Database

1. Rename database 'project' to 'mydatabase' using ALTER DATABASE statement
2. Rename database 'mydatabase' back to 'project' again using RENAME DATABASE statement

Verify your changes by listing databases after you run the query

Day 4 - Drop Database

Delete database 'mydatabase' using DROP DATABASE statement

Verify your changes by listing databases after you deleted the database

Day 5 - Select Database

Select database 'project' using USE DATABASE statement

We can perform operations like creating a TABLE or inserting data to the TABLE only after selecting the database.

Day 6 - Select Query

Write a query to retrieve all rows from a table

Day 7 - Select columns

Select specific columns from a table

Day 8 - WHERE clause

Add a WHERE clause to filter data based on a condition

Day 9 - Sort Results

Sort the result set in ascending and descending order

Day 10 - Limit Results

Limit the number of rows returned in a query

Day 11 - INNER JOIN between two tables

This content is locked. Please login to view it

Day 12 - Average on numeric column

This content is locked. Please login to view it

Day 13 - Count rows

This content is locked. Please login to view it

Day 14 - Group rows

This content is locked. Please login to view it

Day 15 - DISTINCT keyword

This content is locked. Please login to view it

Day 16 - Sum of a numeric column

This content is locked. Please login to view it

Day 17 - Filter data

This content is locked. Please login to view it

Day 18 - BETWEEN operator

This content is locked. Please login to view it

Day 19 - Find minimum and maximum values

This content is locked. Please login to view it

Day 20 - Count unique values in a column

This content is locked. Please login to view it

Day 21 - LEFT JOIN operation

This content is locked. Please login to view it

Day 22 - Data from multiple tables

This content is locked. Please login to view it

Day 23 - IN operator

This content is locked. Please login to view it

Day 24 - Average and total sum in one query

This content is locked. Please login to view it

Day 25 - Retrieve highest values in a column

This content is locked. Please login to view it

Day 26 - LIKE operator

This content is locked. Please login to view it

Day 27 - LIMIT clause

This content is locked. Please login to view it

Day 28 - NULL values in a column

This content is locked. Please login to view it

Day 29 - OUTER JOIN operation

This content is locked. Please login to view it

Day 30 - NULL operators

This content is locked. Please login to view it

Day 31 - Median value

This content is locked. Please login to view it

Day 32 - INNER JOIN

This content is locked. Please login to view it

Day 33 - ORDER BY with multiple columns

This content is locked. Please login to view it

Day 34 - Standard deviation of a numeric column

This content is locked. Please login to view it

Day 35 - Date column operations

This content is locked. Please login to view it

Day 36 - EXISTS operator

This content is locked. Please login to view it

Day 37 - NOT LIKE operator

This content is locked. Please login to view it

Day 38 - Percentage using window functions

This content is locked. Please login to view it

Day 39 - ROW_NUMBER()

This content is locked. Please login to view it

Day 40 - UNION and UNION ALL set operators

This content is locked. Please login to view it

Day 41 - COALESCE function

This content is locked. Please login to view it

Day 42 - Second highest value in a column

This content is locked. Please login to view it

Day 43 - RANK() window function

This content is locked. Please login to view it

Day 44 - Cumulative sum using window functions

This content is locked. Please login to view it

Day 45 - Difference between consecutive rows

This content is locked. Please login to view it

Day 46 - Date range

This content is locked. Please login to view it

Day 47 - Complex filtering

This content is locked. Please login to view it

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

This content is locked. Please login to view it

Day 49 - 75th percentile of a numeric column

This content is locked. Please login to view it

Day 50 - Weighted average of a numeric column

This content is locked. Please login to view it

Day 51 - COALESCE function

This content is locked. Please login to view it

Day 52 - Top N records

This content is locked. Please login to view it

Day 53 - NTILE() window function

This content is locked. Please login to view it

Day 54 - Average with exclusion of outliers

This content is locked. Please login to view it

Day 55 - Self-join

This content is locked. Please login to view it

Day 56 - Median absolute deviation (MAD)

This content is locked. Please login to view it

Day 57 - FIRST_VALUE and LAST_VALUE window functions

This content is locked. Please login to view it

Day 58 - ROWS BETWEEN clause

This content is locked. Please login to view it

Day 59 - Geometric mean of a numeric column

This content is locked. Please login to view it

Day 60 - Date range

This content is locked. Please login to view it

Day 61 - Interquartile range (IQR)

This content is locked. Please login to view it

Day 62 - NTH_VALUE window function

This content is locked. Please login to view it

Day 63 - ARRAY functions

This content is locked. Please login to view it

Day 64 - Gini coefficient

This content is locked. Please login to view it

Day 65 - Top N distinct

This content is locked. Please login to view it

Day 66 - Moving average

This content is locked. Please login to view it

Day 67 - Advanced querying

This content is locked. Please login to view it

Day 68 - PERCENTILE_CONT and PERCENTILE_DISC

This content is locked. Please login to view it

Day 69 - Identify duplicates

This content is locked. Please login to view it

Day 70 - CAGR (Compound Annual Growth Rate)

This content is locked. Please login to view it

Day 71 - HISTOGRAM window function

This content is locked. Please login to view it

Day 72 - JSON functions

This content is locked. Please login to view it

Day 73 - Fuzzy text matching

This content is locked. Please login to view it

Day 74 - Coefficient of variation (CV)

This content is locked. Please login to view it

Day 75 - Advanced sorting

This content is locked. Please login to view it

Day 76 - Full-text search

This content is locked. Please login to view it

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

This content is locked. Please login to view it

Day 78 - ARRAY_AGG and OBJECT_AGG functions

This content is locked. Please login to view it

Day 79 - Temporal data analysis

This content is locked. Please login to view it

Day 80 - Probability density function (PDF)

This content is locked. Please login to view it

Day 81 - Integrate machine learning predictions

This content is locked. Please login to view it

Day 82 - Location-based queries

This content is locked. Please login to view it

Day 83 - Network analysis

This content is locked. Please login to view it

Day 84 - Text similarity

This content is locked. Please login to view it

Day 85 - Time-series analysis

This content is locked. Please login to view it

Day 86 - Advanced statistical and mathematical functions

This content is locked. Please login to view it

Day 87 - Sentiment analysis

This content is locked. Please login to view it

Day 88 - Calculate and visualize data distribution using histogram charts

This content is locked. Please login to view it

Day 89 - External data sources and APIs

This content is locked. Please login to view it

Day 90 - Time-based data comparisons

This content is locked. Please login to view it

      Sponsor Us|Community|Blog|YoutubeCareersContact UsDisclaimerPrivacy PolicyTerms of Service
      Have Feedback or want to contribute? Email: hello[@]100DaysOfCode.io
      100DaysOfCode@2024