Skip to content
Functions for Manipulating Data in PostgreSQL
Here you can access the tables used in the course. To access the table, you will need to specify the dvdrentals
schema in your queries (e.g., dvdrentals.film
for the film
table and dvdrentals.country
for the country
table).
Note: When using sample integrations such as those that contain course data, you have read-only access. You can run queries, but cannot make any changes such as adding, deleting, or modifying the data (e.g., creating tables, views, etc.).
Take Notes
Add notes about the concepts you've learned and SQL cells with queries you want to keep.
Add your notes here
DataFrameavailable as
movie_info
variable
-- Add your own queries here
SELECT *
FROM dvdrentals.film
LIMIT 10
Explore Datasets
Use the different tables to explore the data and practice your skills!
- Select the
title
,release_year
, andrating
of films in thefilm
table.- Add a
description_shortened
column which contains the first 50 characters of thedescription
column, ending with "...". - Filter the
film
table for rows where thespecial_features
column contains "Commentaries".
- Add a
- Select the
customer_id
,amount
, andpayment_date
from thepayment
table.- Extract date information from the
payment_date
column, creating new columns for theday
,month
,quarter
, andyear
of transaction. - Use the
rental
table to include a column containing the number of days rented (i.e., time between therental_date
and thereturn_date
).
- Extract date information from the
- Update the title column so that titles with multiple words are reduced to the first word and the first letter of the second word followed by a period.
- For example:
- "BEACH HEARTBREAKERS" becomes "BEACH H."
- "BEAST HUNCHBACK" becomes "BEAST H."
- Reformat your shortened title to title case (e.g., "BEACH H." becomes "Beach H.").
- For example: