Skip to main content

Database DevOps from Start to Finish

2h 40m 37s
English
Paid

Embark on a comprehensive journey through Database DevOps with our expertly designed course! If your experience with databases has been limited to using SQL Server Management Studio (SSMS), you are about to discover a world of new opportunities. Enter SQL Server Data Tools (SSDT) – your go-to for constructing and managing databases with enhanced tools and features.

Why Choose SQL Server Data Tools (SSDT)?

SSDT offers an array of built-in tools that make database development smoother and more efficient. From wildcard completion and refactoring to Intellisense, SSDT is equipped to cater to your development needs. Here's a glimpse of what you will learn:

  • Creating a New Database in SSDT: Start from scratch and build a robust database using the powerful features of SSDT.
  • Modifying an Existing Database: Enhance and modify your databases seamlessly within SSDT.
  • Adding to Source Control with Git: Manage your database changes effectively by integrating with Git for version control.
  • Refactoring: Optimize and organize your database structure for improved performance.
  • Automated CI/CD Pipeline: Implement continuous integration and continuous deployment for your databases to streamline operations.
  • And much more!

Develop Your Skills

As you progress through this course, you'll enhance your SQL development skills and gain a comprehensive understanding of how to manage and deploy SQL databases efficiently and effectively. Our hands-on approach ensures you become a proficient SQL developer.

Get Started With Free Course Introduction Videos

If you're intrigued by what this course offers or need a little more convincing, we invite you to explore the free course introduction videos. These videos are available to give you a taste of the valuable learning experience that awaits you.

About the Author: iamtimcorey.com (Tim Corey)

iamtimcorey.com (Tim Corey) thumbnail
Tim learned software development the hard way - confusing tutorials, the uncertainty of what he was missing, and overall not understanding how to put the pieces together into a "real" application. Now, he teaches you in a way that avoids all of that unnecessary pain and struggle.

Watch Online 16 lessons

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