Studyportals
Short Online

Cleaning Data in SQL Server Databases

1 days
Duration
Free
Free
Unknown
Tuition fee
Anytime
Unknown
Apply date
Anytime
Unknown
Start date

About

To help you navigate messy data this Cleaning Data in SQL Server Databases course  at Data Camp teaches you how to clean data stored in an SQL Server database.

Overview

Context of the  Cleaning Data in SQL Server Databases course at Data Camp

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.

 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

Academic requirements

We are not aware of any academic 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 Fee

To alway see correct tuition fees
  • International

    Free
    Tuition Fee
    Based on the tuition of 0 USD for the full programme during 1 days.
  • National

    Free
    Tuition Fee
    Based on the tuition of 0 USD for the full programme during 1 days.
  • Basic Access: Free
  • Enterprise: Contact sales for pricing
  • Premium (for individuals): $5.75/month billed annually
  • Teams (for teams of 2 and up): $5.75 per user /month billed annually

Funding

Studyportals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.

Our partners

Cleaning Data in SQL Server Databases
-
Data Camp

Wishlist

Go to your profile page to get personalised recommendations!