Outline updated November 2026

Foundation21 hours delivered over 3-5 daysLive, online or on-site

Request this course

SQL Server for Developers

Class Duration

21 hours of live training delivered over 3-5 days to accommodate your scheduling needs.

Student Prerequisites

  • Programming experience in any language (data access examples use C#)
  • Basic SQL: SELECT, WHERE, joins, and GROUP BY
  • Familiarity with tables, keys, and relationships
  • No prior SQL Server experience required

Target Audience

Application developers and tech leads who build on SQL Server or Azure SQL Database, especially C# and .NET teams. Developers new to SQL can start with SQL Fundamentals. Teams building the application layer can add Modern C# Development with .NET.

Description

This course teaches developers to build and tune applications on SQL Server and Azure SQL Database. Students write T-SQL with joins, CTEs, window functions, and MERGE, and design tables with the right keys and constraints. They learn how indexes and execution plans work, and use Query Store to find slow queries. Later sections cover transactions, locking, stored procedures, and JSON and vector data. The course ends with security, data access from .NET, database projects, and CI/CD.

Learning Outcomes

  • Write T-SQL queries with joins, CTEs, window functions, and APPLY.
  • Change data safely with INSERT, UPDATE, DELETE, MERGE, and OUTPUT.
  • Design tables with suitable data types, keys, and constraints.
  • Choose clustered, nonclustered, filtered, and columnstore indexes.
  • Read execution plans and fix common performance problems.
  • Find and fix query regressions with Query Store.
  • Choose isolation levels and avoid blocking and deadlocks.
  • Write stored procedures, functions, and triggers with proper error handling.
  • Store and query JSON and vector data.
  • Secure data with Microsoft Entra authentication, row-level security, and Always Encrypted.
  • Access SQL Server from .NET with Microsoft.Data.SqlClient, Dapper, and Entity Framework Core.
  • Manage schema changes with SQL database projects and deploy them through CI/CD.

Training Materials

Comprehensive courseware is distributed online at the start of class.

Software Requirements

Students will need a free, personal GitHub account to access the courseware, Docker Desktop or Podman to run SQL Server 2025 locally, a SQL client (SQL Server Management Studio or VS Code with the MSSQL extension), and the .NET 10 SDK. If students are unable to configure a local environment, a cloud-based environment can be provided.

Training Topics

SQL Server and Azure SQL

  • Editions and deployment options
  • Azure SQL Database
  • Azure SQL Managed Instance
  • SQL Server in containers
  • SSMS and VS Code tools
  • Databases, schemas, and objects

T-SQL Querying

  • Filtering and sorting
  • Joins and APPLY
  • Grouping and aggregation
  • Subqueries and CTEs
  • Window functions
  • Paging with OFFSET and FETCH
  • Regular expression functions

Modifying Data

  • INSERT, UPDATE, and DELETE
  • MERGE and its pitfalls
  • The OUTPUT clause
  • Set-based versus row-by-row code
  • Bulk loading data

Designing Tables

  • Choosing data types
  • Primary keys and identity columns
  • Sequences versus GUID keys
  • Foreign keys and constraints
  • Computed columns
  • Temporal tables

Indexes

  • Heaps and clustered indexes
  • Nonclustered and covering indexes
  • Filtered indexes
  • Columnstore indexes
  • Index maintenance basics
  • Missing index suggestions

Execution Plans and Query Tuning

  • Reading an execution plan
  • Seeks, scans, and lookups
  • Statistics and cardinality estimates
  • Parameter sniffing
  • Intelligent query processing
  • Query Store
  • Forcing a known good plan

Transactions and Concurrency

  • Explicit transactions
  • Isolation levels
  • Read committed snapshot isolation
  • Optimized locking
  • Blocking and deadlocks
  • Retrying transient errors

Programmable Objects

  • Stored procedures
  • Table-valued parameters
  • Scalar and table-valued functions
  • Triggers and their costs
  • TRY...CATCH and THROW
  • Safe dynamic SQL

JSON and Vector Data

  • The native json data type
  • JSON functions in T-SQL
  • The vector data type
  • Storing embeddings
  • Vector similarity search
  • Vector indexes

Security

  • Logins, users, and roles
  • Microsoft Entra authentication
  • Least-privilege permissions
  • Row-level security
  • Dynamic data masking
  • Always Encrypted
  • Preventing SQL injection

Data Access from .NET

  • Microsoft.Data.SqlClient
  • Connection pooling and resilience
  • Dapper for SQL-first code
  • Entity Framework Core with SQL Server
  • Reviewing ORM-generated SQL
  • Drivers for Python, Java, and Node.js

Schema Changes and CI/CD

  • SQL database projects
  • Building and deploying dacpacs
  • Migrations with Entity Framework Core
  • Unit testing with tSQLt
  • Deploying through CI/CD pipelines
  • Reviewing SQL from AI assistants

Private team training

Bring this course to your team

Tell us about your team and we will tailor this outline to your tools, stack, and schedule. Courses can also be combined into a longer program.

  1. Tell us what you needYour tools, stack, team size, and timeline.
  2. We send a proposalA course or program, an outline adjusted to your team, and possible dates.
  3. Your team trains liveOnline or on-site, with courseware for every student.

Prefer to talk? Call +1 434-509-6890 or email help@cloudcontraptions.com.

We reply within 1 business day.

Training partner?