Overview
-
- Module 1: Introduction to Transact-SQL
- Understand what SQL is for
- Identify database objects in schemas
- Identify SQL statement types
- Use the SELECT statement
- Work with data types
- Handle NULLs
- Module 2: Sort and filter results in T-SQL
- Sort your results
- Limit the sorted results
- Return paged results
- Remove duplicates
- Filter data with predicates
- Module 3: Combine multiple tables with JOINs in T-SQL
- Describe join concepts and syntax
- Write queries that use inner and outer joins
- Write queries that use cross joins
- Write queries that use self joins
- Module 4: Write Subqueries in T-SQL
- Understand what subqueries are
- Use scalar or multi-valued subqueries
- Use self-contained or correlated subqueries
- Module 5: Use built-in functions and GROUP BY in Transact-SQL
- Categorize built-in functions
- Use scalar functions
- Use ranking and rowset functions
- Use aggregate functions
- Summarize data with GROUP BY
- Filter groups with HAVING
- Module 6: Modify data with T-SQL
- Insert data into a table
- Generate automatic values
- Update data in a table
- Delete data from a table
- Merge data based on multiple tables
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
After completing this module, you will be able to:
