Project 2 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.
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.
Dataset: Six .csv file (Alumni record of College A and College B) Higher Studies, Self Employed and Service/Job record
- College_A_HS ~ Higher Studies Record of College A
- College_A_SE ~ Self Employed Record of College A
- College_A_SJ ~ Service/Job Record of College A
- College_B_HS ~ Higher Studies Record of College B
- College_B_SE ~ Higher Studies Record of College B
- College_B_SJ ~ Higher Studies Record of College B
Tasks to be performed
-------------------------------------------------------------------------------------------------------------
1.Create new schema as alumni
--------------------------------------------------------------------------------------------------------------------------------
2.Import all .csv files into MySQL
--------------------------------------------------------------------------------------------------------------------------------
3.Run SQL command to see the structure of six tables
~ for College_A_HS
~ for College_A_SE
~ for College_A_SJ
~ for College_B_HS
~ for College_B_SE
~ for College_B_SJ
--------------------------------------------------------------------------------------------------------------------------------
4.Display first 1000 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) with Python.
~ for College_A_HS
~ for College_A_SJ
~ for College_A_SJ
~ for College_B_HS
~ for College_B_SE
~ for College_B_SJ
--------------------------------------------------------------------------------------------------------------------------------
5.Import first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel.
~ for College_A_HS
~ for College_A_SE
~ for College_A_SJ
~ for College_B_HS
~ for College_B_SE
~ for College_B_SJ
--------------------------------------------------------------------------------------------------------------------------------
6.Perform data cleaning on table College_A_HS and store cleaned data in view College_A_HS_V, Remove null values.
--------------------------------------------------------------------------------------------------------------------------------
7.Perform data cleaning on table College_A_SE and store cleaned data in view College_A_SE_V, Remove null values.
--------------------------------------------------------------------------------------------------------------------------------
8.Perform data cleaning on table College_A_SJ and store cleaned data in view College_A_SJ_V, Remove null values.
--------------------------------------------------------------------------------------------------------------------------------
9.Perform data cleaning on table College_B_HS and store cleaned data in view College_B_HS_V, Remove null values.
--------------------------------------------------------------------------------------------------------------------------------
10.Perform data cleaning on table College_B_SE and store cleaned data in view College_B_SE_V, Remove null values.
--------------------------------------------------------------------------------------------------------------------------------
11.Perform data cleaning on table College_B_SJ and store cleaned data in view College_B_SJ_V. Remove null values
--------------------------------------------------------------------------------------------------------------------------------
12.Make procedure to use string function/s for converting record of Name, FatherName, MotherName into lower case for views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V)
"Collegesdata" has all six views data that has converted to lowe case of specified columns
--------------------------------------------------------------------------------------------------------------------------------
13.Import the created views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V) into MS Excel and make pivot chart for location of Alumni.
~For View College_A_HS_V,data is imported and pivot chart is created for that.
~For View College_A_SE_V, data is imported and pivot chart is created for that.
~ For View College_A_SJ_V,data is imported and pivot chart is created for that.
~ For View College_B_HS_V,data is imported and pivot chart is created for that.
~ For View College_B_SE_V,data is imported and pivot chart is created for that.
~For View College_B_SJ_V,data is imported and pivot chart is created for that.
--------------------------------------------------------------------------------------------------------------------------------
14.Write a query to create procedure get_name using the cursor to fetch names of all students from college A.
~ Along with the screenshots , word file is also attached showing all the students names present in College_A.
--------------------------------------------------------------------------------------------------------------------------------
15.Write a query to create procedure get_name using the cursor to fetch names of all students from college B.
~ Along with the screenshots , word file is also attached showing all the students names present in College_B.
--------------------------------------------------------------------------------------------------------------------------------
16.Calculate the percentage of career choice of College A and College B Alumni (w.r.t Higher Studies, Self Employed and Service/Job)
--------------------------------------------------------------------------------------------------------------------------------
Kindly,Review the Project.
Regards,
B.SURYA DEEPAK