Intermediate SQL Server

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Databases hold the vast majority of data. These databases are crucial for data cleaning and analysis. This course will be focused on T-SQL, which is the version that Microsoft SQL Server uses to perform data analysis. This course will show you how to handle missing dates and how advanced queries can be used for summary statistics. This course will give you the skills and knowledge to analyze data quickly and provide insights.

Course Overview

Virtual Labs

Job Assistance

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Introduction to SQL Server is recommended to take

What You Will Learn

After completing this course, you will have the skills needed to analyze data and provide insights quickly and easily

In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server 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

Course Content

Expand all sections

Module 1: Summarizing Data

Module 2: Math Functions

Module 3: Processing Data in SQL Server

Module 4: Window Functions

Course Instructors

Ginger Grant

Principal Consultant, Desert Isle Group

Ginger is a Data Platform MVP and Microsoft Certified Trainer who shares what she has learned working with data technology with clients by providing training and talks to people around the world. Rec...