CF

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: Tim Corey

Tim Corey thumbnail

Tim Corey is the US developer behind iamtimcorey.com and the IAmTimCorey YouTube channel — one of the most prolific independent .NET / C# educators online. He has been publishing weekly .NET content since 2017 and has anchored a generation of working .NET developers' learning path through the platform's evolution from .NET Framework to .NET Core to modern .NET.

The course catalog covers the full .NET stack: C# language fundamentals, ASP.NET Core for web development, Blazor for full-stack C# web applications, Entity Framework Core for data access, MAUI for cross-platform mobile, design patterns and SOLID principles, the testing tracks, Azure deployment, and the broader software-engineering craft topics (debugging, code review, project structure) that most pure-tutorial sources skip.

The CourseFlix listing under this source carries over 14 Tim Corey courses spanning that range. Material is paid and aimed primarily at .NET developers building real production proficiency rather than picking up syntax.

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

Related courses

Frequently asked questions

What prerequisites should I have before taking this course?
You should have a basic understanding of SQL and experience using SQL Server Management Studio (SSMS). Familiarity with version control systems like Git will also be beneficial, though the course will introduce you to integrating databases with Git.
What projects will I work on in this course?
The course includes hands-on projects such as creating a new database, modifying existing databases, and implementing an automated CI/CD pipeline. These projects are designed to enhance your practical skills in database development and deployment using SQL Server Data Tools.
Who is the target audience for this course?
This course is aimed at database developers and administrators who are looking to enhance their skills in DevOps practices specifically tailored for SQL databases. It's also suitable for those who are familiar with SSMS and wish to explore SQL Server Data Tools for more efficient database management.
How does the depth of this course compare to other database DevOps courses?
This course provides a focused exploration of SQL Server Data Tools, covering aspects like source control, refactoring, and automated deployments. While it may not cover every aspect of DevOps or all database systems, it offers a practical and detailed approach to deploying and managing SQL databases efficiently.
What specific tools and platforms will I learn about in this course?
You will learn how to use SQL Server Data Tools (SSDT) for database development, including features like wildcard completion, refactoring, and Intellisense. The course also covers integrating databases with Git for source control and implementing CI/CD pipelines for automated deployments.
What topics are not covered in this course?
The course does not cover advanced SQL programming or database systems other than SQL Server. It also doesn't delve into non-SQL Server platforms or broader DevOps tools beyond those integrated with SQL Server Data Tools and Git.
How much time should I expect to commit to this course?
With 16 lessons, the course is designed to be completed at your own pace. The time commitment will vary based on your prior experience and how much time you can dedicate to the practical exercises, but you should plan for several hours of study and hands-on practice.