Installation of SQL Server Managment Studio

What is SQL?

SQL, which stands for Structured Query Language, is a programming language used to manage relational databases. It is a powerful tool that allows users to interact with databases, create, modify, and retrieve data, and perform various operations on data stored in a database.

SQL is incredibly useful in many ways:

Data management: SQL provides an efficient and organized way to manage large amounts of data in a structured format, making it easier to store, retrieve, update, and delete data in a database.

Data analysis: SQL offers powerful tools for querying and analyzing data, allowing users to extract meaningful insights and make informed decisions based on the data stored in a database.

Database administration: SQL provides functionalities for creating, modifying, and managing the structure of a database, including defining tables, setting up relationships, and managing access permissions, making it an essential tool for database administrators.

Application development: SQL is commonly used as a backend database management system for developing web applications, mobile apps, and other software applications that require data storage and retrieval.

How to Install (SSMS)?

Here are a few simple steps to download and install SQL Server on your system, which will enable you to have Microsoft SQL Server up and running in no time.

Launch a web browser on your system and use any search engine, such as Google or Yahoo, to search for “MS SQL Server download” in the search bar.

Navigate to the official Microsoft website for SQL Server downloads, which can be found at https://www.microsoft.com/en-in/sql-server/sql-server-downloads. This is the authentic website where you can download Microsoft SQL Server.

After accessing the website, simply scroll down slightly to find the available options.

Simply select the software that has just been downloaded by clicking on it or download the Developer version and access it from your system’s download folder, then proceed with the installation of the exe file.

Upon launching the .exe file, a popup will promptly appear.

Choose the type of installation process as “Basic“.

Select the “Accept” button by clicking on it.

After that select specific SQL server install location (INSTALL LOCATION*)

Now , it is in the process of downloading the installation package files.

You have two options at this point. If you wish to customize SQL Server, click on “Customize“. Otherwise, click on “Install SSMS” to proceed with the default installation of SQL Server Management Studio.