SQL Project2- Alumini Database
SQL Project-Alimni Database
Once a student is passed out from a Institute or College, he/she is known as Alumni of the Institute. Alumni’s career growth plays important role in Institute’s ranking and other networking activities. In this project, career choices of alumni of two Universities will be analyzed with respect to their passing year as well as the course they completed.
- I have taken the Alumni of the 2 colleges(Eg-College-A & College-B) and in that data set we have the category table of alumni choice of Higher studies ,Self employed and doing job for two colleges also.
- And doing some data analysis using python to found out the data present in the datse using jupiter notebook
- Import the data into excel for better anlysis of the data from each table present in our schema
- Doing the data cleaning process in sql for removing the null values present in out table for the better understanding of the data and storing that in viewa by creating views using sql queries
- Import the cleaned data what we stored in the views and creating the pivot table for that for getting the location of each alumni present in our dataset
- Creating the Stored procedure for the manipulating the string presnt in the schema for converting the name into tilte,lower uperr etc---
- Creating the Storeprocedure using the help of cursor for do the Data analysis based on each row wise
- Doing the percentange of total alumni based on the category from each college
Project File
https://github.com/Ajaysan23/SQL-Project-2-Alumini-Details-.git
The above mentioned procedure are done based on the knowledge learned through the sql model and challenges worked on
The files are attached below