Login
Learn with AzurePlayer/Essentials of database projects with SSDT
Buy now

  • $99

Essentials of database projects with SSDT

  • Course
  • 37 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 28 videos, quiz on each module and many code examples. 
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 all foundamentals of working with the SSDT (SQL Server Data Tools).
After completing the course, the participant will gain end-to-end knowledge in the field of Microsoft SQL Server database code versioning, releases and the ability to automate the publication process within Azure DevOps.

What's in the Course?

  • 28 videos (7 hours) demonstrations
  • Theory and practical foundations
  • How to start?
  • Good practices
  • Practices from the field
  • Full training for beginners
  • Trainer with practice experience and certificates
  • Slide decks to download
  • Code examples
  • 20 questions in Quizzes
  • Learn everything in just 4 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.

🥇 Satisfaction guaranteed

You get a 15-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

Working with SSDT in Visual Studio

  • Installing SSDT
  • Database project
  • Variables
  • Properties
  • Settings

Import of an existing database

  • Import from SQL Server
  • Database references
  • References to system databases
  • 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

Contents

Module 1

Introduction & Installation
Welcome
Structure of the course
Module 1: Files

Module 2

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

Module 3

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

Module 4

Comparing and Publishing
Introduction
Preview
Generating a differential script
Publishing changes and settings
Publication profiles
Pre/Post Deployment scripts in practice
Summary
Module 4: Quiz
Module 4: Files

Module 5

Azure DevOps and CI/CD
Introduction
Preview
Sqlpackage.exe and its options
Publishing with Sqlpackage (PowerShell)
Preview
Building CI / CD in Azure DevOps
Releasing a new version (Release)
Publication for another environment (stage)
Summary
Module 5: Quiz
Module 5: 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 5 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 4 weeks, 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

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!