Get Started Querying with Transact-SQL

After completing this module, you will be able to:

• Understand what SQL is for
• Identify database objects in schemas
• Identify SQL statement types
• Use the SELECT statement
• Work with data types
• Handle NULLs

After completing this module, you will be able to:

• Sort your results
• Limit the sorted results
• Return paged results
• Remove duplicates
• Filter data with predicates

After completing this module, you will be able to:

• 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

After completing this module, you will be able to:

• Understand what subqueries are
• Use scalar or multi-valued subqueries
• Use self-contained or correlated subqueries

After completing this module, you will be able to:

• Categorize built-in functions
• Use scalar functions
• Use ranking and rowset functions
• Use aggregate functions
• Summarize data with GROUP BY
• Filter groups with HAVING

After completing this module, you will be able to:

• Insert data into a table
• Generate automatic values
• Update data in a table
• Delete data from a table
• Merge data based on multiple tables

• Introduction
• Work with schemas
• Explore the structure of SQL statements
• Examine the SELECT statement
• Work with data types
• Handle NULLs
• Exercise - Work with SELECT statements
• Knowledge check
• Summary

• Introduction
• Sort your results
• Limit the sorted results
• Page results
• Remove duplicates
• Filter data with predicates
• Exercise - Sort and filter query results
• Knowledge check
• Summary

• Introduction
• Understand joins concepts and syntax
• Use inner joins
• Use outer joins
• Use cross joins
• Use self joins
• Exercise - Query multiple tables with joins
• Knowledge check
• Summary

• Introduction
• Understand subqueries
• Use scalar or multi-valued subqueries
• Use self-contained or correlated subqueries
• Exercise - Use subqueries
• Knowledge check
• Summary

• Introduction
• Categorize built-in functions
• Use scalar functions
• Use ranking and rowset functions
• Use aggregate functions
• Summarize data with GROUP BY
• Filter groups with HAVING
• Exercise - Use built-in functions
• Knowledge check
• Summary

• Introduction
• Insert data
• Generate automatic values
• Update data
• Delete data
• Merge data based on multiple tables
• Exercise - Modify data
• Knowledge check
• Summary