SQL

Database Querying & Management

Structured Query Language (SQL) is fundamental to my data analysis workflow. I possess strong capabilities in writing efficient queries to extract, filter, and aggregate data from large relational databases.

Whether it's joining multiple tables to create a comprehensive dataset for Power BI or performing ad-hoc analysis to investigate a quality issue, I ensure data accuracy and integrity at the source.

Key Competencies

• Complex Joins (INNER, LEFT, RIGHT, FULL)
• Subqueries and CTEs (Common Table Expressions)
• Window Functions (RANK, LEAD, LAG)
• Stored Procedures and Views
• Database Normalization Concepts