Cleaning Data in SQL Server Databases

Name: Cleaning Data in SQL Server Databases
Brand: Careervira
Price: 98 CAD
Availability: InStock
Rating: 5.0 (3 reviews)

DataCamp

(3)

Course Report

Find detailed report of this course which helps you make an informed decision on its relevance to your learning needs. Find out the course's popularity among Careervira users and the job roles that would find the course relevant for their upskilling here. You can also find how this course compares against similar courses and much more in the course report.

Visit Course Report

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

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...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%