مشروع تحليل قواعد البينات

Proud Moment in My SQL Journey!

I just completed a comprehensive SQL data analysis project, covering 15 key queries:

Counting students with age values

Listing all instructor names without repetition

Displaying students’ full details using ISNULL

Showing all instructors with or without a department

Matching students with courses that have grades

Counting courses per topic

Calculating max & min salaries for instructors

Identifying instructors below the average salary

Finding departments with instructors earning minimum salary

Selecting top 2 salaries from the instructor table

Using COALESCE to handle missing salaries

Computing average instructor salaries

Linking students to their supervisors

Selecting top 2 salaries per department using ranking functions

Picking a random student from each department

A special thank you to Eng. Ahmed Abdel Aziz for his amazing guidance

And gratitude to London Invitation Academy for their support and resources.

This experience boosted my SQL skills and deepened my understanding of data retrieval, ranking functions, and handling NULLs efficiently.