课程

Functions for Manipulating Data in PostgreSQL

中级技能水平

更新时间 2026年1月

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

免费开始课程

SQLData Manipulation4 小时13 视频50 练习4,200 经验值96,903成就声明

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

深受数千家公司学习者的喜爱

培训2人或更多？

试用DataCamp for Business

课程描述

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.The videos contain live transcripts you can reveal by clicking "Show transcript" at the bottom left of the videos. The course glossary can be found on the right in the resources section. To obtain CPE credits you need to complete the course and reach a score of 70% on the qualified assessment. You can navigate to the assessment by clicking on the CPE credits callout on the right.

先决条件

Data Manipulation in SQL

1

Overview of Common Data Types

Learn about the properties and characteristics of common data types including strings, numerics and arrays and how to retrieve information about your database.

50 经验值

Text data types

50 经验值

Getting information about your database

100 经验值

Determining data types

100 经验值

Date and time data types

50 经验值

Properties of date and time data types

50 经验值

Interval data types

100 经验值

Working with ARRAYs

50 经验值

Accessing data in an ARRAY

100 经验值

Searching an ARRAY with ANY

100 经验值

Searching an ARRAY with @>

100 经验值

2

Working with DATE/TIME Functions and Operators

Explore how to manipulate and query date and time objects including how to use the current timestamp in your queries, extract subfields from existing date and time fields and what to expect when you perform date and time arithmetic.

Overview of basic arithmetic operators

50 经验值

Adding and subtracting date and time values

100 经验值

INTERVAL arithmetic

100 经验值

Calculating the expected return date

100 经验值

Functions for retrieving current date/time

50 经验值

Current timestamp functions

50 经验值

Working with the current date and time

100 经验值

Manipulating the current date and time

100 经验值

Extracting and transforming date/ time data

50 经验值

Using EXTRACT

100 经验值

Using DATE_TRUNC

100 经验值

Putting it all together

100 经验值

3

Parsing and Manipulating Text

Learn how to manipulate string and text data by transforming case, parsing and truncating text and extracting substrings from larger strings.

Reformatting string and character data

50 经验值

Concatenating strings

100 经验值

Changing the case of string data

100 经验值

Replacing string data

100 经验值

Parsing string and character data

50 经验值

Determining the length of strings

100 经验值

Truncating strings

100 经验值

Extracting substrings from text data

100 经验值

Combining functions for string manipulation

100 经验值

Truncating and padding string data

50 经验值

100 经验值

The TRIM function

100 经验值

Putting it all together

100 经验值

4

Full-text Search and PostgresSQL Extensions

An introduction into some more advanced capabilities of PostgreSQL like full-text search and extensions.

Introduction to full-text search

50 经验值

A review of the LIKE operator

100 经验值

What is a tsvector?

100 经验值

Basic full-text search

100 经验值

Extending PostgreSQL

50 经验值

User-defined data types

100 经验值

Getting info about user-defined data types

100 经验值

User-defined functions in Sakila

100 经验值

Intro to PostgreSQL extensions

50 经验值

Enabling extensions

100 经验值

Measuring similarity between two strings

100 经验值

Levenshtein distance examples

100 经验值

Putting it all together

100 经验值

50 经验值

Functions for Manipulating Data in PostgreSQL

课程完成

获得成就证明

将此证书添加到你的 LinkedIn 档案、简历或履历中
在社交媒体和绩效评估中分享立即注册

加入超过19百万学习者，今天就开始Functions for Manipulating Data in PostgreSQL！

创建您的免费帐户

或

继续操作即表示您接受我们的《使用条款》和《隐私政策》，并同意您的数据存储在美国。

通过 DataCamp for Mobile 提升您的数据技能

随时随地通过我们的移动课程和每日 5 分钟编程挑战提升技能。