Functions for Manipulating Data in PostgreSQL

via

DataCamp

Course Features

Duration

4 hours

Delivery Method

Online

Available on

Limited Access

Accessibility

Mobile, Desktop, Laptop

Language

English

Subtitles

English

Level

Intermediate

Teaching Type

Self Paced

Video Content

4 hours

Course Description

This course focuses on teaching you how to effectively use PostgreSQL functions in your SQL queries to manipulate various types of data, such as strings, numbers, and dates. It also covers the concept of full-text search in PostgreSQL, allowing you to match and index keywords within your files. Additionally, the course explores the use of PostgreSQL Extensions to enhance these search capabilities. By the end of this course, you will be equipped with the knowledge and skills needed to utilize PostgreSQL function for data manipulation in data science applications.

Course Overview

Virtual Labs

International Faculty

Post Course Interactions

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Intermediate SQL

What You Will Learn

And finally, you'll learn how to extend these features by using PostgreSQL extensions

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

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

Course Content

Expand all sections

Module 1: Overview of Common Data Types

Module 2: Working with DATE/TIME Functions and Operators

Module 3: Parsing and Manipulating Text

Module 4: Full-text Search and PostgresSQL Extensions

Course Instructors

Brian Piccolo

Sr. Director, Digital Strategy

A results-driven digital leader with 15+ years of experience as an entrepreneur, agency executive and senior manager at a Fortune 100 company. Unique and diverse background combining hands-on technol...