In this article I will explain how to install express edition of SQL Server 2014.
Step 1: Download SQL Server 2014 Express from following here
You need to login to your Microsoft account to download this.
After logging in, fill personal information, select software version i.e., SQL Server 2014 Express 32 Bit or SQL Server 2014 Express 64 Bit, select language, select country/location and click on Continue to download SQL Server 2014 Express Edition SQLEXPR_x64_ENU.exe (for 64 bit)
Step 2: Double click on the downloaded file SQLEXPR_x64_ENU.exe to extract installation files in a folder. After extracting the file and open SETUP.EXE
Step 8: Click on “Named Instance” radio button and give a name for the SQL Server instance like “SQLExpress2014” if you have multiple instances of SQL Server installed. This instance will be accessible using localhostSQLExpress2014. You can select Default instance if you do not have any SQL Server instances installed. Then it will be accessed using only localhost
To install SSMS you need to select SQL Server 2014 Management Studio Express 64 Bit or 32 bit in Step 1 above. It will download SQLManagementStudio_x64_ENU.exe. Open it to extract inside a folder. Then run Setup.exe from the extracted folder, select “New SQL stand-alone installation or features to an existing installation” and follow the instructions.