Using SQL String Functions to Clean Data

von
Coursera Project Network
In diesem Angeleitetes Projekt werden Sie:

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
AdvancedFortgeschritten
CloudKein Download erforderlich
VideoVideo auf geteiltem Bildschirm
Comment DotsEnglisch
LaptopNur Desktop

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!

Kompetenzen, die Sie erwerben werden

Data ManipulationData CleansingString FunctionsPostgresqlSQL

Schritt für Schritt lernen

In einem Video, das auf einer Hälfte Ihres Arbeitsbereichs abgespielt wird, führt Sie Ihr Dozent durch diese Schritte:

  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

Ablauf angeleiteter Projekte

Ihr Arbeitsbereich ist ein Cloud-Desktop direkt in Ihrem Browser, kein Download erforderlich

Ihr Dozent leitet Sie in einem Video mit geteiltem Bildschirm Schritt für Schritt an.

Häufig gestellte Fragen

Häufig gestellte Fragen

Haben Sie weitere Fragen? Besuchen Sie das Learner Help Center.