The dataset for this project was gotten from https://data.police.uk/data/
I've used T-SQL to do the following;
-
Insert Dataset from Repositiory to local SQL Server database
-
Insert Dataset from Repositiory to local SQL Server database
-
Create Tables
-
Create Summerised Reports that allow you to perform an analysis of crime in Greater Manchester
-
Create filtering, sorting and grouping funcationality.
-
Create concurrency techiques
-
Create Various Search Facilities in Child Well-Being Monitor.