1. Essentials of database projects with SSDT

    • Buy now
    • Learn more

  2. Module 1

    • Welcome
    • Structure of the course
    • Module 1: Files

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

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

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

  6. 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
  1. Products
  2. Course
  3. Section
  4. Lesson

Introduction

  1. Essentials of database projects with SSDT

    • Buy now
    • Learn more

  2. Module 1
    • Welcome
    • Structure of the course
    • Module 1: Files
  3. This section is delayed by 0 days.

    Module 2
    • 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
  4. This section is delayed by 7 days.

    Module 3
    • 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
  5. This section is delayed by 14 days.

    Module 4
    • Introduction
    • Generating a differential script
    • Publishing changes and settings
    • Publication profiles
    • Pre/Post Deployment scripts in practice
    • Summary
    • Module 4: Quiz
    • Module 4: Files
  6. This section is delayed by 21 days.

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