Login
Learn with AzurePlayer/Database projects with SQL Server Data Tools (SSDT)
Buy now

  • $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

Contents

Module 1

Introduction & Installation
Welcome and introduction
Preview
Installing SSDT
Two approaches: State vs Migration
Tools comparison
Automation, DevOps, CI/CD
Summary
Preview
Module 1: Quiz
Module 1: Files

Module 2

Versioning fundamentals with GIT
Git Mini-Course - Introduction
Installation of utilities
Project cloning
Create a new project
Preview
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

Working with SSDT in Visual Studio
Introduction
Create and work with a database project
Variables in the project and their roles
Project properties and database settings
Summary
Preview
Module 3: Quiz
Module 3: Files

Module 4

Import of an existing database
Introduction
Preview
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

Comparing and Publishing
Introduction
Preview
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

Azure DevOps and CI/CD
Introduction
Preview
Publishing with Sqlpackage (CMD)
Publishing with Sqlpackage (PowerShell)
Preview
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

Unit Tests
Introduction
Unit Test - developing in Visual Studio
Unit Test - developing with tSQLt
Running tests and reporting results
Summary
Module 7: Quiz
Module 7: Files

Module 8

Tips, Tricks & Troubleshooting
Introduction
Preview
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

Advanced
Introduction
Preview
Circular references
Security & DevSecOps
SQL Agent Jobs
Selective publication
Summary
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.
XFacebookLinked_inYoutubeWebsite
Say no more. I want to buy NOW!