SQL Server / Intermediate

SQL Server β€” Intermediate

Protect integrity and concurrency while designing efficient database APIs.

6 lessons Β· No account required

What you will learn

  • Handle transactions and conflicts deliberately.
  • Use indexes, plans, analytical queries, procedures, and scoped permissions.

  1. Constraints, transactions, and error recovery

    Combine several state changes into one business outcome. Use declarative rules, explicit transactions, XACT_ABORT, TRY/CATCH, XACT_STATE, and THROW responsibly.

    Start learning

  2. Isolation, locks, and concurrent decisions

    Explain what simultaneous sessions can observe and why a correct single-session query can fail as a workflow. Compare locking READ COMMITTED, RCSI, SNAPSHOT, and optimistic updates.

    Start learning

  3. Indexes, statistics, and execution plans

    Connect a query predicate to physical access paths. Read plan evidence, choose focused indexes, and separate estimation mistakes from expensive but appropriate work.

    Start learning

  4. CTEs, windows, and temporary results

    Express multistage analysis without confusing a named query with stored data. Rank rows deterministically and calculate running totals with an explicit window frame.

    Start learning

  5. Stored procedures and typed parameters

    Create a clear database API with predictable result shapes and error behavior. Keep parameterized dynamic SQL distinct from unsafe string construction.

    Start learning

  6. Identities, permissions, and least privilege

    Design application access using the correct SQL Server security boundaries. Separate authentication, database authorization, parameter safety, encryption, and audit responsibilities.

    Start learning
Back to course