T-SQL for Data Science
Session info: Welcome to the 6th session of the AI42 series! This time we will learn about T-SQL. This is the outline of the session: Tools of the trade We need to decide if we want to store our data in our own environment where we are in full control of security, or move the data to the cloud where we do not have to focus on infrastructure and just the data and our data pipeline. We also need to have a look at what tools we want to use for exploring our data. 1. Cloud vs On-Premises 1.1 Cloud Options 1. Creating an Azure Account and a Azure SQL Database 1.2 On-Premises Options 1.2.1 Installing SQL Server Express/Developer Edition 2. Tools of the Trade (IDE) 2.1 SQL Server Management Studio 2.2 Azure Data Studio 2.3 Visual Studio Code 2.4 Spark SQL in Databricks 3. How to start writing code 3.1 Queries