Delivering High Quality Databases Using Visual Studio


Course Number: VS-116

Duration: 2 days (13 hours)

Format: Live, hands-on

Databases Using Visual Studio Training Overview

This in-person or live, online Delivering High Quality Databases Using Visual Studio training course teaches developers how to develop, test, and deliver modern SQL Server databases using Agile practices. Attendees learn how to manage changes to the database schema and ensure quality through T-SQL unit testing and static code analysis. Students also learn how to automate the building and deploying of SQL Server databases. 

This Visual Studio class may be taught using Visual Studio 2019, 2022, or later.

Location and Pricing

Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.

In addition, some Microsoft courses are available as live, online classes for individuals.

Objectives

  • Understand Agile database development
  • Apply Agile database development techniques
  • Set up SQL Server database projects
  • Understand the modern database development lifecycle
  • Manage database project activities and tasks
  • Integrate with Azure DevOps (Azure Repos)
  • Use Git to manage schema changes
  • Apply SQL Server unit testing principles
  • Test stored procedures, functions, and triggers
  • Use tSQLt for SQL Server unit testing
  • Generate test data and conduct tests using this data
  • Integrate with Azure Pipelines
  • Run SQL Server unit tests in a pipeline
  • Build and deploy your SQL Server project
  • Practice Continuous Integration/Continuous Delivery (CI/CD)

Prerequisites

  • This course is for database developers and administrators with experience working with modern versions of SQL Server or Azure SQL.
  • Attendees should have experience working on a team-based software development project; familiarity with their organization’s development lifecycle and practices would be beneficial.
  • All students should be practitioners who are comfortable with the concepts of developing, testing, and deploying SQL Server databases.

Outline

Expand All | Collapse All

Agile Database Development
  • Agile database development overview
  • Agility challenges and blockers
  • SQL Server Data Tools overview
  • Connected vs. disconnected development
  • Imperative vs. declarative development
  • Agile database techniques
SQL Server Database Projects
  • Creating a SQL Server database project
  • Treating schema as source code
  • Working with SQL Server Object Explorer
  • Importing database schema
  • Importing data-tier applications (.dacpac)
  • Importing scripts
  • Managing cross-database dependencies
  • Referencing a database and .dacpac file
Managing Schema Changes
  • Azure DevOps overview
  • Azure Repos overview
  • Using Git to manage schema changes
  • Cloning, committing, pushing, and pulling
  • Comparing schemas and sync’ing changes
  • Comparing data and sync’ing changes
  • Rolling back changes using Git
  • Rolling back changes using project snapshots
Assuring a High-Quality Design
  • Database unit testing principles
  • Levels of database unit testing
  • SQL Server unit tests
  • Database unit test designer
  • T-SQL assertions vs. test conditions
  • Using tSQLt for SQL Server unit testing
  • Static code analysis
  • Database refactoring tools
Building and Deploying
  • Building the database project
  • Using pre-build and post-build events
  • Including additional build scripts
  • Using script build actions
  • Using the LocalDB isolated sandbox
  • Deploying changes to SQL Server
  • Creating and using publishing profiles
  • Using pre and post deployment scripts
  • Using SQLCMD variables within scripts
  • Building/deploying composite projects
  • Building/deploying SQL CLR objects
  • Azure Pipelines overview
  • Using an automated build pipeline
  • Practicing Continuous Integration (CI)
  • Using an automated release pipeline
  • Running tests in the release pipeline
  • Practicing Continuous Delivery (CD)
Conclusion

Training Materials

All Delivering High Quality Databases Using Visual Studio training students receive comprehensive courseware.

Software Requirements

  • Visual Studio 2019, 2022, or later with the latest updates
  • An instance of SQL Server 2019 or later (earlier versions can be accommodated upon request)
  • Access to an Azure DevOps Server instance
  • Related lab files that Accelebrate would provide


Learn faster

Our live, instructor-led lectures are far more effective than pre-recorded classes

Satisfaction guarantee

If your team is not 100% satisfied with your training, we do what's necessary to make it right

Learn online from anywhere

Whether you are at home or in the office, we make learning interactive and engaging

Multiple Payment Options

We accept check, ACH/EFT, major credit cards, and most purchase orders



Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan