Instructor-led training

Delivering High-Quality Databases Using Visual Studio 2022 Training in Laguna Niguel, California

Data training from Hartmann Software Group, delivered onsite in Laguna Niguel, California or live online.

Request a Training Proposal View Course Outline

What you'll learn

This two-day, instructor-led course provides students with the knowledge and skills to effectively develop, test, and deliver modern SQL Server databases. Students will experience how to manage changes to a database schema, ensure quality through T-SQL unit testing and static code analysis, and automate the build and deployment of SQL Server and Azure SQL databases.

Who should take this class?

This course is intended for database developers and administrators working with modern versions of SQL Server or Azure SQL. Application developers who are involved with writing and testing T-SQL code and working with test data will also find value.

Prerequisites

Attendees should have experience developing, testing, and deploying SQL Server databases.

Course Outline

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

Training locations

Delivering High-Quality Databases Using Visual Studio 2022 training across the U.S. and beyond.

We provide Delivering High-Quality Databases Using Visual Studio 2022 training onsite and live online for organizations throughout the United States and internationally.

View all Delivering High-Quality Databases Using Visual Studio 2022 training locations

Ready to train your team?

Let's customize this training for your organization.

Tell us about your employees, your goals, and your preferred schedule. We'll prepare a training proposal covering scope, delivery format, and pricing.

Request a Training Proposal

or call 303.377.6176