Preview unavailable

Delayed 0 days

• Welcome and introduction

• Installing SSDT

• Two approaches: State vs Migration

• Tools comparison

• Automation, DevOps, CI/CD

• Summary

• Module 1: Quiz

• Module 1: Files

Delayed 7 days

• Git Mini-Course - Introduction

• Installation of utilities

• Project cloning

• Create a new project

• Basic commands (PULL, COMMIT, PUSH)

• New developer branch

• Pull Request and MERGE to the master branch

• Summary

• Module 2: Quiz

• Module 2: Files

Delayed 14 days

• Introduction

• Create and work with a database project

• Variables in the project and their roles

• Project properties and database settings

• Summary

• Module 3: Quiz

• Module 3: Files

Delayed 21 days

• Introduction

• Database import directly from SQL server

• Database import from script and DACPAC file

• Database references

• Warnings

• Summary

• Module 4: Quiz

• Module 4: Files

Delayed 28 days

• Introduction

• Tools: Schema Compare

• Snapshot of database project

• Tools: Data Compare

• Generating a differential script

• Publishing changes and settings

• Publication profiles

• Pre/Post Deployment scripts in practice

• Data scripting and publication

• Summary

• Module 5: Quiz

• Module 5: Files

Delayed 35 days

• Introduction

• Publishing with Sqlpackage (CMD)

• Publishing with Sqlpackage (PowerShell)

• Generating the script and report (PowerShell)

• Building CI / CD in Azure DevOps

• Releasing a new version (Release)

• Report in Release Pipeline (CD)

• Publication for another environment (stage)

• Summary

• Module 6: Quiz

• Module 6: Files

Delayed 42 days

• Introduction

• Unit Test - developing in Visual Studio2

• Unit Test - developing with tSQLt

• Running tests and reporting results

• Summary

• Module 7: Quiz

• Module 7: Files

Delayed 49 days

• Introduction

• Effective troubleshooting

• References to system databases

• SSIS packages and references to SSISDB

• Reference to the same database

• Rebuilding large indexes

• Splitting a column of data

• SQL Server On-Prem VS Azure

• Summary

• Module 8: Quiz

• Module 8: Files

Delayed 56 days

• Introduction

• Circular references

• Security & DevSecOps

• SQL Agent Jobs

• Selective publication

• Summary

• Module 9: Quiz

• Module 9: Files