Data Manipulation with SQL
Learning Outcomes
Get More Info
data, Tech & ai skills in
What’s Included
Course Introduction
Course Introduction
In this lesson, we learn about how we can manipulate our data by changing the data type. We also demonstrate the main areas covered by this course, date functions, string functions, and null handling functions.
Date and Time Functions
Date and Time Functions
In this lesson, we learn about date functions that we can use to calculate the time elapsed between a date column and the current time and/or date.
EXTRACT Function
EXTRACT Function
In this lesson, we learn how to use the EXTRACT function to extract a specific portion from a date such as year, quarter, month, week and day.
LOWER and UPPER Functions
LOWER and UPPER Functions
In this lesson, we learn how to change the case of a string column. This is particularly useful for applying filters on a word when we want to disregard the case of the search term.
Concatenation Operator
Concatenation Operator
In this lesson, we learn how to combine multiple text based columns into one column using the concatenation operator.
LEFT and POSITION Functions
LEFT and POSITION Functions
In this lesson, we extract a first name from a column containing a full name. We do this by using the LEFT and POSITION functions.
RIGHT and CHAR_LENGTH Functions
RIGHT and CHAR_LENGTH Functions
In this lesson, we extract a surname from a column containing a full name. We do this by using the RIGHT and CHAR_LENGTH functions.
Converting Data Types
Converting Data Types
In this lesson, we learn how to use the :: operator to change the data type of a column.
COALESCE Function
COALESCE Function
In this lesson, we learn how to use the COALESCE function to replace null values with real values. This is useful when we want to make calculations on columns that include null values.
NULLIF Function
NULLIF Function
In this lesson, we use the NULLIF function to avoid divide by 0 errors. In maths, dividing by 0 can't be done, so doing this in SQL results in an error. However, replacing 0s with null values results in a simple null value instead.
Certifications
A Learner Experience Designed to Deliver Transformation
How Leading Teams Use Kubicle to Upskill & Excel
