Skip to main content
ANVISoftware Solutions

Module 04 of 06 · SQL & Database Fundamentals

Views, Procedures and Transactions

Reusable query logic in the database, and keeping related changes consistent.

4 of 4 lessons available

Lessons in this module

  1. 01

    Views

    Intermediate

    Name a query for reuse, and understand what a view does not do.

    15 min
  2. 02

    Stored Procedures

    Intermediate

    Encapsulate logic in the database, weighing the trade-offs.

    18 min
  3. 03

    Functions

    Intermediate

    Write reusable scalar and table-valued functions.

    16 min
  4. 04

    Transactions and Isolation

    Intermediate

    Keep related changes consistent and choose an isolation level deliberately.

    20 min

Have a project worth talking through?

Tell us what you're building or what's slowing your current system down. We'll give you a direct read on scope and approach.

Start a ConversationExplore Our Services