Project 2

This project contains six CSV files of Alumni records of college A and college B for higher studies, self-employed, and service or job. First I create schema alumni and then import CSV files in schema alumni as a separate table such as 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 a college A, similarly for College_B_HS, College_B_SE, College_B_SJ respectively. In this project, I am also using Jupyter notebook to display 1000 rows from each table with the help of Python. I am also using MS Excel the import each table of schema alumni from MySQL to MS Excel with the help of add-in MySQL for Excel and also work with pivot. Work with the view, data cleaning on each table, and store in the view after removing null values from tables. Work with the procedure, and create a procedure for college A and College B separately using a cursor to fetch the names of all the students from College A and College B.

Once a student is passed out from an Institute or College he/she is known as an alumni of the institute. Alumni career growth plays important role in the institute's ranking and other networking activities. In this project, the career choices of the alumni of two universities will be analyzed with respect to their passing years as well as the course they completed.

This project helps us to work with two different data from different institutes.

I have submitted the SQL file Jupiter file and Excel file.