Skip to main content
HomeSQL

Course

Functions for Manipulating Data in PostgreSQL

IntermediateSkill Level
4.7+
2,356 reviews
Updated 08/2022
Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.
Start Course for Free

Included withPremium or Teams

SQLData Manipulation4 hr13 videos50 Exercises4,200 XP81,035Statement 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 2,356 reviews
79%
19%
1%
0%
0%
  • Phuong
    7 minutes

  • Kevin
    10 minutes

  • Ronald
    24 minutes

  • Nhung
    about 1 hour

  • Piotr
    about 6 hours

  • Nonticha
    about 7 hours

Phuong

Kevin

Ronald

Join over 17 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.