Developing High Quality Databases Using Visual Studio 2019

This two-day, instructor-led Developing High Quality Databases Using Visual Studio 2019 training class provides students with the knowledge and skills to effectively develop, test, and deliver modern SQL Server databases. Student will experience how to manage changes to database schema, ensure quality through T-SQL unit testing and static code analysis, and automate the building and deploying of SQL Server databases.

This course is intended for database developers and administrators working with modern versions of SQL Server or SQL Azure. Application developers who are involved with writing and testing T-SQL code and working with test data will also find value from this course. It would also be beneficial if students have worked on a team-based software development project and are familiar with their organization's development life cycle and practices.This course is intended for practitioners who are comfortable with the concepts of developing, testing, and deploying SQL Server databases.

Location

Public Classes: Delivered live online via WebEx and guaranteed to run . Join from anywhere!

Private Classes: Delivered at your offices , or any other location of your choice.

Goals
  1. Obtain a SSDT overview.
  2. Learn to commit, pull, push workflow in Visual Studio.
  3. Learn to compare and synchronize schema changes.
  4. Learn Agile database techniques.
  5. Learn to create and use a project snapshot (.dacpac)
  6. Learn to compare and synchronize data changes
  7. Learn SQL Server unit testing principles.
  8. Learn to generate test data.
  9. Learn to use static cod analysis.
  10. Learn to build and release pipelines.
Outline
  1. Agile Database Development
    1. Agile database development overview
    2. Agility challenges and blockers
    3. SQL Server Data Tools overview
    4. Connected vs. disconnected development
    5. Imperative vs. declarative development
    6. Agile database techniques
  2. 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
  3. Managing Schema Changes
    1. Introduction to Azure DevOps
    2. Azure Repos overview
    3. Using Git to manage schema changes
    4. Cloning, committing, pushing, and pulling
    5. Comparing schemas and sync’ing changes
    6. Comparing data and sync’ing changes
    7. Rolling back changes using Git
    8. Rolling back changes using project snapshots
  4. 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
  5. Building and Deploying
    1. Building the database project
    2. Using pre-build and post-build events
    3. Including additional build scripts
    4. Using script build actions
    5. Using the Local DB isolated sandbox
    6. Deploying changes to SQL Server
    7. Creating and using publishing profiles
    8. Using pre and post deployment scripts
    9. Using SQL CMD 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)
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Training for your Team

Length: 2 Days
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors

What people say about our training

From beginner to advanced, this course will prepare you for whatever your organizational needs are. My instructor was the BEST and I'll be sure to send my new hires to her!
Alexa Smith
Sayres & Associates
The class structure and instructor were great. Webucator was also very prompt in taking care of my course. I registered the day before the course and they over-nighted my kit to me and emailed me the course book. They really want to make sure students are prepared for the class and are always on hand to support students.
Jose Luis Valdes Jr
University Medical Service Association
Was not expecting to learn much from this. However, the instructor provided tips and examples that we didn't know. I was so glad I took this class.
Gregory Galicia
United States Postal Service (USPS)
The course material was presented at a good pace and the labs helped me see how the concepts that were presented actually work in practice.
Dan Dougherty
Andesa Services

No cancelation for low enrollment

Certified Microsoft Partner

Registered Education Provider (R.E.P.)

GSA schedule pricing

64,155

Students who have taken Instructor-led Training

11,950

Organizations who trust Webucator for their Instructor-led training needs

100%

Satisfaction guarantee and retake option

9.30

Students rated our trainers 9.30 out of 10 based on 30,185 reviews

Contact Us or call 1-877-932-8228