Git Mini-Course - Introduction

Git Mini-Course - Introduction

Preview unavailable

You must log in or sign up to view this lesson.

Database projects with SQL Server Data Tools (SSDT)

Buy nowLearn more

Module 1

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

Module 2

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

Module 3

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

Module 4

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

Module 5

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

Module 6

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

Module 7

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

Module 8

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

Module 9

Delayed 56 days

Introduction

Circular references

Security & DevSecOps

SQL Agent Jobs

Selective publication

Summary

Module 9: Quiz

Module 9: Files