YoVDO

Cleaning Data in SQL Server Databases

Offered By: DataCamp

Tags

Data Cleaning Courses Microsoft SQL Server Courses Data Transformation Courses Data Aggregation Courses

Course Description

Overview

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

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 course 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?

Syllabus

  • Starting with Cleaning Data
    • To begin the course, you will learn why cleaning data is important. You will solve simple problems such as leading and trailing spaces in strings, unifying formats for flight registrations, combining strings and more.
  • Dealing with missing data, duplicate data, and different date formats
    • In this chapter, you will deepen your data cleaning knowledge. You will learn how to deal with missing data, avoid duplicate data in your datasets, and work with different formats of dates.
  • Dealing with out of range values, different data types, and pattern matching
    • In this chapter, you will deal with out of range values and inaccurate data. You will also practice converting data with different types. Finally, you will work on matching patterns to your data to find outliers.
  • Combining, splitting, and transforming data
    • In this final chapter, you will learn how to combine and aggregate data of some columns into one, split data of one column into more columns, and transform rows into columns and vice versa.

Taught by

Miriam Antona

Related Courses

A Cloud Guru's Elastic Certified Engineer Exam Preparation Course
A Cloud Guru
Elasticsearch Deep Dive
A Cloud Guru
Aggregate Data with LibreOffice Base Queries
Coursera Project Network via Coursera
Aggregate Data in SQL using MySQL Workbench
Coursera Project Network via Coursera
Agrégation de Données avec des Requêtes SQL
Coursera Project Network via Coursera