Welcome! This repository showcases my learning journey and hands-on practice in SQL, T-SQL, and data analytics using Microsoft tools like SSMS, SSIS, and Power BI.
I’m building this portfolio as part of my transition into data engineering and analytics, and using real-world databases like AdventureWorksDW2019 and scenarios from HackerRank to improve my skills.
- SQL queries for real data scenarios (aggregation, joins, filtering, subqueries)
- Explanations (in English and sometimes Persian) to reinforce my understanding
- SSIS integration practice: screenshots, data flow tasks, error handling
- Power BI dashboards (coming soon): storytelling with data
- SQL Server Management Studio (SSMS)
- T-SQL
- AdventureWorksDW sample database
- SQL Joins,
GROUP BY,HAVING,COUNT(),SUM(),IN,NOT IN, etc. - Subqueries and correlated queries
- SSIS (SQL Server Integration Services) – ETL practice
- Power BI – data visualization and reporting
| File/Folder | Description |
|---|---|
queries.sql |
All SQL statements from my daily practice |
explanations.md |
Simple explanations for each query |
SSIS/ |
Screenshots and notes from SSIS exercises |
PowerBI/ |
Screenshots and .pbix files (coming soon) |
README.md |
This file |
This repository contains categorized SQL queries from my learning journey using the AdventureWorksDW2019 and other databases.
| File Name | Description |
|---|---|
1_basics_select_where.sql |
Basic SELECT, WHERE, logical filtering, and IN usage |
2_groupby_aggregations.sql |
GROUP BY with COUNT, SUM, AVG, and MAX |
3_subqueries.sql |
Subqueries and nested filtering (e.g., IN, NOT IN) |
4_combined_logical.sql |
Combining multiple conditions (WHERE, GROUP BY, HAVING) |
5_joins.sql |
JOIN queries across customer, geography, and product tables |
| 6_having_clause.sql` | Using HAVING to filter after aggregation |
7_ddl_create_alter.sql |
CREATE TABLE and ALTER TABLE for schema design |
Each file contains commented queries organized by topic to help reinforce concepts and practice real-world scenarios.
Feel free to explore and run the queries on your own SQL Server instance.
I’m actively learning data engineering and analytics with a strong background in petroleum engineering. I’ve worked with SQL Server, SSIS, and Power BI, and I’m continuing to grow by building this portfolio, solving problems, and preparing for real-world roles.
Thanks for visiting!