Essentials of database projects with SSDT
- Buy now
- Learn more
Module 1

Welcome
Structure of the course
Module 1: Files
Module 2

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
Module 3

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
Module 4

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
Module 5

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

Module 2

Working with SSDT in Visual Studio

8 Lessons