课程

在 PostgreSQL 中使用函数处理数据

中级技能水平

更新时间 2026年1月

学习用于操作、处理和转换数据的最重要 PostgreSQL 函数。

免费开始课程

SQLData Manipulation

4小时

13 视频

50 道练习

4,200 XP

99,116

成就证明

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

需要团队培训？

企业版试用

课程描述

本课程将带您理解如何在 SQL 查询中使用 PostgreSQL 内置函数来处理不同类型的数据，包括字符串、字符、数值以及日期/时间。我们还会回到当年 Blockbuster 门店遍布街头的时代——想看电影，您得真的出门去租一张 DVD！此外，您还将初步了解功能强大的全文检索能力，它为在 PostgreSQL 文档中建立索引和匹配关键词提供了有力工具。最后，您会学习如何通过使用 PostgreSQL 扩展来扩展这些功能。视频包含实时字幕，您可以点击视频左下角的 "Show transcript" 展开查看。课程术语表位于右侧的资源部分。若要获得 CPE 学分，您需要完成课程并在合格测评中达到 70% 的得分。您可以点击右侧的 CPE 学分提示跳转到测评。

先决条件

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.

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

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

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

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

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

An introduction into some more advanced capabilities of PostgreSQL like full-text search and 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

在 PostgreSQL 中使用函数处理数据

课程完成

获得成就证明

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

加入超过19百万学习者，今天就开始在 PostgreSQL 中使用函数处理数据！

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

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