A special hello if you're visiting this blog post during or after my workshop on Thursday afternoon, April 4 at the Louisiana Tech Park as park of the Activate Conference 2019!
Here are all the links, downloads, and more you need:
Databases 101 for the Aspiring App Dev
Workshop Student Track
1:00 PM
Presentation Downloads:
Slide deck: Download link (.pptx files)
Sample TSQL 101 script: Download link (.sql file)
Links to get setup with MS SQL Server:
This is the link to download SQL for FREE:
- SQL Server 2017 Downloads, click Developer
The tools to dev in the Microsoft ecosystem are all free:
- SSMS (for the SQL Server)
- SSDT (for SSRS, SSIS, SSAS, also for Database Projects) (installs a shell of Visual Studio)
- Visual Studio Community Edition or Visual Studio Code
Download the WideWorldImporters sample database:
- WideWorldImporters-Full.bak (restore to any Edition aside from LocalDB)
Toolbox: Github (.sql files)
- Look for toolbox.zip for an easy download, or
- Click on each file then download, or
- Click on each file, click “raw” on each file to copy/paste