Cleaning Data in SQL Server Databases

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

Data scientists spend a lot time cleaning up data before they can analyze it. Data scientists and analysts spend a lot time cleaning up real-world data. This course will teach you how to navigate messy data. You will learn how to solve common problems such as empty strings, clean up messier strings, compare strings and many more. This task will be done using a variety interesting and messy datasets, including monthly airline flights, TV series, paper shop sales, and TV series. Are you ready to get messy?

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL Server

What You Will Learn

Develop the skills you need to clean raw data and transform it into accurate insights

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

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

Course Content

Expand all sections

Module 1: Starting with Cleaning Data

Module 2: Dealing with missing data, duplicate data, and different date formats

Module 3: Dealing with out of range values, different data types, and pattern matching

Module 4: Combining, splitting, and transforming data

Course Instructors

Miriam Antona

Software Engineer

Miriam Antona has 10+ years of experience working as a Software Engineer. She is focused on analyzing, designing, and developing software applications for the Justice Administration. Miriam loves pro...