Skip to main content
HomeSQL

Course

Intermediate SQL Server

IntermediateSkill Level
4.8+
215 reviews
Updated 11/2024
In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analysis.
Start Course for Free
SQLProgramming4 hr14 videos47 Exercises3,850 XP65,178Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

Loved by learners at thousands of companies

Group

Training 2 or more people?

Try DataCamp for Business

Course Description

A majority of data is stored in databases and knowing the necessary tools needed to analyze and clean data directly in databases is indispensable. 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.

Prerequisites

Introduction to SQL Server
1

Summarizing Data

One of the first steps in data analysis is examining data through aggregations. This chapter explores how to create aggregations in SQL Server, a common first step in data exploration. You will also clean missing data and categorize data into bins with CASE statements.
Start Chapter
2

Math Functions

3

Processing Data in SQL Server

In this chapter, you will create variables and write while loops to process data. You will also write complex queries by using derived tables and common table expressions.
Start Chapter
4

Window Functions

Intermediate SQL Server
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance reviewEnroll Now

Don’t just take our word for it

*4.8
from 215 reviews
87%
12%
0%
0%
0%
  • Tom
    2 days ago

  • Alexander
    5 days ago

  • Harsimran Singh
    last week

  • Gabrielle
    last week

  • Alexandra
    2 weeks ago

  • Meng
    2 weeks ago

Tom

Alexander

Harsimran Singh

FAQs

Is this course specific to Microsoft SQL Server's T-SQL dialect?

Yes. The course focuses on T-SQL, the SQL variant used in Microsoft SQL Server. Syntax and functions taught may differ from PostgreSQL, MySQL, or other database systems.

What topics does the first chapter cover for handling missing data?

You will learn to create aggregations, clean missing data using T-SQL functions, and categorize data into bins with CASE statements as a foundation for deeper analysis.

Does this course teach window functions?

Yes. The final chapter covers partitions, window functions for summary statistics, running totals, and computing the mode of numeric columns using SQL Server syntax.

Will I learn to use variables and loops in T-SQL?

Yes. Chapter 3 teaches you to create variables, write WHILE loops, and build complex queries using derived tables and common table expressions in SQL Server.

What prerequisite SQL Server knowledge is needed?

You should have completed Introduction to SQL Server. Comfort with SELECT statements, filtering, basic joins, and simple aggregations will prepare you for this intermediate course.

    Join over 19 million learners and start Intermediate SQL Server today!

    Create Your Free Account

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.

    Grow your data skills with DataCamp for Mobile

    Make progress on the go with our mobile courses and daily 5-minute coding challenges.