Supercharge your Azure SQL deployments by operationalizing Azure with DevOps Workshop Modules 1. Configure your Local Environment 1.1. Azure PowerShell 1.2. Setup Git for Windows 1.3 Setup Visual Studio Code 1.4 Visual Studio - SSDT 1.5 SSMS (optional) 1.6 Azure Data Studio (optional) 1.7 Install sqlpackage for Windows 1.8 Version Check and Configuration 2. Configure your DevOps Environment 2.1. Azure Resource groups 2.2. Azure AD Service Principles 2.3. Access Control (IAM) 2.4. Azure DevOps Organizations 2.5. Azure DevOps Project 2.7. Branching 2.8. DevOps Service connections - Azure Resource Manager 2.9. Push files to Repository 2.10. Performing your initial Commit using VS Code 3. Deploy Azure Resources 3.1 Advanced ARM template 3.2. Build dev pipeline (CI) 3.2.1 Configure dev continuous integration 3.2.2 Testing dev Azure resource CI pipeline 3.3 Dev release pipeline (CD) 3.3.1 Configure Key Vault deployment task 3.3.2 Configure SQL DB deployment task 3.3.3 Configure PowerShell task 3.3.4 Configure Azure PowerShell task 3.3.5 Configure prod CI/CD pipelines 3.3.6 Create & configure Prod build pipeline (CI) 3.3.7 Create & configure Prod release pipeline (CD) 3.4 Pull request 3.4.1 Review Prod CI/CD 4. Database life cycle Management 4.1 Initial SSDT project setup 4.2 Get to know SSDT database projects 4.3 Build your database project 4.4 Load data your local DB 4.5 Dev Database Build Pipeline (CI) 4.6 Dev Database Release Pipeline (CD) 4.6.1 Configure Azure SQL DacpacTask 4.6.2 Challenge - Firewall rule 4.7 Postdeployment Script (CI) 4.8 Configure prod CI/CD - Challenge
