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, we offer some courses as live, instructor-led 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
