Jul 01 2020 12:31 PM - edited Jul 01 2020 01:20 PM
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?
Thank You
JL
Oct 11 2020 08:08 AM - edited Oct 11 2020 08:28 AM
@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
Jan 12 2022 07:26 AM
@Mkelsawy, between Express and Developer, which version is more student-friendly? I would also like your help to do a sample coding
Jan 12 2022 07:30 AM
@Foxtrot01 both versions are student friendly.
Jan 12 2022 10:26 PM
@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
Jan 13 2022 02:20 AM
@olafhelper agreed. At the end both working fine for student.