- WSL2 (Windows only)
- Ubuntu 24.04 installed in WSL (Windows only)
- Windows Terminal (Windows only)
- VS Code
- VS Code extensions
- Oracle account for FreeSQL access
We will use WSL2 as the Linux environment for the course, with Ubuntu 24.04 as the standard Linux distribution. Please follow Microsoft's official WSL installation guide and install Ubuntu 24.04 when prompted, or use the distro-specific install command shown there.
- Official install guide: Install WSL
Note: If you already have an older Ubuntu WSL installation, do not rely on it for the course unless instructed otherwise.
We recommend Windows Terminal as the main terminal application for the course. It provides a better command-line experience for working with PowerShell and WSL than the older Windows console.
- Official install page: Install Windows Terminal
We will use Visual Studio Code (VS Code) as the main editor for Linux scripts, SQL work, and C++ code. Please install the Windows version from the official download page.
- Official download page: Download Visual Studio Code
Please install the WSL extension for VS Code. This allows VS Code on Windows to open and edit files directly inside the Linux environment running under WSL.
- Extension page: VS Code WSL Extension
- Microsoft guide: Use VS Code with WSL
Please install the C/C++ extension for VS Code. We will use it for the C++ part of the training.
- Extension page: C/C++ for VS Code
- Microsoft overview: C/C++ in VS Code
For the C++ compiler, install the latest version of MSYS2 for Windows.
- Download msys2-x86_64-20260322.exe from:
- Install it, use recommended configuration, and open MSYS2 terminal
- Run: pacman -S mingw-w64-x86_64-gcc
- Add this folder to your PATH: C:\msys64\mingw64\bin
Please install Oracle SQL Developer for VS Code. We will use it for Oracle SQL and PL/SQL exercises.
- Official page: Oracle SQL Developer for VS Code
- Download / marketplace page: Install SQL Developer for VS Code
Please create an Oracle account before the course. This will be needed to access Oracle's online SQL environment and related training tools.
- Create account: Create an Oracle Account
For the Oracle labs, we will use Oracle FreeSQL, which runs in the browser and does not require a local Oracle Database installation on your laptop.
- Official page: Oracle FreeSQL