SQL

SQL Databases

SQL Experience

I know how to interact with various platforms (Power BI, Azure, Tableau etc..) to get SQL data in and can work with SQL Sever Management in terms of data manipulation / exporting.

SQL Server Management Studio has given me a chance to work on writing applied SQL syntax. I am learning quickly and getting better everyday.

Basically, I know enough to SQL to be able to accurately access the files that I need and conduct the necessary manipulation to efficiently process the data (filters, joins, exporting, cleaning).

Azure

The Azure portal is absolutely massive and powerful.

I have worked through building different kind of resources (analytics and databases) on the portal.

I've also used to track the performance of my SQL queries.

When I built the original database I was able to get some solid insights into the costs associated with the performance.

SMSS - data profiling
Using Azure Data Studio to manage files
Azure setup
Power BI - SQL Direct Query
Azure - Monitoring Performance
SMSS - Coffee Sample