Hands On Training

Intermediate SQL Server

Name: Intermediate SQL Server
Brand: Careervira
Price: 149 USD
Availability: InStock
Rating: 5.0 (3 reviews)

DataCamp

(3)

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

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

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

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

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...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%