Quering Microsoft SQL Server: Hands-On Tutor 21+ hours 2025

Explore how T-SQL column aliases improve readability by renaming calculated columns with as, equals, or direct assignment, and learn best practices to avoid accidental aliases and comma mistakes.

Master T-SQL sales analysis by using column aliases and calculated columns to derive order number, purchase date, gross amount, and net amount with both as and equals syntax.

Learn to craft a SQL query with select, from, join, group by and order by to analyze sales by territory and salesperson, showing territory name and total sales.

Alias columns using as in a practical sql report, concatenate first and last names into a sales person name, and compute totals, subtotals, tax, and average order size.

Explore simple case expressions in T-SQL within select clauses to substitute values and clarify query results, alias the calculated column, and understand when to return null or else clause value.

Apply simple case expressions on the Adventureworks 2022 database to categorize total due values in the sales order header. Learn to filter, sort, and alias results for clarity.

Practice writing basic select statements in sql server using the Adventureworks 2022 database, including distinct, table and column aliases, and case expressions to analyze sales data.

Practice writing basic select statements in SQL Server using the AdventureWorks 2022 database, refining queries with specific columns, aliases, distinct, and a case expression to categorize data.

Explore how the from clause creates virtual tables and supports query processing. Learn common join types—inner, outer, self, cross—and how ANSI SQL 92 syntax influences join behavior, avoiding Cartesian products.

Explore how Ansi SQL 89 and Ansi SQL 92 join syntax affects query results and performance, highlighting the risks of accidental Cartesian products and the clarity of using on clauses.

Master inner joins to retrieve data from multiple tables using on and where clauses, ANSI SQL 92 syntax, and table aliases; learn single and composite joins and avoid cartesian products.

Master inner joins and multi-table queries using practical examples from the sql database, including simple, composite, and distinct joins. Build data views by joining categories, products, customers, and orders.

Explore inner joins in the Adventureworks 2022 database to retrieve customer orders and product categories, using on clauses and where filters with ansi sql 92 syntax.

Explore how outer joins preserve rows and reveal unmatched data with null values, and compare inner and outer joins using aliases and null tests.

Explore outer joins in SQL Server with hands-on examples using Adventureworks, revealing how left and right outer joins preserve unmatched rows and fill nulls, and how inner joins compare.

Explore cross joins and self joins in SQL Server using the AdventureWorks 2022 database, generating Cartesian products for test data and lookup tables through practical examples.

Query self joins and cross joins in T-SQL to explore hierarchical relationships and generate all combinations, using inner and left outer joins to fetch employees and their managers.

Learn how to use the order by clause to sort query results in SQL Server, handle nulls, collations, and multiple column tiebreakers.

Master sorting and querying results with the order by clause in SQL Server, including single and multi-column sorting, explicit ascending or descending order, and using derived columns as tiebreakers.

Filter query results with the where clause using predicates, repeat select expressions when needed, and apply or, in, and not in operators for dates and values.

Master filtering and paging in SQL Server with the top option and offset fetch, including with ties and a deterministic order by for precise row ranges.

Learn to filter rows with top and offset fetch in SQL Server, using order by for deterministic results, with ties, percent options, and pagination.

Apply three-valued logic to handle true, false, and unknown, with null representing missing data, and test for null using is null or is not null.

Learn how to handle null values in SQL queries by using is null and is not null, and understand how nulls affect sorting, filtering, and comparisons.

Explore sql server data types, including exact numeric, approximate numeric, binary strings, and special types such as uniqueidentifier and xml. Learn type precedence and conversions for better queries.

Explore approximate numeric types like float and real for large ranges. Learn binary string types binary and varbinary for non-text data, plus unique identifier, XML, hierarchy ID.

Explore SQL Server data types and type precedence using the Adventureworks 2022 sample database, covering numeric, character, and temporal types with practical examples and explicit conversions.

Explore how SQL Server handles data type conversions, identify implicit conversions guided by precedence rules, and learn explicit conversions with cast or convert to ensure reliable queries.

Explore SQL Server character data types and collation, and learn to use functions like substring, charindex, replace, and format for robust text manipulation and pattern matching with like.

