Learning Path Details

Description:

The course covers using SQL Server Data Tools (SSDT) to design and build databases, and deploy them to SQL Server and to Azure SQL.

Key Takeaways:

We are introduced to SQL Server Data Tools to create a database including tables, views, and stored procedures, and publishing (and updating) the database to SQL Server. We learn how to import an existing database from SQL Server, and how to publish changes and bring in external changes. We cover the basics of source control, refactoring, automated deployments and pre/post scripts.

Technologies Learned:

• DevOps;
• SQL Server;
• SQL Server Data Tools;

This learning resource was completed on 8/5/2021.