341 views
In this exceptional class we will work with SQL Server using the sample database provided by Microsoft. Download link: https://learn.microsoft.com/pt-br/sql... In the class I am using the AdventureWorksDW2022 Data Warehouse. I will address the main relationships between the sales table where we will use INNER JOIN to improve our query. Next, we will create a View to facilitate this query in the future and the icing on the cake, to give it more dynamism, we will create a Table-Valued Function.