Join Joey D'Antoni for an in-depth discussion in this video Tools and techniques, part of SQL Server: Developer and DBA Collaboration.
- [Instructor] So some of the tools you'll need to follow along with this demos in this course include SQL Server 2017 Developer Edition. If SQL Server 2019 is out by the time you're watching this course, that is also acceptable. SQL Server Management Studio, WideWorldImporters database, which is the sample database we'll use for a couple of queries, and then finally Visual Studio 2017, specifically, Enterprise Edition with data storage and processing component. You can use one of the free editions like Community Edition, however, there's a demo at the end that is limited to Enterprise Edition.
- Schema design
- Building good queries
- Writing stored procedures
- Building a CI/CD pipeline for database deployment