Live training

String Manipulation in PostgreSQL

Join us for this live, hands-on training where you will do a deep dive into text/string manipulation functions available in PostgreSQL. The session will use a dataset that looks at short-term rentals in Cambridge, Massachusetts and we will look to answer questions like "Which neighborhood in Cambridge has the highest percentage of short-term rentals?" and "What is the most popular short-term rental service in Cambridge?"

Thursday 4 June, 3 PM EDT, 8 PM BST
Register Now
SQL

What will I learn?

You will learn how to:

  • How to manipulate and clean source data using functions to reformat and manipulate string and character data.
  • How to use string functions to extract subsets of text data that can be used to create new fields for your queries.
  • How to create user defined functions and use them in SQL queries

What should I prepare?

Please note, a Gmail account is required in order to use Colaboratory, a free Jupyter notebook environment. You can join the webinar from your web browser following the instructions you receive in your registration email. All required data/resources will be provided in the training.

Who should attend?

This course is open to all DataCamp Premium learners, looking to build SQL skills for manipulating data for reporting and analysis. We recommend that you have taken the following course before attending:

  • Intermediate SQL
  • Functions for Manipulating Data in PostgreSQL
  • Exploratory Data Analysis in SQL

Brian Piccolo Headshot

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 technology and software development experience with product management and business acumen.
Follow on LinkedIn