Learn Sql in 100 Days
Embark on a 100-day Sql coding journey. 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
Day 12 - Average on numeric column
Day 15 - DISTINCT keyword
Day 16 - Sum of a numeric column
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 24 - Average and total sum in one query
Day 25 - Retrieve highest values in a column
Day 28 - NULL values in a column
Day 29 - OUTER JOIN operation
Day 33 - ORDER BY with multiple columns
Day 34 - Standard deviation of a numeric column
Day 35 - Date column operations
Day 37 - NOT LIKE operator
Day 38 - Percentage using window functions
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 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 53 - NTILE() window function
Day 54 - Average with exclusion of outliers
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 61 - Interquartile range (IQR)
Day 62 - NTH_VALUE window function
Day 64 - Gini coefficient
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 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 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