Database DevOps from Start to Finish

2h 40m 37s
English
Paid

Course description

If you have only ever built a database using SQL Server Management Studio (SSMS), you are in for a treat. SQL Server Data Tools (SSDT) is designed for building databases.

Read more about the course

It has tools built-in for wildcard completion, refactoring, Intellisense, and more. In this course, we will cover the following topics:

  • Creating a new database in SSDT
  • Modifying an existing database with SSDT
  • Adding a database to source control (using git)
  • Refactoring a database
  • Enacting an automated CI/CD pipeline for our database
  • And more...

Along the way, you will become a better SQL developer and have a better grasp on how to manage and deploy a SQL database efficiently and effectively.

If that sounds like something you could benefit from, or if you are still not sure, check out the course introduction videos, which are free to view.

Watch Online

This is a demo lesson (10:00 remaining)

You can watch up to 10 minutes for free. Subscribe to unlock all 16 lessons in this course and access 10,000+ hours of premium content across all courses.

View Pricing
0:00
/
#1: Course Overview

All Course Lessons (16)

#Lesson TitleDurationAccess
1
Course Overview Demo
03:40
2
Introduction to SQL Server Data Tools
04:53
3
Project Setup
09:13
4
Table Creation
18:48
5
View Creation
06:53
6
Stored Procedure Creation
07:49
7
Publishing the Database
15:49
8
Updating the Database
12:54
9
Importing the Database
06:59
10
Publishing Changes
04:39
11
Bring in External Changes
12:35
12
Source Control
08:02
13
Refactoring
10:44
14
Automated Deployments
23:37
15
Pre/Post Scripts
13:27
16
Conclusion
00:35

Unlock unlimited learning

Get instant access to all 15 lessons in this course, plus thousands of other premium courses. One subscription, unlimited knowledge.

Learn more about subscription

Comments

0 comments

Want to join the conversation?

Sign in to comment

Similar courses

Grokking SQL for Tech Interviews

Grokking SQL for Tech Interviews

Sources: DesignGurus.io
The course will help you confidently prepare for technical interviews by studying the basics of SQL and 75 popular questions. Delve into the concepts and be...
100 Days Of Code: The Complete Web Development Bootcamp 2024

100 Days Of Code: The Complete Web Development Bootcamp 2024

Sources: Academind Pro
Learn web development from A to Z in 100 days (or at your own pace) - from "basic" to "advanced", it's all included!
78 hours 51 minutes 55 seconds
SQL - The Complete Guide (MySQL, PostgreSQL & more)

SQL - The Complete Guide (MySQL, PostgreSQL & more)

Sources: Academind Pro
SQL is THE most important query language you can learn! It's used by many popular database management systems like MySQL or PostgreSQL. But it's also used by data analysis and b...
19 hours 35 minutes 38 seconds
Master SQL Queries From Basic to Advanced

Master SQL Queries From Basic to Advanced

Sources: Kamran Ahmed
The course is designed for developers, data analysts, and anyone working with databases. It covers the entire range of SQL queries - from basics to advanced...
SQL and PostgreSQL: The Complete Developer's Guide

SQL and PostgreSQL: The Complete Developer's Guide

Sources: udemy, Stephen Grider
SQL and PostgreSQL: The Complete developer’s Guide is a comprehensive SQL language training course and PostgreSQL database management system . Nowadays, all app
22 hours 1 minute