Government Portal For Data Analysis using Data Set

I have data set for population, literacy rate and growth rate in Excel Sheet, Need to do data Analysis using these data.

Roadmap

• Learning SQL concepts
• Installing Microsoft SQL Server Manager.
• Working on data sets.
• Doing data analysis through SQL Server.

Reference

• https://www.census2011.co.in/district.php
• https://www.census2011.co.in/literacy.php

Learnings

• Create Table
• Insert Data into Table
• Count number of rows from the table.
• Sum Function
• Average Function
• Round Function
• Ascending Order
• Descending Order
• HAVING vs WHERE
• Order By
• Group by
• like function
• Union
• Distinct
• VARCHAR vs NVARCHAR: Nvarchar uses two bytes per character whereas varchar uses 1 bytes per character. Nvarchar can store unicode data, whereas varchar will convert the data in ASCII and then stores it. In NVARCHAR avoids encoding conversion every time we read or write to the database.
• JOINS
• INNER JOIN
• OUTER JOIN - LEFT, RIGHT
• Advanced Functions - naming different queries and then performing the actions.
• Window Function
• Rank()
• OVER()
• Row_number()
• Dense_Rank()
• Lag()
• Lead()