SSDT | 2 Days
Develop, test, and deliver high-quality SQL Server databases using Visual Studio and SQL Server Data Tools. This two-day course builds your fluency across database projects, schema-change management, T-SQL unit testing and static analysis, and automated build and deployment. You’ll work hands-on the way a real team would.
Who should take this course?
This course is for database developers and administrators working with modern SQL Server or Azure SQL. It’s equally valuable for application developers writing and testing T-SQL who want a disciplined, source-controlled approach to database delivery. Experience developing, testing, and deploying databases on a team is helpful but not required.
Course Content
This course progressively builds your fluency with delivering high-quality databases using Visual Studio and SSDT, from agile database development and database projects to managing schema changes, assuring quality, and automating build and deployment. You’ll work hands-on throughout, the way a real team would.
1. Agile Database Development
- Agile database development overview
- Agility challenges and blockers
- SQL Server Data Tools (SSDT)
- Connected vs. disconnected development
- Imperative vs. declarative development
- Agile database techniques
2. SQL Server Database Projects
- Creating a SQL Server database project
- Treating schema as source code
- Importing schema and .dacpac files
- Importing scripts
- Managing cross-database dependencies
- Database references and the development lifecycle
3. Managing Schema Changes
- Version control with Azure Repos and Git
- Basic Git workflow
- Managing schema changes in source control
- Comparing and syncing schema
- Comparing and syncing data
- Rolling back changes with Git and snapshots
4. Assuring a High-Quality Design
- Database unit testing principles
- Levels of database unit testing
- SQL Server unit tests and the test designer
- T-SQL assertions vs. test conditions
- Using tSQLt for SQL Server unit testing
- Static code analysis
- Database refactoring tools
5. Building and Deploying
- Building the database project
- Pre-build and post-build events and scripts
- The LocalDB isolated sandbox
- Deploying and publishing to SQL Server
- Publishing profiles and SQLCMD variables
- Composite projects and SQL CLR objects
- Pipeline integration: CI and CD