دوره آموزش Microsoft Azure DevOps for SQL Server Developers

        o  Basic understanding of Git   

  o  DBAs   

  o  Data Platform Engineers   

           o  DevOps Engineers      

  o  Manage database schemas and static data in Git using modern SQL Database Projects   

       o  Use command-line utilities for automation   

        o  Build automated CI pipelines to validate, test, and package database changes   

          o  Choose between state-based and migration-based deployment strategies   

         o  Write and run automated database unit tests   

        o  Implement safe release pipelines   

        o  Monitor database health and performance   

        o  Use containerized SQL Server for isolated build and test environments   

         o  Why Database DevOps is different   

         o  Common anti-patterns in database change management   

         o  Business case for Database DevOps   

         o  State-based vs. Migration-based deployments   

         o  Hybrid strategies   

         o  The Database DevOps lifecycle    

         o  Structuring a database repository    

         o  SDK-style SQL Projects    

         o  Command-line utilities for automation    

         o  Modern IDE Git integration    

          o  Managing static (reference) data    

         o  Branching strategies for databases    

         o  Pull requests and code reviews for SQL scripts using Azure Repos    

         o  Automating database builds with Azure Pipelines YAML    

         o  Running SQL Server in Docker containers for CI pipelines    

         o  Building SDK-style projects    

         o  Generating and validating deployment plans    

         o  Run validation queries and pre-deployment checks    

         o  Seed test data    

         o  Advanced DACPAC patterns    

         o  Publishing build artifacts    

·

      Continuous Testing for Databases  

         o  The testing models for databases    

         o  Deep dive into tSQLt    

         o  Advanced tSQLt techniques    

         o  DBA operational tests    

         o  Running tSQLt tests in pipelines    

         o  Integrating tSQLt and operational tests into Azure Pipelines    

       Release Pipelines for Databases

         o  Multi-stage release pipelines    

         o  Deploying using DACPAC    

         o  Migration-based deployments with Flyway    

         o  Advanced rollback patterns    

         o  Safety techniques    

         o  Quality gates using pre/post-deployment scripts    

         o  Custom validation and health checks    

         o  Troubleshooting deployment failures    

       Monitoring & Observability for SQL Server

         o  Why monitoring is critical in a DevOps feedback loop    

         o  On-premises monitoring stack: Prometheus + Grafana    

         o  Redgate SQL Monitor (overview)    

         o  Feedback loop: Integrating monitoring alerts back to Azure Pipelines via webhooks