This project demonstrates a wide range of SQL Server skills through database design, reporting, administration, triggers, backup and restore operations, indexing, and advanced SQL routines.
The project includes solutions for customer and purchase reporting, category and product analysis, login and connection administration, trigger-based auditing, cascading deletes, backup and restore commands, user and role management, and several advanced SQL routines.
- SQL Server database design
- Reporting queries with joins and aggregations
- Insert, update, and delete operations
- Triggers and audit logging
- Cascading delete logic
- Backup and restore procedures
- User and role creation
- CASE statements and IF/ELSE logic
- Temp tables
- Cross-database joins
- Error handling and logging
- Subqueries and CTEs
- Indexing and performance comparison
sql/sql_competition_completed.sql
This project highlights both development and administrative SQL Server skills. It demonstrates the ability to build and manage relational databases, write production-style SQL routines, and solve practical database problems in a structured way.
sql/sql_competition_completed.sql– retail analytics, triggers, admin routines, joins, and advanced SQLsql/customer_table_and_sql_routines.sql– customer table creation, indexes, views, logic routines, and error loggingsql/insurance_table_setup.sql– setup for insurance rate and customer databases/tablessql/insurance_rating_application.sql– age-based insurance rate assignment, rider calculation, and reporting logic
This SQL project simulates an insurance pricing system using two databases: one for customer data and one for age-based rate tables. It calculates customer age from date of birth, assigns the correct insurance rate based on age bands, applies rider multipliers, and generates sorted customer pricing reports.