Microsoft SQL - The Complete Guide for Beginners (TSQL)

Learn to use top to limit results and distinct to return unique rows in a select statement, with examples using first, middle, and last names.

Learn to alias columns and tables in SQL select statements using as, improve readability with capitalization, and apply optional table aliases like persons to clarify references.

Explains using the where clause to filter rows by first name or modified date, showing equals and less-than comparisons and common date format pitfalls.

Use the where clause with and, or, and brackets to combine conditions and refine queries. Filter by first name, last name, email promotion, and business entity id for precise results.

Learn the in operator in sql, a shorthand for multiple or conditions that matches a column value against a list, making queries like first name in (Michael, Amy) cleaner.

Learn how the not operator and not in clause exclude specific results in SQL queries, reverse conditions, and apply these techniques to simple selects from a person table.

Learn to use the group by clause with aggregate functions to sum quantity by location ID. See a practical example yielding total quantity per location and an alias.

Learn to use multiple aggregate functions with group by in SQL, displaying location, shelf, and bin counts alongside total quantity, and adopt as aliases for readability.

Explore how the having clause filters group by aggregates, showing why where can't filter totals and how to apply conditions on sums like total quantity in SQL Server.

Explore inner join theory by combining two tables on a common key and returning only matching records. See a customer and orders example to verify the results.

Practice inner joins and column selection by joining human resources employee and person with aliases to resolve ambiguous business entity ID and display job title, first name, and last name.

Explore union and union all as SQL set operators that combine results from multiple selects; union removes duplicates, union all preserves them, with matching column counts and order.

Learn to combine SQL functions, trim spaces before measuring length, and use left and right to extract the first or last characters.