Careertail
About UsCoursesCareer PathsBlogOpportunities
Log In
Courses>Database Design & Development>Intermediate SQL Server
Data ScienceIntermediate SQL Server
Price:Paid
Length:4 Hours
Language:English
Content type:video
level:intermediate
Updated:19 February 2024
Published:08 September 2022
Similar courses
Opportunities
Courses>Database Design & Development>Intermediate SQL Server
Intermediate SQL Server
4 Hours
44136 students
Syllabus
One of the first steps in data analysis is examining data through aggregations. This chapter explores how to create aggregations in SQL Server, a common first step in data exploration. You will also clean missing data and categorize data into bins with CASE statements.
This chapter explores essential math operations such as rounding numbers, calculating squares and square roots, and counting records. You will also work with dates in this chapter!
In this chapter, you will create variables and write while loops to process data. You will also write complex queries by using derived tables and common table expressions.
In the final chapter of this course, you will work with partitions of data and window functions to calculate several summary stats and see how easy it is to create running totals and compute the mode of numeric columns.
Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot
Careertail
Courses>Database Design & Development>Intermediate SQL Server
Data ScienceIntermediate SQL Server
Price:Paid
Length:4 Hours
Language:English
Content type:video
level:intermediate
Updated:19 February 2024
Published:08 September 2022
Similar courses
Opportunities
Courses>Database Design & Development>Intermediate SQL Server
Intermediate SQL Server
4 Hours
44136 students
Syllabus
One of the first steps in data analysis is examining data through aggregations. This chapter explores how to create aggregations in SQL Server, a common first step in data exploration. You will also clean missing data and categorize data into bins with CASE statements.
This chapter explores essential math operations such as rounding numbers, calculating squares and square roots, and counting records. You will also work with dates in this chapter!
In this chapter, you will create variables and write while loops to process data. You will also write complex queries by using derived tables and common table expressions.
In the final chapter of this course, you will work with partitions of data and window functions to calculate several summary stats and see how easy it is to create running totals and compute the mode of numeric columns.
Similar courses
Opportunities
Make the most out of your online education
Careertail
Copyright © 2021 Careertail.
All rights reserved
Quick Links
Get StartedLog InAbout UsCourses
Company
BlogContactsPrivacy PolicyCookie PolicyTerms and Conditions
Stay up to date
Trustpilot