• Welcome

• Structure of the course

• Module 1: Files

Delayed 0 days

• Introduction

• Installing SSDT

• Create and work with a database project

• Variables in the project and their roles

• Project properties and database settings

• Summary

• Module 2: Quiz

• Module 2: Files

Delayed 7 days

• Introduction

• Database import directly from SQL server

• Database references

• Reference to the same database

• References to system databases

• Warnings

• Summary

• Module 3: Quiz

• Module 3: Files

Delayed 14 days

• Introduction

• Generating a differential script

• Publishing changes and settings

• Publication profiles

• Pre/Post Deployment scripts in practice

• Summary

• Module 4: Quiz

• Module 4: Files

Delayed 21 days

• Introduction

• Sqlpackage.exe and its options

• Publishing with Sqlpackage (PowerShell)

• Building CI / CD in Azure DevOps

• Releasing a new version (Release)

• Publication for another environment (stage)

• Summary

• Module 5: Quiz

• Module 5: Files