Indian Census Report Data Analysis using SQL

Excited to share my DATA ANALYSIS project on the "ORIGINAL" INDIAN CENSUS RECORD using SQL and MySQL for my portfolio! Through this project, I've gained a solid foundation in SQL, from the basics to more advanced concepts.

As a data analyst, being able to write complex queries to extract insights from a database is a crucial skill set, and I'm thrilled to showcase my abilities with this project. I've explored various SQL queries and demonstrated my ability to derive meaningful insights from data. Overall, this project has been a valuable learning experience, and I'm excited to continue building my SQL skills and tackle more challenging projects in the future.

SQL CONCEPTS COVERED ARE:-
🔹SHOW TABLES, DESC TableName
🔹Big 6 – SELECT, FROM, WHERE, GROUP BY, HAVING,ORDER BY
🔹Aggregate functions & ROUND function
🔹LIKE & IN operator - Pattern matching
🔹Wildcard characters
🔹Union, Limit
🔹JOINS – INNER JOIN, LEFT JOIN & MULTIPLE JOINS
🔹JOINS with multiple conditions
🔹Subquery
🔹Rank Window functions – ROW_NUMBER, RANK