Developing High Quality Databases Using Visual Studio 2017

PT16681
Training Summary
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.
Prerequisites
Before taking this course, students should have had involvement with writing and testing T-SQL code and working with test data. 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.
Duration
2 Days/Lecture & Lab
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.
Course Topics
  • Introduction to SQL Server Data Tools
  • Team Projects
  • SQL Server Database Projects
  • Managing Schema Changes
  • Assuring a High-Quality Design
  • Building and Deploying Changes
  • Advanced Topics

Related Scheduled Courses