Gain the starting SQL Server skills you need to summarize data, join tables, and analyze data using built-in SQL Server functions. 

In this track, you’ll discover how SQL Server is like a supercharged Microsoft Excel. Through interactive exercises, you’ll learn how to access, query, and extract huge amounts of data from multiple databases. Using real-world data you’ll also learn how to perform powerful cross-database analyses that you can then apply in your own role. 

Gain the starting SQL Server skills you need to summarize data, join tables, and analyze your data using SQL Server functions. 

SQL Server Fundamentals

Hit the ground running by learning the basics of SELECT  statements to retrieve data from one or more columns. 
You'll also learn how to apply filters to both numeric and text data, and sort the results. 

SELECTion Box

Herein, you'll learn how to use important SQL Server aggregate functions such as SUM, COUNT, MIN, MAX, and AVG. Following that, you'll learn how to manipulate text fields. To round out the chapter, you'll power up your queries using GROUP BY and HAVING, which will enable you to perform more meaningful aggregations.

Groups, strings, and counting things

This chapter covers the basics of joining tables, using INNER, LEFT, and RIGHT joins,  so that you can confidently retrieve data from multiple sources.

Joining tables

In this final chapter,  you'll get really hands on! You've worked with existing tables, but in this chapter, you'll get to CREATE and INSERT data into them.  You'll also UPDATE existing records and practice DELETE  statements in a safe environment. This chapter ensures the course gives you a thorough introduction to the key aspects of working with data in SQL Server.

You've  got the power

Eurovision Song Contest

Power outages in USA

Classic rock radio station songs

Chinook Database

SQL is an essential skill for data scientists, and Microsoft SQL Server is one of the world's most popular database systems. In this course, you'll start with simple SELECT statements, and refine these queries with ORDER BY and WHERE clauses. You'll learn how to group and aggregate your results, and also how to work with strings.  You'll also cover the most common way to join tables, how to create tables, and inserting and updating data. You'll mainly work with the Chinook digital media database, representing sales of various artists and tracks. The music theme continues with the classic rock and Eurovision datasets, while we also look at trends in power outages in the US. Overall, you'll become proficient in the most common data manipulation tasks in SQL Server and build a solid foundation for the upcoming T-SQL courses here on DataCamp!

Become proficient at using SQL Server to perform common data manipulation tasks.

Introduction to SQL Server

Programming

In this chapter, you'll be introduced to the concept of joining tables, and will explore the different ways you can enrich your queries using inner joins and self joins. You'll also see how to use the case statement to split up a field into different categories.

Introduction to joins

In this chapter, you'll come to grips with different kinds of outer joins. You'll learn how to gain further insights into your data through left joins, right joins, and full joins. In addition to outer joins, you'll also work with cross joins.

Outer joins and cross joins

In this chapter, you'll learn more about set theory using Venn diagrams and get an introduction to union, union all, intersect, and except clauses. You'll finish by investigating semi joins and anti joins, which provide a nice introduction to subqueries.

Set theory clauses

In this closing chapter, you'll learn how to use nested queries and you'll use what you’ve learned in this course to solve three challenge problems.

Subqueries

Countries

Leaders

Diagrams

Now that you've learned the basics of SQL in our <a href="https://www.datacamp.com/courses/intro-to-sql-for-data-science">Intro to SQL for Data Science</a> course,  it's time to supercharge your queries using joins and relational set theory. In this course, you'll learn all about the power of joining tables while exploring interesting features of countries and their cities throughout the world. You will master inner and outer joins, as well as self joins, semi joins, anti joins and cross joins—fundamental tools in any PostgreSQL wizard's toolbox. Never fear set theory again after learning all about unions, intersections, and except clauses through easy-to-understand diagrams and examples. Lastly, you'll be introduced to the challenging topic of subqueries. You will be able to visually grasp these ideas by using Venn diagrams and other linking illustrations.

Introduction to SQL

Learn to join tables, combine tables using set theory, and work with subqueries in PostgreSQL.

Joining Data in SQL

Join two or three tables together into one, combine tables using set theory, and work with subqueries in PostgreSQL.

Data Manipulation

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.

Summarizing Data

This chapter explores essential math operations such as rounding numbers, calculating squares and square roots, and counting records. You will also work with dates in this chapter! 

Math Functions

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. 

Processing Data in SQL Server

In the final chapter of this course, you will work with partitions of data and window functions to calculate several summary stats and see how easy it is to create running totals and compute the mode of numeric columns.

Window Functions

Incidents

Shipments

Kidney

Orders

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.

In this course, you will use T-SQL, the flavor of SQL used in Microsoft's SQL Server for data analysis.

Intermediate SQL Server

This chapter covers date and time functionality in SQL Server, including building dates from component parts, formatting dates for reporting, and working with calendar tables.

Working with Dates and Times

Here, we'll be converting strings and other inputs to date and time data types.

Converting to Dates and Times

In this chapter, we will learn techniques to aggregate data over time.  We will briefly review aggregation functions and statistical aggregation functions.  We will cover upsampling and downsampling of data.  Finally, we will look at the grouping operators.

Aggregating Time Series Data

In this chapter, we will learn how to use window functions to perform calculations over time, including calculating running totals and moving averages, calculating intervals, and finding the maximum levels of overlap.

Answering Time Series Questions with Window Functions

Calendar

Day Spa Rollup

Day Spa Visit

Incident Rollup

Incident Type

Imported Time

SQL Server has a robust set of tools to prepare, aggregate, and query time series data. This course will show you how to build and work with dates, parse dates from strings (and deal with invalid strings), and format dates for reporting. From there, you will see how SQL Server's built-in aggregation operators and window functions can solve important business problems like calculating running totals, finding moving averages, and displaying month-over-month differences using realistic sample data sets. You will also see how taking a different perspective on your data can solve difficult problems.

Explore ways to work with date and time data in SQL Server for time series analysis

Time Series Analysis in SQL Server

In this chapter, you will learn what are the most used data types in SQL Server. You will understand the differences between implicit and explicit conversion and how each type of conversion manifests. You will also get familiar with the functions used for explicitly converting data: CAST() and CONVERT().

Choosing the appropriate data type

Date and time functions are an important topic for databases. In this chapter, you will get familiar with the most common functions for date and time manipulation. You will learn how to retrieve the current date, only parts from a date, to assemble a date from pieces and to check if an expression is a valid date or not.

Manipulating time

Strings are one of the most commonly used data types in databases. It's important to know what you can do with them. In this chapter, you will learn how to manipulate strings, to get the results you want.

Working With Strings

In this chapter, you will work with functions applied to numeric data. You will use aggregate functions for calculating the minimum, maximum or the sum of values from a set. You will learn how to raise a number to a power or to calculate its square root. 


Recognizing Numeric Data Properties

Voters dataset

Ratings dataset

In this course, you will learn how to make use of the most important functions for manipulating data provided by SQL Server.  You can use these functions for processing and transforming data to get the results you want.

Learn the most important functions for manipulating, processing, and transforming data in SQL Server.

Learning Experience

Business Features

Academics

SQL Server Fundamentals

Create Your Free Account

Loved by learners at thousands of companies

Instructors

Loved by learners at thousands of companies

Instructors

Join over .css-w0wpus-TrackShowPage{color:#03ef62;}7,920,000 learners and start SQL Server Fundamentals today!

Create Your Free Account

Join over 7,920,000 learners and start SQL Server Fundamentals today!