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

*BOTH Excel sheets and sql files are attached below**

Q2.Import all .csv files into MySQL

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

college_a_hs:

college_a_se

college_a_sj

college_b_hs

college_b_se

college_b_sj

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

ANS:-excel sheets

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

college_a_hs_v

college_a_se_v

college_a_sj_v

college_b_hs_v

college_b_se_v

college_b_sj_v