Skip to main content

course

Functions for Manipulating Data in PostgreSQL

Intermediate

4.4+

Updated 12/2024

Learn the most important PostgreSQL functions for manipulating, processing, and transforming data.

Start course for free

Included for FreePremium or Teams

SQLData Manipulation4 hours13 videos50 exercises4,200 XP69,160Statement of Accomplishment

Create Your Free Account

Google LinkedIn Facebook

or

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

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

Text data types

Getting information about your database

Determining data types

Date and time data types

Properties of date and time data types

Interval data types

Working with ARRAYs

Accessing data in an ARRAY

Searching an ARRAY with ANY

Searching an ARRAY with @>

2

Working with DATE/TIME Functions and Operators

Overview of basic arithmetic operators

Adding and subtracting date and time values

INTERVAL arithmetic

Calculating the expected return date

Functions for retrieving current date/time

Current timestamp functions

Working with the current date and time

Manipulating the current date and time

Extracting and transforming date/ time data

Using EXTRACT

Using DATE_TRUNC

Putting it all together

3

Parsing and Manipulating Text

Reformatting string and character data

Concatenating strings

Changing the case of string data

Replacing string data

Parsing string and character data

Determining the length of strings

Truncating strings

Extracting substrings from text data

Combining functions for string manipulation

Truncating and padding string data

The TRIM function

Putting it all together

4

Full-text Search and PostgresSQL Extensions

Introduction to full-text search

A review of the LIKE operator

What is a tsvector?

Basic full-text search

Extending PostgreSQL

User-defined data types

Getting info about user-defined data types

User-defined functions in Sakila

Intro to PostgreSQL extensions

Enabling extensions

Measuring similarity between two strings

Levenshtein distance examples

Putting it all together

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

Don’t just take our word for it

*4.4

from 52 reviews

69%

10%

13%

8%

0%

Highest to Lowest
Lowest to Highest
Most recent
Top reviews

Signe B.

7 days

All good

Elisha V.

9 days

Working with strings was such a hustle for me but now, it is all gone

ISIAKA O.

12 days

It was a good review of the topics covered.

Yilian S.

about 1 month

Great Data Manipulation Course from Data Camp

William B.

3 months

It was a very practical and interesting course

"All good"

Signe B.

"Working with strings was such a hustle for me but now, it is all gone"

Elisha V.

"It was a good review of the topics covered."

ISIAKA O.

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

Create Your Free Account

Google LinkedIn Facebook

or

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