Project 2

Once a student is passed out from an 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 database using Jupyter notebook Import the data into excel for better analysis 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 views 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 present in the schema for converting the name into title, lower upper etc.--- Creating the Stored procedure using the help of cursor for do the Data analysis based on each row wise Doing the percentage of total alumni based on the category from each college

All the important info and description is done in MS word

all the formats like .sql, .ipynb, .excel are attached below.