SQL Server Express Edition feature and upgrade concerns I want to install and learn T-SQL with SQL Server. The lightest edition that I can find is the Express Edition 2017.


Will the express edition support procedures, triggers, dynamic sql, PIVOT, sequences, dynamic management views and functions?
Will it be upgradable to adding ssis, ssrs and ssas in future (I read documentation on Microsoft community blogs, but couldn't find an answer specific to this edition), maybe I will need them in future.
You should simply download and use SQL Server 2017 developer edition. Dev edition is same as enterprise edition so regarding feature you would not have any limitation and free to use for testing and learning. Do not use it in production