Reporting in SQL

Name: Reporting in SQL
Brand: Careervira
Price: 581 HKD
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

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

You will learn how to create complex reports. This course will help you use the SQL concepts and functions you have learned in previous courses. Your dashboard will be created. You'll be able navigate the Olympics database and become an data explorer. Data is imperfect. Learn valuable strategies for solving real-world SQL problems. These strategies include how to remove data duplication and organize messy information into clean reports. In one report, you will learn complex calculations using window functions and multi-layered computations. Anyone who regularly pulls data from databases will find this class useful. This class is also great for those who use R or Python for data science.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

Learn how to build your very own dashboard by applying all the SQL concepts and functions you have learned in previous courses

In this course, you will apply all the SQL concepts and functions you have learned in previous courses to build out your very own dashboard

You’ll conquer complex calculations using window functions and layered calculations, all within the same report

Course Content

Expand all sections

Module 1: Exploring the Olympics Dataset

Module 2: Creating Reports

Module 3: Cleaning Validation

Module 4: Complex Calculations

Course Instructors

Tyler Pernes

Learning & Development Consultant

As a learning development consultant by day and a freelancer by night, Tyler has two clear passions in life: teaching and data. After receiving a bachelor's in biophysics at Johns Hopkins University,...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%