HOME
PRIVACY POLICY
ABOUT US

How to install Microsoft SQL Express Edition Server On your local Machine

Install SQL Server 2012 Express | DEEP LEARNING ( AI ) FOR BEGINNERS AND CODERS | MULTIPLEWORDS BY PROGRAMMERS

SQL (Structured Query Language) is Language used to maintain and Save data Efficiently. It Relational Data Management system mainly developed on SETS concept in mathematics . Microsoft SQL Server is a SQL Server of Microsoft company . It is highly Efficient and Secure Server by Microsoft .

It has different Edition of product for use

Express Edition

it is Students and small developer with no charges (Limitation only 10 GB of data you will be able to store . Many features are not there)


Enterprise Edition

It is Paid version by microsoft. SQL Server Enterprise Edition includes both the core database engine and add-on services, with a range of tools for creating and managing a SQL Server cluster. It can manage databases as large as 524 petabytes and address 12 TB of memory and supports 640 logical processors (CPU cores).


It has many different versions also to know more about it you can visit wikipedia.com. It is here.


Requirement





  1. MSSQL Server by microsoft
  2. Microsoft SQL Server Management Studio ( For Managing different SQL Server of it )

Steps to setup Microsoft Structured Query Language (MSSQL) Express Edition





  1. Download MS SQL Server Express Edition from here . we will downloading and installing MSSQL 2008 r2 Express Edition.
  2. Just run Downloaded file and install it
  3. Now download microsoft sql server management studio from here. We are usign MSSQL management studio 2008 for learning purpose
  4. Download Version According to your machine.
  5. Install it

Following Video Demonstrate Screens after download and install Process of MSSQL Server Express Edition

Install and Download SQL server Management Studio

  1. Following Video Demonstrate to do it .
  2. To Connect to your SQL Express edition instances you need to type ./SQLExpress in server name and make sure you have given authentication as Windows Authentications . Then Click Connect


For more Queries and Question kindly post on Facebook group

Want to know more about me .click here

Taher Deep learning Engineer

Related Posts