Artificial Intelligence & Data Science
Star icon
Most Popular
Hands on Training icon
Hands On Training
Star icon
Hands on Training icon

Cleaning Data in PostgreSQL Databases

Course Cover

5

(3)

compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Mobile, Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

Data scientists and analysts are often asked to clean data. This is because real-life data can be messy. This course will show you how to clean up messy data in a PostgreSQL database. You will learn how to handle messy strings, empty values and compare strings. These tasks can be done using messy datasets from New York City's Open Data Program. Are you up for messy data being transformed into useful information?

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

check-card-img

Intermediate SQL

What You Will Learn

check-card-img

Learn to tame your raw, messy data stored in a PostgreSQL database to extract accurate insights

check-card-img

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

check-card-img

You’ll get hands-on practice with these tasks using interesting (but messy) datasets made available by New York City's Open Data program

Course Instructors

Author Image

Darryl Reeves Ph.D

Industry Assistant Professor, NYU Tandon School of Engineering

Darryl is a computational scientist with expertise in utilizing data-driven approaches to solve complex problems in both academic and business settings. He worked for a number of years in a variety o...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover