SQL Server / Basic

SQL Server β€” Basic

Build relational models and predictable T-SQL reads and writes.

6 lessons Β· No account required

What you will learn

  • Explain SQL Server context and batches.
  • Model keys and types, query relationships, and inspect mutations.

  1. The engine, databases, tools, and batches

    Build a reliable mental model of a SQL Server connection before writing business queries. Distinguish engine responsibilities, database context, client tools, and batch boundaries.

    Start learning

  2. Schemas, data types, and keys

    Model a small order system using explicit types, Unicode text, and stable identifiers. Understand which guarantees come from constraints and which must be designed separately.

    Start learning

  3. SELECT, predicates, NULL, and deterministic order

    Turn a business question into an explicit result shape. Learn SQL Server TOP, three-valued logic, date ranges, aliases, and a complete ordering contract.

    Start learning

  4. Join relationships and test existence

    Combine customer and order facts without losing optional relationships or multiplying totals accidentally. Distinguish matching rows from the simpler question of whether a match exists.

    Start learning

  5. Grouping and trustworthy aggregates

    Build customer summaries whose totals, counts, and missing values have explicit meanings. Use GROUP BY, HAVING, conditional aggregation, and correct arithmetic.

    Start learning

  6. Safe INSERT, UPDATE, and DELETE

    Apply deliberate changes to synthetic data, inspect affected rows, and separate previews from atomic correctness. Learn OUTPUT, row-count checks, and identity retrieval.

    Start learning
Back to course