Overview

Context

Did you know that data scientists and data analysts spend a large amount of time cleaning data before they can analyze it? This is because real-world data is messy. To help you navigate messy data this Cleaning Data in SQL Server Databases course offered by Data Camp teaches you how to clean data stored in an SQL Server database.

You’ll learn how to solve common problems such as how to clean messy strings, deal with empty values, compare the similarity between strings, and much more.

You’ll get hands-on with all these tasks using a wide range of interesting and messy datasets, including monthly airline flights by airport, TV series and paper shop sales. Are you ready to get your hands messy?

Programme Structure

Chapters

Starting with Cleaning Data
Dealing with missing data, duplicate data, and different date formats
Dealing with out of range values, different data types, and pattern matching
Combining, splitting, and transforming data

Key information

Duration

Part-time
- 1 days

Start dates & application deadlines

You can apply for and start this programme anytime.

Language

English

Delivered

Online

Campus Location

New York City, United States

Disciplines

Data Science & Big Data View 460 other Short Courses in Data Science & Big Data in United States

Join for free or log in to access our complete career info list.

Academic requirements

We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.

English requirements

We are not aware of any English requirements for this programme.

Other requirements

General requirements

PREREQUISITES

Intermediate SQL Server

Tuition Fees

Tuition fees are shown in and the most likely applicable fee is shown based on your nationality.

International Applies to you

Applies to you

Non-residents

Free
Out-of-State

Free
Domestic

Applies to you

In-State

Free

Additional Details

This course can be accessed for free with the Data Camp Premium or Teams subscriptions

Funding

Improve page content

Cleaning Data in SQL Server Databases Data Camp

About