Objectives

• A majority of data is stored in databases and knowing the necessary tools needed to analyze and clean data directly in databases is indispensable.

Outcomes

This course focuses on T-SQL, the version of SQL used in Microsoft SQL Server, needed for data analysis. You will learn several concepts in this course such as dealing with missing data, working with dates, and calculating summary statistics using advanced queries. After completing this course, you will have the skills needed to analyze data and provide insights quickly and easily.

Course Contents

Data analysis with aggregationsCreating aggregationsCreating grouped aggregationsDealing with missing dataRemoving missing valuesImputing missing values (I)Binning data with CASEUsing CASE statementsCreating several groups with CASECounting and totalsCalculating the totalCounting the number of rowsDatesWhich date function should you use?Counting the number of days between datesAdding days to a dateRounding and truncatingMore math functionsCalculating the absolute valueCalculating squares and square rootsWHILE loopsCreating and using variablesCreating a WHILE loopDerived tablesQueries with derived tables (I)Common Table ExpressionsCTE syntaxCreating CTEs (I)Window functions in T-SQLWindow functions with aggregations (I)Common window functionsDo you know window functions?First value in a windowPrevious and next valuesIncreasing window complexityCreating running totalsAssigning row numbersUsing windows for statistical functionsCalculating standard de

Description

Data will be available soon!