Developing High Quality Databases Using Visual Studio

SSDT | 2 Days

This two-day, instructor-led course provides students with the knowledge and skills to effectively design, develop, 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 SQL Server 2005 and newer versions. 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 designing, developing, testing, and deploying SQL Server databases.

Modules

  1. Introduction to SQL Server Data Tools
  2. Team Projects
  3. SQL Server Database Projects
  4. Managing Schema Changes
  5. Assuring a High-Quality Design
  6. Building and Deploying Changes
  7. Advanced Topics

Level: Intermediate

SQL Server development experience required

Detailed Outlines

pdf
Visual Studio 2017