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.
Overview
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.
Syllabus
- 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
Taught by
Pluralsight