Skip to main content
HomeSQL

Course

Functions for Manipulating Data in PostgreSQL

Intermediate
4.7+
1,414 reviews
Updated 05/2025
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Start Course for Free

Included withPremium or Teams

SQLData Manipulation4 hours13 videos50 Exercises4,200 XP76,777Statement of Accomplishment

Create Your Free Account

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies

Course Description

This course will provide you an understanding of how to use built-in PostgreSQL functions in your SQL queries to manipulate different types of data including strings, character, numeric and date/time. We'll travel back to a time where Blockbuster video stores were on every corner and if you wanted to watch a movie, you actually had to leave your house to rent a DVD! You'll also get an introduction into the robust full-text search capabilities which provides a powerful tool for indexing and matching keywords in a PostgreSQL document. And finally, you'll learn how to extend these features by using PostgreSQL extensions.

Prerequisites

Data Manipulation in SQL
1

Overview of Common Data Types

Start Chapter
2

Working with DATE/TIME Functions and Operators

Start Chapter
3

Parsing and Manipulating Text

Start Chapter
4

Full-text Search and PostgresSQL Extensions

Start Chapter
Functions for Manipulating Data in PostgreSQL
Course
Complete

Earn Statement of Accomplishment

Add this credential to your LinkedIn profile, resume, or CV
Share it on social media and in your performance review

Included withPremium or Teams

Enroll now

Don’t just take our word for it

*4.7
from 1,414 reviews
79%
20%
1%
0%
0%
  • Adilbek
    about 3 hours

  • Douglas
    about 4 hours

  • James
    about 4 hours

  • Faith
    about 5 hours

  • Raaed
    about 8 hours

  • Plamen
    about 12 hours

Adilbek

Douglas

James

    Join over 16 million learners and start Functions for Manipulating Data in PostgreSQL today!

    Create Your Free Account

    or

    By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.