Project 2

Project - 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.

Tasks performed

1. New schema as alumni created
2. .csv files imported into MySQL
3. Run SQL command to see the structure of six tables
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.
   
5. all the records of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel imported
6. Performed data cleaning on table College_A_HS and store cleaned data in view College_A_HS_V, Remove null values.
7. Performed data cleaning on table College_A_SE and store cleaned data in view College_A_SE_V, Remove null values.
8. Performed data cleaning on table College_A_SJ and store cleaned data in view College_A_SJ_V, Remove null values.
9. Performed data cleaning on table College_B_HS and store cleaned data in view College_B_HS_V, Remove null values.
10. Performed data cleaning on table College_B_SE and store cleaned data in view College_B_SE_V, Remove null values.
11. Performed data cleaning on table College_B_SJ and store cleaned data in view College_B_SJ_V, Remove null values.
12. New procedure created 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)
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.
14. Write a query to create procedure get_name_collegeA using the cursor to fetch names of all students from college A.
15. Write a query to create procedure get_name_collegeB using the cursor to fetch names of all students from 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)