Master working with character data in SQL Server by using collation and the collate clause to enforce case and accent sensitivity, plus concatenation, substring functions, and like pattern matching.

Master sql server date and time data types, literals, and built in functions to store, construct, and analyze temporal data, including date from parts, end of month, and date diff.

Master sql server date and time functions to retrieve current values, extract parts, construct dates from components, compute differences, and validate inputs with isdate for robust temporal queries.

Master inserting data into tables with T-SQL, including single and multiple row insertions. Leverage insert with select, insert exec, and select into to transfer data and create new tables.

Insert data into SQL Server tables using insert into values for a single row and insert into select for bulk transfers, while validating columns and data types.

Modify and remove data in SQL Server with update, merge, delete, and truncate table using where clauses and joins. Learn upserts with merge and concise updates via compound operators.

Modify and remove data in SQL Server using update, merge, delete, and truncate table, with practical examples to synchronize tables and upsert records.

Explore how to generate numbers in SQL Server using the identity property and sequence object to produce sequential values, unique identifiers, and coordinate values across tables.

Master built-in SQL Server functions, including scalar, grouped aggregate, window, and rowset types; apply determinism and collation concepts with examples like abs, year, rank, and open query.

Learn to use built-in SQL Server functions—scalar, aggregate, and ranking—to extract dates, compute absolutes, convert types, summarize data, and rank results with window functions.

Explore implicit versus explicit conversions in SQL Server, and master cast, convert, parse, and try convert to write robust queries that handle errors gracefully.

Explore how cast, convert, parse, and try parse enable data type conversions in SQL Server, format dates with style, and gracefully handle invalid input.

Explore how SQL Server logical functions like is numeric, iif, and choose help validate data types, test conditions, and map values into labels within concise queries.

Use SQL Server logical functions to validate data and apply conditional logic with is numeric, if, and choose. Explore data validation, numerical checks, and list-based mapping in a practical demo.

Learn to handle null values in SQL server by using Isnull to replace nulls, Coalesce for the first non-null value, and null if for conditional nulls, with practical examples.

Discover how to manage null values in sql server with isnull, coalesce, and nullif to replace nulls, return the first non-null value, and conditionally generate nulls using ANSI standard functions.

Learn to use aggregate functions in SQL Server to summarize data across rows, including avg, max, min, and count, with group by and distinct handling of nulls.

Master the group by clause to divide rows into groups by specified columns and apply aggregate functions such as count, sum, and max to each group, following sql's processing order.

Learn to group rows with the group by clause in SQL Server, apply aggregates such as count, sum, and average to each group, and refine granularity by adding columns.

Learn to filter grouped data with the having clause after applying group by, using aggregates like count, sum, and average. Compare where and having to apply row- and group-level filters.

Learn to write correlated subqueries in T-SQL that depend on the outer query and run per row, with dynamic input and considerations for testing, nulls, and JSON rewrites for performance.

Explore correlated subqueries in T-SQL that depend on the outer query, execute once per row, and enable row-by-row comparisons with practical examples like latest dates and maximum quantities.

Explore how the exists predicate tests for rows in a subquery, compare it to count, and learn how not exists helps find non-matching rows, with practical SQL Server examples.

Explore the exists predicate with subqueries in SQL Server to test whether rows exist, use not exists for non-matching rows, and compare with count for efficient querying.

Master inline table valued functions in sql server to create parameterized, reusable queries that return virtual tables and enable dynamic results through returns table.

Learn to create and use user defined functions in SQL Server, including inline TVFs that return virtual tables and generate sequences or calculate order line totals.

Explore derived tables in the from clause to modularize queries, using aliases, optional argument passing, and guidance on nesting for readable, efficient SQL code.

Learn to design derived tables in SQL Server, using inline and external column aliases, pass arguments, and manage nesting to create modular, readable, reusable queries.

Master common table expressions (CTEs) using the with clause to modularize complex SQL queries, reuse logic across multiple calculations, and distinguish CTEs from derived tables for clearer readability.

Explore how common table expressions simplify complex SQL queries by defining a temporary result set with the with clause, enabling non-recursive and recursive CTE patterns for modular, readable SQL.