Cleaning Data in PostgreSQL Databases

Name: Cleaning Data in PostgreSQL Databases
Brand: Careervira
Price: 71 USD
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 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?

Highlights

Pedagogy

Top 20 Percentile

Rating & Reviews

Top 30 Percentile

Parameters

Pedagogy

Acquire all major Relational Database skills in this course for seamless integration into your daily life. Develop a versatile skill set, allowing you to confidently apply what you've learned in various practical scenarios, enhancing your daily experiences and overall proficiency. An exceptional course in Relational Database, this stands out for its Self Paced learning approach. Learners have the flexibility to progress at their own speed, tailoring the experience to their individual needs.

Rating & Reviews

This highly acclaimed course is among the top-rated in Relational Database, boasting a rating greater than 4 and an overall rating of 5.0. Its exceptional quality sets it apart, making it an excellent choice for individuals seeking top-notch learning experience in Relational Database.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

Learn to tame your raw, messy data stored in a PostgreSQL database to extract 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 practice with these tasks using interesting (but messy) datasets made available by New York City's Open Data program

Course Content

Expand all sections

Module 1: Data Cleaning Basics

Module 2: Missing, Duplicate, and Invalid Data

Module 3: Converting Data

Module 4: Transforming Data

Course Instructors

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%