Base de Datos II

Welcome to Base de Datos II course, this is a little tools guide that you use in this course. This guide suposes that you are working in a Microsoft Windows 10 or superior machine given for the university in their labs. This tools are multiplatform so you can install in others machine platforms like Linux or Mac if you need.

1. Requirement Tools
   • Docker Desktop
   • Git
   • Visual Studio Code
   • Azure Data Studio
   • Net 6
   • Python
2. Optional Tools
   • Chocolatey
   • Powershell 7
   • Windows Terminal

---

Requirement Tools

Docker Desktop

1. Open a Powershell terminal in administrator mode.

2. Install Windows components (https://docs.microsoft.com/en-us/windows/wsl/install-manual)

   dism.exe /online /enable-feature /featurename:Microsoft-Windows-Subsystem-Linux /all /norestart
   dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart
   

3. Download WSL kernel update from https://wslstorestorage.blob.core.windows.net/wslblob/wsl_update_x64.msi

   curl -o wsl_update_x64.msi https://wslstorestorage.blob.core.windows.net/wslblob/wsl_update_x64.msi
   

4. Restart the machine.

   shutdown /r /t 0
   

5. Open again a Powershell terminal in administrator mode and

   .\wsl_update_x64.msi /quiet
   

6. Set WSL version

   wsl --set-default-version 2
   

7. Install ubuntu Subsytem

   WinGet

   winget install Canonical.Ubuntu.2204
   

   Chocolatey

   choco install wsl-ubuntu-2204
   

   Or download and install from https://aka.ms/wslubuntu2204

8. Verify ubuntu Subsytem installed and use versión 2

   wsl -l -v
   

   This show something like this:

   NAME STATE VERSION

   • Ubuntu-22.04 Stopped 2

   if not, start ubuntu subsytem in Windows and make necessary configurations, after re run prior command.

9. Install Docker Desktop

   WinGet

   winget install Docker.DockerDesktop
   

   Chocolatey

   choco install docker-desktop
   

10. logoff the machine.

    logoff
    

Git

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Git.Git
   

   Chocolatey

   choco install git-scm
   

   Or download and install from [https://git-scm.com/downloads]

Visual Studio Code

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Microsoft.VisualStudioCode
   

   Chocolatey

   choco install Microsoft.VisualStudioCode
   

   Or download and install from [https://code.visualstudio.com/download]

Azure Data Studio

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Microsoft.AzureDataStudio
   

   Chocolatey

   choco install azure-data-studio
   

   Or download and install from [https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio?view=sql-server-ver16]

Net 6

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Microsoft.DotNet.SDK.6
   

   Chocolatey

   choco install Microsoft.DotNet.SDK.6
   

   Or download and install from [https://dotnet.microsoft.com/en-us/download/dotnet/6.0]

Python

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Microsoft.AzureDataStudio
   

   Chocolatey

   choco install azure-data-studio
   

   Or download and install from [https://www.python.org/downloads/]

---

Optional Tools

Chocolatey

1. Open a Powershell terminal in administrator mode and run the following command. (https://chocolatey.org/install)

Set-ExecutionPolicy Bypass -Scope Process -Force; [System.Net.ServicePointManager]::SecurityProtocol = [System.Net.ServicePointManager]::SecurityProtocol -bor 3072; iex ((New-Object System.Net.WebClient).DownloadString('https://community.chocolatey.org/install.ps1'))

Powershell 7

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Microsoft.Powershell
   

   Chocolatey

   choco install microsoft-powershell
   

2. Close this powershell and open a Powershell 7 terminal in administrator mode and run the following command.

   Install-Module PSReadLine -Force
   

3. Edit powershell profile file.

   notepad $PROFILE
   

4. Add the following text to set command history search.

   Import-Module PSReadLine
   Set-PSReadLineOption -PredictionSource History
   Set-PSReadLineOption -PredictionViewStyle ListView
   Set-PSReadLineOption -EditMode Windows
   

5. Save changes and close editor.

6. Finally, close and reopen Powershell 7.

Windows Terminal

1. Open a Powershell terminal in administrator mode and run the following command.

   WinGet

   winget install Microsoft.WindowsTerminal
   

   Chocolatey

   choco install microsoft-windows-terminal