Overview
-
Learn how to retrieve information stored in a Microsoft SQL Server database using the Transact-SQL (T-SQL) language.
Syllabus
-
Introduction
- Turn data into information with queries
- What you should know
- Download the sample database
- What is Transact SQL?
- The SQL querying environment
- Return records with SELECT and FROM
- Filter records with WHERE
- Sort records with ORDER BY
- Column aliases
- Create values with constants
- Limit results with TOP
- Remove duplicates with DISTINCT
- Comparison operators
- Understand NULL values
- Match text with LIKE and wildcards
- Table joins and relationships
- Inner joins
- Left, right, and full outer joins
- Cross joins
- Understand record grouping
- Use GROUP BY and COUNT
- Aggregate functions
- Explore data with SUM
- Filter groups with HAVING
- Use functions in T-SQL
- String functions
- Text concatenation
- Round with mathematical functions
- Work with date functions
- FORMAT date and times
- Return random records with NEWID
- The IIF logical function
- Change database context with USE
- Add comments to a script
- When to use square brackets
- What is a subquery?
- Use a subquery in a WHERE clause
- Correlated subqueries
- PIVOT the result set
- Create and use variables in a query
- Create a counter for a looping statement
- Combine results with UNION
- Return distinct rows with EXCEPT
- Return common rows with INTERSECT
- Next steps
