DWH performances and courses

MF82 0 Reputation points
2023-12-03T09:19:07.71+00:00

I'm looking for some courses about datawarehouseing on premise with sqlserver (enterprice). I'm looking something about advanced concepts: how to structure the databse, partitioning, indexing and ETL processes via SSIS.

I also like to undertand usage and the utility of SSAS and SSRS.

I foud some courses on data engeener, but they are focused only on Azure.

I open to free or paid courses.

Thank you for your help.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,321 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,520 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 35,381 Reputation points
    2023-12-04T02:07:51.01+00:00

    Hi @MF82,

    You may find the official documentations about SSIS, SSAS and SSRS.

    Integration Services Tutorials

    SQL Server Reporting Services

    Analysis Services documentation

    There are also a large number of blogs about SQL BI training online, you may search, learn and practice which you are interested.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments