Using SQL String Functions to Clean Data

Offered By
Coursera Project Network
In this Guided Project, you will:

Understand how string functions work and when to use them

Clean data using different string functions

Manipulate data using SQL SELECT statements together with string functions

Clock2 hours
AdvancedAdvanced
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

Welcome to this project-based course on Using SQL String Functions to Clean Data. In this project, you will learn how to perform data cleaning and manipulation using SQL string functions like LENGTH, UPPER & LOWER, REPLACE, TRIM, SUBSTRING, CONCAT, STRING_AGG, and COALESCE. By the end of this 2-hour long project, you will understand why you need to learn about string functions and use them to get the desired result you want from tables in a database. Also, for this hands-on project, we will use PostgreSQL as our preferred database management system (DBMS). Therefore, to complete this project, it is required that you have prior experience with using PostgreSQL. Similarly, this project is an advanced SQL concept; so, a good foundation for writing SQL queries is vital to complete this project. If you are not familiar with SQL and want to learn the basics, start with my previous guided projects titled “Performing Data definition and Manipulation in SQL" and “Querying Databases using SQL SELECT statement.” I taught these guided projects using PostgreSQL. Taking these projects will give the needed requisite to complete this project Using SQL String Functions to Clean Data. However, if you are comfortable writing queries in PostgreSQL, please join me on this wonderful ride! Let’s get our hands dirty!

Skills you will develop

Data ManipulationData CleansingString FunctionsPostgresqlSQL

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. Retrieve data from tables in the employees database

  2. Use the LENGTH, LEFT, RIGHT functions to retrieve data

  3. Use the UPPER & LOWER functions to clean data

  4. Use the REPLACE function to manipulate data

  5. Use the TRIM, RTRIM, LTRIM functions to clean data

  6. Use the concatenate functions to manipulate data

  7. Use the SUBSTRING function to retrieve data

  8. Use the STRING_AGG function to retrieve and manipulate data

  9. Use the COALESCE function to retrieve and manipulate data

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.