Overview
Context
If you surveyed a large number of data scientists and data analysts about which tasks are most common in their workday, cleaning data would likely be in almost all responses.
This is the case because real-world data is messy. To help you tame messy data, this Cleaning Data in PostgreSQL Databases course offered by Data Camp teaches you how to clean data stored in a PostgreSQL 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 practice with these tasks using interesting (but messy) datasets made available by New York City's Open Data program. Are you ready to whip that messy data into shape?
Programme Structure
Chapters
- Data Cleaning
- Missing, Duplicate, and Invalid Data
- Converting Data
- Transforming Data
Key information
Duration
- Part-time
- 1 days
Start dates & application deadlines
Language
Delivered
Campus Location
- New York City, United States
Disciplines
Data Science & Big Data View 463 other Short Courses in Data Science & Big Data in United StatesWhat students do after studying
Academic requirements
We are not aware of any specific GRE, GMAT or GPA grading score requirements for this programme.
English requirements
We are not aware of any English requirements for this programme.
Other requirements
General requirements
PREREQUISITES
- Data Manipulation in SQL
Tuition Fees
-
International Applies to you
Applies to youNon-residentsFree - Out-of-StateFree
-
Domestic
Applies to youIn-StateFree
Additional Details
This course can be accessed for free with the Data Camp Premium or Teams subscriptions