This project is a simple SQL-based student database system created for learning and demonstrating SQL fundamentals. It includes a student table with 50 records, covering basic student attributes such as roll number, name, department, year, CGPA, age, phone number, blood group, gender, and email.
The SQL script includes a variety of operations commonly used in academic and real-world database work.
- Creates a
studenttable with appropriate column types - Includes NOT NULL and PRIMARY KEY constraints
- Inserts 50 student records
- Covers multiple departments and years for variety
- Retrieve all records
- Filter students by department
- Filter students by year
- Find students with CGPA above a certain threshold
- Count total students
- Count students by department
- Calculate average CGPA
- Filter students with CGPA > overall average
- Search names starting with a specific letter
- Search email domains
- Sort students by CGPA
- Sort by name
- Group by department
- Group by year
- Categorize student performance as:
- Excellent
- Good
- Average
This file contains:
- Table creation query
- Data insertion
- Query operations
- Analytical queries
- SQL
- MySQL / PostgreSQL / SQL-compatible engines
- VS Code (for writing script)
This SQL project is created as part of hands-on learning for:
- Understanding database design
- Practicing SQL queries
- Demonstrating problem-solving skills in real data scenarios
It is also submitted as a sample project for Cognizant GenC as part of the technical skill verification.
Sanjay V
Email: sanjayav636@gmail.com
LinkedIn: https://linkedin.com/in/sanjay-v-629527271