Curso de SQL Server 2021 desde cero | INSTALACION BASE DE DATOS Y MANAGMENT STUDIO 19 (video 2)

Preparing the Environment for SQL Server

In this section, the instructor guides viewers on setting up their work environment for SQL Server by downloading and installing the necessary tools.

Downloading SQL Server

• The instructor explains the options available for downloading SQL Server, emphasizing the choice of the developer version for a controlled learning environment.

• Steps to download and install SQL Management Studio are detailed, including selecting installation types and accepting licensing agreements.

Configuring Installation

• After downloading the executable file, instructions are provided on running it as an administrator and choosing a basic installation.

• Users are guided through selecting file storage locations and initiating the basic installation process.

Completing Installation

• The instructor highlights that the installation creates direct database authentication using the computer's name as a username.

• Explanation is given regarding how computer name serves as the username in Management Studio authentication.

Installing SQL Management Studio

This part focuses on installing SQL Management Studio after completing the base database installation process.

Installing SSMS

• Viewers are directed to download SQL Management Studio from Microsoft's page, followed by executing it as an administrator.

• Instructions on file location selection and completion of SSMS installation process are provided.

Finalizing Setup

• A summary of completing both database and management tool installations is given before closing setup windows.