Project 2-Create new schema as alumni

Aim:

The aim of this SQL project is to analyze the career choices of alumni from two universities based on their passing year and the course they completed. The analysis will help understand the trends in career choices among alumni and provide insights for the universities to improve their networking activities and rankings.

Description:

To achieve the project aim, the following steps will be taken:

1. Data collection: Collect data on alumni from the two universities including passing year, course completed, and current occupation.

2. Data cleaning: Clean the data to remove any duplicates, errors, or missing values.

3. Data analysis: Analyze the data using SQL queries to identify the career choices of alumni from the two universities.

4. Visualization: Create visualizations such as charts and graphs to present the analysis in a clear and concise manner.

5. Conclusion: Draw conclusions from the analysis and provide recommendations to the universities to improve their networking activities and rankings.

Conclusion :

In conclusion, this SQL project aimed to analyze the career choices of alumni from two universities based on their passing year and course completed. The analysis revealed interesting insights into the trends in career choices among alumni, which can help the universities improve their networking activities and rankings. The project demonstrated the importance of data analysis in making informed decisions and the power of SQL as a tool for data analysis.