Database projects with SQL Server Data Tools (SSDT)

$195

Database projects with SQL Server Data Tools (SSDT)

Course
82 Lessons

Work on your database project like on any other application. Build, rename, debug, test and publish automatically with CI/CD using Azure DevOps.

This course contains 64 videos, quiz on each module and many code examples.
If you want to receive a few emails with free materials, tips and tricks (8 emails in total, one per week) - sign up on this site: SSDT Tips & Tricks.

Buy now

👨‍🎓 Course Overview

The most comprehensive database management course on the market. Provided in an accessible, well-organized and accurate manner. The participant will learn not only about all aspects of working with the SSDT (SQL Server Data Tools), but will also undergo accelerated training in the field of GIT and DevOps aspects.

After completing the course, the participant will gain comprehensive knowledge in the field of Microsoft SQL Server database code versioning, releases and the ability to automate the publication process.

An additional module presents the most common scenarios and how to deal with problems.
If you prefer, you can learn from Polish edition of this course.

What's in the Course?

64 videos (20 hours) demonstrations
9 modules / weeks
Theory and practical foundations
How to start?
How others do it?
Good practices
Tips & Tricks
Practices from the field
End to end scenario
Trainer with practice experience and certificates
Slide decks to download
Code examples
Over 100 questions in Quizzes
Learn everything in just 9 weeks!

Yes, I take it! I'm decided

Start date

The sale is open continuously until further notice.
The course will start for you from the moment you buy it. Then you will have access to the first module, a week later to the next one, and so on.

Slack Channel

You will get access to a closed group on Slack where you will be able to contact the author of the course and talk to other course participants, ask for advice, opinion, comment.

Priceless, but included in the price!

👉 That sounds great, I'm in it!!! 👈

🥇 Satisfaction guaranteed

You get a 30-day satisfaction guarantee, thanks to which you can test the course and decide whether the form of this course I have prepared is right for you and whether you achieve the right results.

If for ANY reason you want to quit the course - simply write to kamil@azureplayer.net and I will refund your money.

No discussion, no forms, no unnecessary formalities. Just one email.

As you can see - you risk nothing.

You can only gain! Try it out.

Taking lifetime access to the course! Without risk!

Course agenda

Introduction & Installation

Installing SSDT
State vs Migration
Tools
Automation
DevOps

Versioning with GIT

Git
Tools
Cloning
Commands
Branches
Pull Request

Working with SSDT in Visual Studio

Database project
Variables
Properties
Settings

Import of an existing database

Import from SQL Server
Import from T-SQL
Import from DACPAC
References
Warnings

Comparing and Publishing

Schema Compare
Data Compare
Snapshot
Migration script
Publish
Publication profile
Pre/Post Deployment
Data Scripting

Azure DevOps and CI/CD

Command line
SQLPackage
PowerShell
Generate report
Azure DevOps
CI/CD
Build Pipeline
Release Pipeline
Stages

Unit tests

Unit Tests
Visual Studio
tSQLt
Reporting results

Tips, Tricks & Troubleshooting

Troubleshooting
System references
SSISDB Catalog
Indexes
Rebuilds
SQL Server On-Prem
Azure SQL Database

Advanced

Circular references
Security
DevSecOps
SQL Agent Jobs
Selective publication

Module 1

Introduction & Installation

Welcome and introduction

25 mins
97.1 MB

Preview

Installing SSDT

12 mins
97.7 MB

Two approaches: State vs Migration

8 mins
27.6 MB

Tools comparison

15 mins
73.6 MB

Automation, DevOps, CI/CD

21 mins
74.6 MB

Summary

3 mins
6.65 MB

Preview

Module 1: Quiz

Module 1: Files

Module 2

Versioning fundamentals with GIT

Git Mini-Course - Introduction

19 mins
59.5 MB

Installation of utilities

26 mins
397 MB

Project cloning

10 mins
182 MB

Create a new project

9 mins
56.3 MB

Preview

Basic commands (PULL, COMMIT, PUSH)

11 mins
69.9 MB

New developer branch

9 mins
57.8 MB

Pull Request and MERGE to the master branch

12 mins
98.1 MB

Summary

3 mins
10 MB

Module 2: Quiz

Module 2: Files

Module 3

Working with SSDT in Visual Studio

Introduction

5 mins
20.2 MB

Create and work with a database project

26 mins
257 MB

Variables in the project and their roles

19 mins
205 MB

Project properties and database settings

18 mins
276 MB

Summary

3 mins
8.09 MB

Preview

Module 3: Quiz

Module 3: Files

Module 4

Import of an existing database

Introduction

6 mins
19.5 MB

Preview

Database import directly from SQL server

31 mins
342 MB

Database import from script and DACPAC file

23 mins
322 MB

Database references

34 mins
520 MB

Warnings

15 mins
248 MB

Summary

3 mins
8.25 MB

Module 4: Quiz

Module 4: Files

Module 5

Comparing and Publishing

Introduction

13 mins
41.7 MB

