South Florida SQL Server Users Group 70-761 Notes

SQL Server 2016 Developer Edition, or SQL Express 2016 for a lighter footprint.

Direct from Microsoft, Middle Link that says Download Now
Direct from Microsoft, Right Link that says Download Now
SQL Server Management Studio Latest Version

Optional Visual Studio and / or SSDT For Full Development of SSIS packages

Download Visual Studio Community Edition
Download SQL Server Data Tools (SSDT)
Download The Lab Files to Install the create the sample tables or sample database

Azure is a great option regardless of your operating system

SQL Server Management Studio Latest Version

Get $200 dollars in Developer Credits(~25 month) for one year
Then Go to your portal, and add a Resource Group, Create a New Server and SQL database. make sure you pin stuff to your dashboard.
Make sure you pick the Basic Pricing Tier!!!! The DEFAULT is $150 PER MONTH
Basic is 5.99 plus DTU's, about 11 dollars a month max with decent usage, well under your $25/month limit

Go to the Portal Firewall for the SQL Server and add your current Client IP. every time you connect from "somewhere else", you must go to the portal firewall, and add your current client IP. Connecting from Starbux, Work, Home, anywhere else.

Download The Lab Files to Install the create the sample tables or sample database

VMWare Workstation($~200) or VirtualBox($Free) It takes a while to get a VirtualBox environment set up, since you are installing a VM package, and then installing an operating system, then SQLServer2016, and then SSMS.

you can install a time limited version of a server operating system, or a desktop operating system. The Latest version of VirtualBox
Your Choice of the next two, depending on if you are emulating a work environment or not:

180 day Evaluations: Install something with a GUI(Server 2016/Server 2012R2), not a "Core" which is cmd line and powershell only.
or install a 90 day virtual machine of Windows 10

SQL Server 2016 Developer Edition, or SQL Express 2016 for a lighter footprint.

Direct from Microsoft, Middle Link that says Download Now
Direct from Microsoft, Right Link that says Download Now
SQL Server Management Studio Latest Version

Optional Visual Studio and / or SSDT For Full Development of SSIS packages

Download Visual Studio Community Edition
Download SQL Server Data Tools (SSDT)
Download The Lab Files to Install the create the sample tables or sample database

VirtualBox($Free) is portable in the sense that no installation is required...but it is NOT portable.as soon as you install a machine, that machine is mapped to the F: drive or the X: drive or whatever, and it is a pain to fix if you are using removable media, that might change drive letters.. it's basically use the installer to download a slightly older version of VirtualBox, then the same process as the virtualbox standard. you can install a time limited version of a server operating system, or a desktop operating system. VirtualBox Portable installer
The Latest version of VirtualBox
Your Choice of the next two, depending on if you are emulating a work environment or not:

180 day Evaluations: Install something with a GUI(Server 2016/Server 2012R2), not a "Core" which is cmd line and powershell only.
or install a 90 day virtual machine of Windows 10

SQL Server 2016 Developer Edition, or SQL Express 2016 for a lighter footprint.

Direct from Microsoft, Middle Link that says Download Now
Direct from Microsoft, Right Link that says Download Now
SQL Server Management Studio Latest Version

Optional Visual Studio and / or SSDT For Full Development of SSIS packages

Download Visual Studio Community Edition
Download SQL Server Data Tools (SSDT)
Download The Lab Files to Install the create the sample tables or sample database