# SQL (Advanced)

> Demonstrated advanced SQL problem-solving for analytics, optimization, and complex relational data scenarios.

URL: https://www.matthewswong.com/en/certifications/sql-advanced/

- Issuer: HackerRank
- Category: Database
- Credential: https://www.hackerrank.com/certificates/983098e12ce8

Strengthened my ability to model analytics and optimize queries for production-sized relational datasets.

## Focus areas

- Window functions
- Query optimization
- Data modeling

## What I learned

- Write efficient queries using joins, window functions, and subquery strategies.
- Model reporting logic directly in SQL for data-heavy application features.
- Optimize query structure for performance on larger datasets.

## Applied in projects

- Reduced query latency by restructuring joins and filtering earlier in the execution plan.
- Built reusable SQL patterns for KPI dashboards and operational reports.
- Improved reporting consistency with cleaner schema relationships.

---

- HTML version: https://www.matthewswong.com/en/certifications/sql-advanced/
- Bahasa Indonesia: https://www.matthewswong.com/id/certifications/sql-advanced/
- Site index for agents: https://www.matthewswong.com/llms.txt
- Sitemap: https://www.matthewswong.com/sitemap.xml
- API description (OpenAPI): https://www.matthewswong.com/openapi.json