How to get Start Microsoft SQL Server? Part - 2

How to get Start Microsoft SQL Server? Part - 2

How to get Start Microsoft SQL Server? Part - 2: Welcome to the Microsoft SQL Server for beginners to professional tutorial here at https://raghawendraps.blogspot.com/ portal; you can read articles online here related to Microsoft SQL Server from beginners to professional. I will try my best to help you. As we know that Microsoft SQL Server is a leading RDBMS (Relational Database Management System) and most of organizations are using it. If you are looking for an easy and efficient way to learn and become master of SQL Server then absolutely you are in the right place.

Microsoft SQL Server for beginner’s tutorial is divided into many parts having huge practical and activities here. Once completed entire tutorial then you will be able to do installation of Microsoft SQL server into our PC and Laptops, configuration, querying data efficiently from tables or views in SQL server database, Create, Alter, Delete and Drop database objects like Database, Tables, Views, Indexes, Triggers, UDFs (User Defined Functions), Synonyms, SPs (Stored Procedures) and Sequences etc.


How to Download Microsoft SQL Server Express (Microsoft SQL Server for beginners: Part – 2)

To start with it we need to download and use a free version/Express edition of Microsoft SQL Server. I am going to use Microsoft SQL Server 2012 Express.

Download Microsoft SQL Server 2012 Express edition >>>
The first thing I would like to know you that you need to get start with a FREE version or copy of Microsoft SQL Server 2012 Express Edition, in this way please click here to navigate to download it absolutely free from Microsoft official Servers, once opened Microsoft page please click on the orange “Download” button (if you are unable to reach at Microsoft’s official website then follow the link: https://www.microsoft.com/en-us/download/details.aspx?id=29062). Referring the below snapshot –

When you click on the download button a popup window will appear “Choose the download you want”, you have to click the check box next to “ENU\x64\SQLEXPRWT_x64_ENU.exe” if you have a 64-bit machine. Referring the below snapshot –

If you have 32-bit machine then download the file named “ENU\x86\SQLEXPR_x86_ENU.exe”. Referring the below snapshot –

And then click on “Next” button to download the executable file. Referring the below snapshot –

Once downloaded executable file, please run it as administrator and follow the on – screen instructions to install Microsoft SQL Server 2012 Express Edition.

Be ensuring to install both the database engine and SQL Server Management Studio (SSMS) which is the tool that we will be used to complete our queries.

Download and Attach AdventureWorks database into SQL Server Management Studio (SSMS) >>>

Once you have the Microsoft SQL Server 2012 Express Edition successfully installed on your machine, you will need to download the sample AdventureWorks2012 database. in this way please click here to navigate to download it absolutely free from Google drive location, once opened Drive location page please click on the “Download Anyway” button (if you are unable to reach at Drive location then follow the link: https://drive.google.com/uc?id=1Rk2B3Uj1vj_14gnjhbJ2upEFpN6iQHYm&export=download). Referring the below snapshot –

And download the file named “AdventureWorks2012_Data.zip”. Once downloaded please extract the files in the zipped folder. Move the file “.mdf” extention to the SQL Servers root folder – C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA. Referring the below snapshot –

Open SQL Server Management Studio (SSMS) once the file is finished downloading. Once SSMS is open please connect to your newly installed SQL Server Express instance. You can type “.\SQLEXPRESS” in the “Server Name” field when first opening SQL Server Management Studio. Referring the below snapshot –

Once connected SQL Server Management Studio 2012 please click on the folder named “Databases”, and then select “Attach”. Referring the below snapshot –

The “Attach Databases” screen will appear as shown below –

Click on the “Add” button to open the “Location Database Files” screen where you will select the file named “AdventureWorks2012_Data.mdf”. This is the AdventureWorks SQL database file that we downloaded previously. Referring the below snapshot –

Click on “OK” button once you have selected the correct file. Information will populate into the “Attach Databases” screen based on what *.mdf file you have selected. Since we downloaded the database file but not any log file associated with it please click on the row with the word “Log” in the “File Type” column. As an extra step to make sure you selected the correct file, the log row will contain the text “Not Found” in the “Message” column. After confirming you have selected the correct row please click “Remove” button and then press “OK” button. Referring the below snapshot –

Now right click on the “Databases” folder and select refresh, expand the “Databases” folder. The AdventureWorks2012 database will appear in the expanded list and now it’s ready as you can start your next work. Referring the below snapshot –

We will discuss upcoming topics in next part. So please take care of you.

Assuming this tutorial post has well acquainted aspiring to the complete requirement. If you want to download PDF format file of this tutorial then please click here to download PDF.

Also requesting, if you have any ideas or suggestions for me or you need some important blogs/Videos or guidelines related to SQL Server, Excel, WordPress, SEO, Websites technologies then please feel free to write me on below comment section or you can go through the Contact Page. I will definitely come back to you with your desired requirements.

You can see more relevant tutorials on Microsoft SQL Server at https://raghawendrashukla.com/ portal by following links given below –

Basic knowledge of Microsoft SQL Server! Part – 3

How to get Start Microsoft SQL Server? Part – 2

What are 12 rules of Dr. Edgar Frank “Ted” Codd? Part – 1

You can read more articles from here by clicking on below links:

How to create Google Adsense Account and Link with Own Website or YouTube Channel Step by Step

How to create Partition in Windows 10 | Partition of Hard Disk Drive after Windows Installations

How to apply for a Passport step by step Guidelines

How to Create a PayPal account Step by Step

Microsoft Office Excel

How to protect ourselves from Corona virus?

Disclaimer: We are approaching to make the information available on this website as authentic as possible. We are not responsible for any error that may have crept in the result or typos being published in this website and for any loss to anyone or anything caused by any short comes, defect or inaccuracy of the information on this website. The tutorial or posts published in this website is only for the immediate information to learners and does not to be a constituted to be a legal document.

Hope this tutorial post was helpful for you and you liked very well, I am happy to serve you better. If you liked really this tutorial post, please don’t forget to share on social media.