All language subtitles for 021 ASSIGNMENT Calendar Tables_en

Instructor: Our manager, Ethan, is back,

and this time, it looks like he needs some new date fields.

He says, "We need to add a few new fields

to our calendar table

to help us analyze sales trending over time.

Could you please add the following columns

when you get a chance?

Thanks! ETL."

All right, so for this assignment,

you have four key objectives,

and you need to add the following columns

to the calendar table.

So we need to add a column for Month Name,

for example, January,

Month Number, example, 1,

Start of Year, example, 1/1/2020,

and then Year, example, 2020.

All right, so that's it for this assignment.

I will see you in the solution walkthrough next.