Technical Knowledge Advanced
Summary
Experienced in relational database design, normalization, and query optimization. Proficient in transforming raw datasets into well-structured schemas using EER diagrams and relational models, with attention to cardinality ratios and participation constraints. Skilled in writing complex SQL queries involving aggregations, joins, and subqueries, as well as optimizing query performance through B+ tree indexing. Comfortable working with large datasets (16GB+) and handling real-world data quality issues including null values and duplicates. Experience with SQLite, HSQLDB, and database connectivity through Java (JDBC) and Python.