Querying Data with SQL Server

In this course, you’ll learn essential skills that are needed to become proficient in querying data using T-SQL including logical query execution, creating single table queries to filter and aggregate data, and combining data from multiple tables.

SQL is a fundamental skill in data management and data analysis that empowers you to handle complex scenarios with ease. In this course, Querying Data with SQL Server, you’ll gain the ability to extract, manipulate, and analyze data required to unlock valuable insights. First, you’ll learn the structure and basic components of an SQL query. Next, you’ll discover how to retrieve data from one or multiple tables while performing calculations on groups of rows. Finally, you’ll explore more advanced ways of retrieving data by working with subqueries, common table expressions, and window functions. When you’re finished with this course, you’ll have the SQL skills and knowledge needed to uncover hidden insights in your data.

• Course Overview 1min
• Selecting Data 22mins
• Aggregating Data 17mins
• Joining Data 16mins
• Cleaning Data 16mins
• Using Subqueries and CTEs 15mins
• Working with Window Functions 26mins