Functions for Manipulating Data in PostgreSQL
- Offered byDataCamp
Functions for Manipulating Data in PostgreSQL at DataCamp Overview
Duration | 4 hours |
Mode of learning | Online |
Difficulty level | Intermediate |
Official Website | Go to Website  |
Credential | Certificate |
Functions for Manipulating Data in PostgreSQL at DataCamp Highlights
- Earn a certificate after completion of the course
- Learn from the industry best faculty
Functions for Manipulating Data in PostgreSQL at DataCamp Course details
Database Administrators (DBAs)
Data Analysts and Scientists
IT Professionals
Developers
Introduction to PostgreSQL Functions
Creating and Managing SQL Functions
Advanced PL/pgSQL Functions
Data Transformation and Aggregation
Working with Complex Data Types
Performance Optimization
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
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
You will delve into the rich world of PostgreSQL functions and learn how to effectively manipulate data using the powerful tools provided by this advanced open-source relational database system
Functions for Manipulating Data in PostgreSQL at DataCamp Curriculum
Getting information about your database
Determining data types
Date and time data types
Adding and subtracting date and time values
INTERVAL arithmetic
Calculating the expected return date
Concatenating strings
Changing the case of string data
A review of the LIKE operator
What is a tsvector?
Other courses offered by DataCamp
Student Forum
Anything you would want to ask experts?