SQL Server T-SQL Foundations: Queries, Functions & Basic DML
Read and predict real T-SQL on a fictional bike shop database: SELECT TOP, OFFSET-FETCH, ISNULL, CAST and CONVERT, TRY_CAST, DATEADD and DATEDIFF, string functions, CASE, GROUP BY, HAVING, IDENTITY and INSERT, UPDATE, DELETE, with every answer checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
T-SQL Foundations teaches you to read and predict real SQL Server queries. You work with a small fictional bike shop database, with products, orders and a few helper tables, and in every lab you work out exactly what a query returns: which rows TOP and OFFSET-FETCH keep, what ISNULL and COALESCE do with NULL, where CAST truncates and where it rounds, why int division and AVG on an int column lose decimals, how DATEADD clamps to the month end and why DATEDIFF counts boundaries. You also use string functions, CASE, GROUP BY and HAVING, predict IDENTITY values, and see what INSERT, UPDATE, DELETE and TRUNCATE change. Every answer is checked instantly, and the first lesson is free.
Lessons
- SELECT, FROM dbo and Calculated ColumnsFree
- WHERE: Comparisons, BETWEEN and AND Locked
- SELECT TOP, ORDER BY and WITH TIES Locked
- ORDER BY and OFFSET-FETCH Paging Locked
- NULL, ISNULL and COALESCE Locked
- Variables, Integer Division and Modulo Locked
- CAST and CONVERT: Types, Truncation and Rounding Locked
- TRY_CAST: Converting Dirty Data Without Errors Locked
- Dates: GETDATE, MONTH, DATEPART and EOMONTH Locked
- DATEADD: Due Dates, Return Windows and Month Ends Locked
- DATEDIFF: Counting Boundaries, Not Durations Locked
- String Functions: LEFT, RIGHT, LEN and TRIM Locked
- CHARINDEX, SUBSTRING and CONCAT vs + Locked
- CASE and IIF: Labels and Conditional Sums Locked
- Aggregates: COUNT, SUM, AVG and the Integer AVG Trap Locked
- GROUP BY: One Row per Group Locked
- HAVING vs WHERE and the Logical Query Order Locked
- Grouping by Month and Where Aliases Work Locked
- INSERT and IDENTITY: Automatic Keys and Gaps Locked
- UPDATE: Changing Rows Safely Locked
- DELETE vs TRUNCATE Locked
- Final Project: Top Customers Report Locked