Setting up a lab environment for the course.
- Option 1 (Limited Resources):
- Use a computer, laptop, or workstation with Windows 10 installed.
- Install SQL Server Express directly on Windows 10.
- SQL Server Express requires fewer resources and is compatible with Windows 10.
- Note: Many advanced features covered in the course are not available in SQL Server Express, but it is sufficient for learning basic SQL concepts and statements.
- Recommended Option:
- Use the same computer/laptop with Windows 10 as the host operating system.
- Install virtualization softwSare like VMware Workstation Player or Oracle VirtualBox.
- Virtualization software allows running multiple operating systems on a single hardware device.
- Detailed explanation of virtualization software will be provided in the next lecture.
- Set up a virtual machine on the virtualization software.
- Allocate necessary resources to the virtual machine.
- Install the Windows Server operating system on the virtual machine.
- Install Microsoft SQL Server Enterprise Edition on the Windows Server OS.
- This setup allows exploring all basic and advanced SQL features and statements as part of the lab exercises.