Preview

Tools: Schema Compare

23 mins
286 MB

Snapshot of database project

6 mins
34.2 MB

Tools: Data Compare

19 mins
281 MB

Generating a differential script

21 mins
246 MB

Publishing changes and settings

22 mins
450 MB

Publication profiles

24 mins
242 MB

Pre/Post Deployment scripts in practice

33 mins
334 MB

Data scripting and publication

28 mins
352 MB

Summary

4 mins
9.75 MB

Module 5: Quiz

Module 5: Files

Module 6

Azure DevOps and CI/CD

Introduction

12 mins
37.7 MB

Preview

Publishing with Sqlpackage (CMD)

19 mins
393 MB

Publishing with Sqlpackage (PowerShell)

16 mins
154 MB

Preview

Generating the script and report (PowerShell)

16 mins
401 MB

Building CI / CD in Azure DevOps

31 mins
218 MB

Releasing a new version (Release)

29 mins
301 MB

Report in Release Pipeline (CD)

20 mins
124 MB

Publication for another environment (stage)

12 mins
82.6 MB

Summary

2 mins
4.77 MB

Module 6: Quiz

Module 6: Files

Module 7

Unit Tests

Introduction

26 mins
74.6 MB

Unit Test - developing in Visual Studio

50 mins
385 MB

Unit Test - developing with tSQLt

35 mins
365 MB

Running tests and reporting results

39 mins
399 MB

Summary

6 mins
20.9 MB

Module 7: Quiz

Module 7: Files

Module 8

Tips, Tricks & Troubleshooting

Introduction

3 mins
8.97 MB

Preview

Effective troubleshooting

16 mins
256 MB

References to system databases

16 mins
122 MB

SSIS packages and references to SSISDB

23 mins
240 MB

Reference to the same database

8 mins
73.1 MB

Rebuilding large indexes

19 mins
201 MB

Splitting a column of data

42 mins
494 MB

SQL Server On-Prem VS Azure

20 mins
192 MB

Summary

3 mins
6.51 MB

Module 8: Quiz

Module 8: Files

Module 9

Advanced

Introduction

3 mins
6.25 MB

Preview

Circular references

38 mins
188 MB

Security & DevSecOps

53 mins
534 MB

SQL Agent Jobs

37 mins
494 MB

Selective publication

14 mins
225 MB

Summary

4 mins
8.27 MB

Module 9: Quiz

Module 9: Files

FAQs

How long will I have access to the course?

Immediately after purchasing the order, you will have access to the platform and the course for an indefinite period. Even if the platform were to disappear in the future - the course will be transferred to another one or made available to the public.

Are there any additional costs?

Absolutely not. There are no additional costs and no hidden fees. You pay once, use it at will.

When does the course start?

It's up to you, at the moment. Now, the course is available at any time: you decide when is the best time for you to study. Quite simply: you buy a course and get access.

Will I receive an invoice for this course?

Yes. As a self-employed person, I issue the invoice without VAT. You will be asked to provide your data after paying for the course. The invoice will be available for download in the "Learn with AzurePlayer" platform.

How long will it take me to complete this course?

The course is spread over 9 modules, each with several lessons. Modules will be made available every week from the start of the course. All this so that you do not feel overwhelmed by the amount of information, and the learning is spread over time. Therefore, with regular study of the course (e.g. at the weekend pace), you should be able to complete the entire course in less than 3 months, without any haste.

Can I access all course modules right away?

Yes, although it is not recommended. The course is divided into modules that are offered weekly. The order of the modules is also not accidental. All this means that completing the course week after week, at the indicated pace and sequence - significantly increases the probability of completing the study with great success, i.e. learning the entire material with an acceptable effort.
However, I understand that each of us may be in a different situation: maybe you have a vacation where you would like to go through the entire course. Or you already have some knowledge that you want to complete by opening only selected lessons or modules.
There are also two further disadvantages of this solution:
1) you will not receive weekly email notifications about the availability of new modules;
2) you forfeit your course refund guarantee (although I assume your purchase was a well-thought-out decision and you won't need an alternative like this).
If you are still convinced that you want access to all modules - reach me out (email or via the platform) and I will provide you with all the lessons of the course.

Is this instructor-led or a series of videos to watch?

The course is set of videos and presentations, self-pace to learn.

What software and licenses I need on my laptop to take this course?

You don't need any paid licences. Everything what you need to begin the course and learn is free:
- Visual Studio (Community edition)
- Azure DevOps (free up to 5 users)
- Visual Studio Code
- PowerShell

Do you have a different question?

Go ahead, write to me: kamil@azureplayer.net

Kamil Nowinski

Microsoft Data Platform MVP.
Blogger, speaker, #sqlfamily member. Data passionate, Big data engineer and data architect. An originator of the "Ask SQL Family" podcast and founder of AzurePlayer blog. Friend of Redgate.
Azure DevOps Engineer Expert.

X Facebook Linked_in Youtube Website

Say no more. I want to buy NOW!