SQL Server download version for university student

Copper Contributor

Hi 

 

I just download SQL server express edition which comes out with SQL Server Configuration Managment. I don't know if I download the right version of SQL Server for personal use. I need it to be install for school study and personal learning. The screenshot below doesn't look like a easy use software for sql. I tried to start with insert CSV files. Is anyone knows the instruction of the server? 

 

JessicaJL123_0-1593634738262.png

 

 

Thank You

 

JL

5 Replies

@JessicaJL123 Hi Jessica,

 you can download either the developer edition or express edition free from the below links 

 

developer https://go.microsoft.com/fwlink/?linkid=866662

express https://go.microsoft.com/fwlink/?linkid=866658

 

Then you need to download SSMS https://aka.ms/ssmsfullsetup or Azure data Studio (runs on Windows, macOS, and Linux) from that link  https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ve...

based on your computer OS. 

 

and that what you need to connect to the SQL server visually then you can export your CSV file easily.

 

also, you can use that link https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&...  to download a sample database to help you play around with dummy data.

 

I hope that help,

Thanks 

 

@Mkelsawy, between Express and Developer, which version is more student-friendly? I would also like your help to do a sample coding

@Foxtrot01 both versions are student friendly. 

@Mkelsawy , the developer edition do have the full feature set of the high end Enterprise edition, while the feature set of Express is very limited, see

Editions and supported features of SQL Server 2019 (15.x)

@olafhelper agreed. At the end both working fine for student.