Training & Exams

Developing High Quality Databases Using Visual Studio 2017.

About This Course

Course Code
QADHQDVS17

Course Type
Premium

Vendor
Agile and Scrum

Duration
2 Days

RRP
£1,750.00

Course Overview
Download

Overview

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.

Who Should Attend
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.

Objectives

Through a combination of instructor-led training and hands-on activities you will learn how to use Visual Studio 2017 and the integrated SQL Server Data Tools SSDT to manage the development of high-quality SQL Server databases. Specifically, attendees will be exposed to :

Course Outline

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

Prerequisites

This course is intended for practitioners who are comfortable with the concepts of designing, developing, testing, and deploying SQL Server databases.

About This Course

Course Code
QADHQDVS17

Course Type
Premium

Vendor
Agile and Scrum

Duration
2 Days

RRP
£1,750.00

Course Overview
Download