In this part we will learn how to install SQL server and you will be taught the complete installation process step by step in these parts. So let's get started.


Download  and install SQL server 2023?

  • Click on given link. sql-server-download Scroll down until you find the Developer edition and click the Download now button.

  • Click on the custom installation type.



  • Choose where to select the downloaded installation media files a by clicking on the browser and then click on the install to continue.

  Once the download is complete, the setup window automatically closes and is replaced by the SQL Server Installation Center window. Here, start the wizard to install SQL Server 2019.


  • Select the Installation category on the left-hand side of the SQL Server Installation Center window and click the New SQL Server link to start the installation wizard.


  • The wizard automatically checks for available updates. If there are no updates ready to install, click Next to proceed.

  • The install wizard checks for any errors that might cause problems during the setup process. If it detects any failures, fix them before clicking Next to continue.


Choose an installation type. If you are installing SQL Server for the first time, select the Perform a new installation of SQL Server 2019 option and click Next to continue.


  • Choose the version of SQL Server you want to install and enter a product key if you have one, then click Next to proceed. For this example, we are installing the free Developer version.
 
  • Check the I accept the license terms and Privacy Statement box and click Next to continue.

  • Select the features you want to install. For this example, we are using the Database Engine Services option. Click Next to proceed.


  • Enter a name and instance ID for the new SQL server and click Next to continue.

 


  • Set up the service accounts and collation configuration, then click Next to continue. For this example, we are using the default settings.


  •  In the Server Configuration tab, select the Mixed Mode method of authentication. Select a user for the role of SQL server administrator and set up a password for their account Choose a password you will remember. Click Next to proceed.

  • The final step offers a summary of the installation. Click Back to return to any of the previous steps and change the installation settings or click Install to start the setup process.


  • Once the setup is complete, the status of setup operations should read Succeeded. Click Close to exit the install wizard.

How to Install Microsoft SQL Server Management Studio?

Microsoft SQL Management Studio (SSMS) allows you to design, query, and manage databases using SQL Server. Follow the steps outline below to install it on your system:
 Download the install file from the SQL Server Management Studio download page. Scroll down and click the link to download SSMS 18.9.1.



  •  Open the install file to start the setup.

  •  Choose an install location and click Install to continue. 




  • Once the installation process is complete, click Close to exit the setup.
Here you can also learn:


What is SQL and what is it used for?

What is Database Management System?