Learning SSMS

SALIL RAY 1 Reputation point

Hi team,
I have a quick question. Can I learn the components SSAS, SSIS, SSRS, SSDT etc of SSMS without actually downloading it?
If yes, would you mind guiding me.

Looking forward to your valued reply.


Salil Ray

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,825 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,249 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Nandan Hegde 29,901 Reputation points MVP

    hey @SALIL RAY ,
    wiseowl tutorials are pretty great place to start with BI tools:


    but it is ideally preferred to have hands on experience while training for this skills to have a better grasp than just watching the videos.

    0 comments No comments

  2. Lukas Yu -MSFT 5,816 Reputation points


    If you have strong Database and BI development background , i.e. you have mastered Oracle or Power BI ect. , you could learn above with out actually download and practice.

    If not, I am pessimistic on this topic, this BI suites consist a lot of concept and programmatic skills that need to be practiced and then understood.

    The videos are great, but in my opinion, not enough . Since there are free developer edition of these tools, why not given them a try. You would have much better learning experience and result that just watch tutorial videos.