Microsoft SQL Server Express, a lightweight version of Standard SQL Server database software offers many features of what you will get from the standard version, and it is free to download. If you are are someone who is new to the relational database management system and is looking for some hand-on exerpeicne for your database lesson, then SQL Server Express is a great choice.
This tutorial guide that will walk you through how to install Microsoft SQL Server Express 2017 and SQL Server Management Studio (SSMS) step-by-step.
MS SQL Express 2017 Download Link
Some of the important limitations of Microsoft SQL Server Express 2017 to consider if this is your first time:
- Maximum database storage is 10GB per database.
- No SQL Server Agent service is available. The SQL Server Agent service is a feature to schedule SQL Server task.
- Only single CPU or four cores are allowed
- The maximum memory size per instance is 1,410MB (For majorty of the users out there, this will be more than efficient).
