Delivering High Quality Databases Using Visual Studio

SSDT | 2 Days

This two-day, instructor-led course provides students with the knowledge and skills to effectively develop, test, and deliver modern SQL Server databases. Student will experience how to manage changes to database schema, ensure quality through T-SQL unit testing and static code analysis, and automate the building and deploying of SQL Server databases.

Audience

This  course is intended for database developers and administrators working with modern versions of SQL Server or SQL Azure. Application developers who are involved with writing and testing T-SQL code and working with test data will also find value from this course. It would also be beneficial if the student has worked on a team-based software development project and is familiar with their organization’s development lifecycle and practices. This course is intended for practitioners who are comfortable with the concepts of developing, testing, and deploying SQL Server databases.

Modules

  1. Agile Database Development
  2. SQL Server Database Projects
  3. Managing Schema Changes
  4. Assuring a High-Quality Design
  5. Building and Deploying

Level: Intermediate

SQL Server development experience required

Outline

pdf
Visual Studio 2022
pdf
Visual Studio 2019