Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

This course is ideal for people who know fundamental T-SQL concepts and would like to create meaningful SQL reports in MS SQL Server.

Welcome to our Creating Basic SQL Reports in MS SQL Server course! Over the course of several chapters, we'll teach you how to make practical use of your SQL knowledge. You'll learn the most common types of basic SQL reports and build them step by step.

Imagine that it's 2016—Pokémon Go briefly takes over everyone's social life, and you're running a comic book store. Somewhere between asking visitors to stop playing while inside and worrying about your book sales dropping, you're planning on moving your store online. But how will you know if it's the right thing to do or if it will lead to more revenue? You won't until you crunch the numbers!

Data is collected everywhere—from marketing software counting URL clicks to sales representatives creating customer profiles and Facebook recording its users, your digital footprint is making an impact on the future of shopping all over the world. Thanks to data, we're able to measure our performance and make more informed, strategic decisions. But first, you need to know how to collect and analyze that data.

The Creating Basic SQL Reports in MS SQL Server course is divided into six parts and consists of 97 practical exercises that you can access straight from a web browser and at your own leisure. At the end of each part, there's always a short summary quiz to check how much you remember.

As a warm up, we'll start with a quick introduction to the database model that we'll be working with in the course and review your basic SQL skills.

(Psst! If you don't feel confident with your basic SQL knowledge at this step, you can always brush up on it in our SQL Basics in MS SQL Server course.)

Then, we move on to show you how to use popular SQL aggregate functions such as COUNT() or SUM() to summarize data in SQL, like counting business objects based on selected criteria or calculating total amounts based on multiple objects.

After summarizing data in SQL, we move on to show you how to classify data: how you can create custom classifications of objects in SQL using the CASE WHEN syntax and how you can use classifications to group objects in the GROUP BY clause. This course explains the intricacies of the GROUP BY clause and reviews a few typical mistakes that beginners make.

Next, we'll tackle multi-level aggregation so you know how to calculate averages of averages and how to organize longer queries in a clear way. You'll learn how to put multiple metrics in a single report, calculate ratios and percentages, and compare global and specific metrics.

Finally, we'll talk about comparing different business groups in a single report, and we'll show you three methods of doing this so you can always pick the best solution based on the result you want to achieve.

Once you finish the course, you'll be able to create a wide range of simple SQL reports, organize long queries, include multiple metrics in a single query, and operate on a database with several tables.

What's in It for Me?

  • 97 interactive exercises. Learn at your own pace, from anywhere and anytime. Interact with hands-on exercises for improved retention.
  • Lifetime access to the course. When you purchase the course, you’ll get instant personal access to all of its content.
  • Certificate of completion. After you successfully finish all of the exercises, you'll get a downloadable PDF certificate to showcase your accomplishment.
  • 30-day money-back guarantee. If you're not satisfied with the quality of the course, you can get a refund within 30 days of your purchase.
  • Hints for the exercises. You can make use of ready-made hints for all exercises, or ask questions and share insights with other members of our community through the Discuss tab.

What Are the Requirements?

  • A web browser and an Internet connection.
  • Understanding of fundamental T-SQL concepts which we present in our SQL Basics in MS SQL Server course.

Learn How To:

  • Use popular SQL aggregate functions such as COUNT() or SUM() to summarize data in SQL.
  • Classify data: how you can create custom classifications of objects in SQL using the CASE WHEN syntax and how you can use classifications to group objects in the GROUP BY clause.
  • Calculate averages and averages of averages.
  • Organize long queries in a clear way.
  • Put multiple metrics in a single report.
  • Calculate ratios and percentages.
  • Compare global and granular metrics.
  • Comparing different business groups in a single report picking one of three methods presented in the course.
  • Use common table expressions (CTEs).

Who Should Take This Course?

  • Analysts with basic SQL skills who want to create business reports.
  • Beginner data science enthusiasts with SQL knowledge.
  • Business analysts with basic SQL knowledge who want to generate business metrics in SQL.
  • Anyone interested in starting a career in SQL reporting.
    Start for free
    Gift this course

    Bundle deals

    86%
    off

    Reg. price
    $1512

    One to Rule 'Em All

    Includes 41 courses Python Basics. Part 1, Python Basics. Part 2, Python Basics. Part 3, Python Data Structures in Practice, Built-in Algorithms in Python, Working with Strings in Python, SQL Basics, SQL Practice Set, SQL JOINs, Standard SQL Functions, Creating Basic SQL Reports, Window Functions, Revenue Trend Analysis in SQL, How to INSERT, UPDATE, and DELETE Data in SQL, Recursive Queries, Creating Tables in SQL, Introduction to R, Tidyverse, Data Visualization 101, Statistics 101, SQL Basics in MS SQL Server, How to Insert, Update, or Delete Data in MS SQL Server, Common Functions in MS SQL Server, Revenue Trend Analysis in SQL Server, Creating Basic SQL Reports in SQL Server, Window Functions in MS SQL Server, Recursive Queries in MS SQL Server, GROUP BY Extensions in MS SQL Server, Introduction to Python for Data Science, How to Read and Write CSV Files in Python, How to Read and Write JSON Files in Python, Lists and Functions in R, Data Manipulation in R, SQL Basics in PostgreSQL, PostgreSQL JOINs, SQL Practice Set in PostgreSQL, Window Functions in PostgreSQL, Recursive Queries in PostgreSQL, Writing User-Defined Functions in PostgreSQL, PostGIS, How to Read and Write Excel Files in Python

    Bundle price $199

    37 hours left at this price!

    Table of contents

    Progress: 0% completed 0 of 97 exercises done

    1. Introduction

    Get to know the data model and review some basic SQL concepts.

    More details Less
    Start now

    0% completed 0 of 8 exercises done

    2. Summarizing Data in SQL

    Learn how to create simple yet useful business metrics.

    More details Less
    Start now

    0% completed 0 of 18 exercises done

    3. Classifying Data with CASE WHEN and GROUP BY

    Discover how to get metrics based on custom classifications.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    4. Multi-level Aggregation

    Learn how to construct reports that aggregate data on multiple levels.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    5. Multiple Metrics in One Report

    Discover how to include multiple metrics in a single report.

    More details Less
    Start now

    0% completed 0 of 19 exercises done

    6. Comparing Groups in One Report

    Find out even more about how you can compare groups in single SQL reports.

    More details Less
    Start now

    0% completed 0 of 14 exercises done

    Reviews

    Average rating

    5/5100.0 (3)

    Details

    5 Stars 100%
    4 Stars 0%
    3 Stars 0%
    2 Stars 0%
    1 Stars 0%
      Load more reviews

      Comments

      0