Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:00,000 --> 00:00:01,000
Instructor: All right, it's time
2
00:00:01,000 --> 00:00:02,000
for your next assignment,
3
00:00:02,000 --> 00:00:06,000
and you've got another email from your manager, Ethan.
4
00:00:06,000 --> 00:00:07,000
"Hi!
5
00:00:07,000 --> 00:00:08,000
We're looking to better understand
6
00:00:08,000 --> 00:00:10,000
where our customers may be coming from,
7
00:00:10,000 --> 00:00:12,000
based on their email domains.
8
00:00:12,000 --> 00:00:14,000
Could you please create a new column
9
00:00:14,000 --> 00:00:16,000
in the customer table that will allow us to do this?
10
00:00:16,000 --> 00:00:18,000
Thanks! ETL."
11
00:00:18,000 --> 00:00:21,000
For this assignment, you've got four key objectives.
12
00:00:21,000 --> 00:00:24,000
Number one, we need to duplicate the email address column
13
00:00:24,000 --> 00:00:26,000
and name it Domain Name.
14
00:00:26,000 --> 00:00:28,000
Next, in that new column,
15
00:00:28,000 --> 00:00:32,000
remove all text or characters except for the domain name.
16
00:00:32,000 --> 00:00:35,000
Next, we're gonna use transformation steps to clean up
17
00:00:35,000 --> 00:00:37,000
and capitalize the domain name,
18
00:00:37,000 --> 00:00:41,000
for example, Adventure Works.
19
00:00:41,000 --> 00:00:43,000
And then last, we'll save and apply.
20
00:00:43,000 --> 00:00:44,000
All right, have fun,
21
00:00:44,000 --> 00:00:46,000
and I will see you in the solution walkthrough.
1560
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof