Shadowing Practice: Database vs Data Warehouse vs Data Lake | Explaining the Differences - Learn English Speaking with Video

Choose a practice mode

Each mode opens a full-screen practice room.

42 sentences
If sentences are too short or too long, click Edit to adjust them.
1
We live in a world that runs on data.
2
It's how Amazon and Netflix know which movies and products to recommend, how Starbucks manages a global supply chain,
3
and how Uber connects drivers with passengers in real time.
4
But the thing is, data skills aren't just for tech companies or professional analysts anymore.
5
Everyone works with data to some degree, and everyone can benefit from data literacy skills.
6
In this video, we're covering an important topic that will help you take your data literacy to the next level.
7
Alright, so accessing data is one thing, but organizing and storing it is a completely different beast.
8
So at a high level, some of the most common storage modes that you're likely to encounter include flat files, databases, data warehouses, and data lakes.
9
Now, there are other, less common storage methods and hybrid variations of these as well, but our goal here is really just to paint some broad strokes
10
and help you understand the key similarities and differences between them.
11
Now, the simplest method of data storage is a flat file,
12
which is typically a static tabular data extract saved either to a local drive or cloud storage like Google Drive or OneDrive.
13
And this is very common for one off projects or quick ad hoc analyses that don't require multiple data sources, ongoing maintenance or complex data models.
14
The most common types of flat files you'll see are CSVs and Excel workbooks.
15
Now, a database is a collection of related tables stored in a database management system, or DBMS.
16
Databases are typically used for recording and collecting data tied to a single application or business process,
17
like capturing transactional records or real-time website activity.
18
And they're usually optimized for online transactional processing,
19
known as OLTP, meaning that they're built to receive and store data as efficiently as possible, but aren't really ideal for querying or analysis.
20
Common database options include MySQL, Amazon RDS, Microsoft Access or SQL Server, and many, many more.
21
A data warehouse, on the other hand, is a database
22
or a collection of data sourced from multiple databases that's typically structured to support specific analytics needs
23
and is optimized for online analytical processing, or OLAP.
24
That basically just means it's built in a way
25
that makes it very easy and very fast for users to access the data they need for analytical purposes.
26
examples of data warehouse tools include Amazon Redshift, Google BigQuery, Snowflake, Teradata, and others.
27
And finally we have data lakes which are essentially a repository of both structured
28
and unstructured data sources often stored in their raw unprocessed state.
29
So we're talking about everything from CSV files to MP4s, PDFs, text documents, and so on.
30
Instead of getting Being cleaned and prepped on the way in, data is typically extracted from the lake and transformed for specific purposes,
31
often relating to machine learning or AI.
32
Some examples of data lakes include Amazon S3, Azure Data Lake, Google Cloud, and more.
33
Now, if you're feeling a little overwhelmed about what this all means, no need to worry.
34
I've worked in data analytics and business intelligence for over 15 years, and I still get confused by this stuff.
35
The good news is that unless you plan to become a data engineer, it's extremely unlikely that you would be the one building or configuring databases or warehouses.
36
In fact, in most cases, data engineers or architects are the ones primarily responsible for standing up these systems
37
and building the pipelines and automations that help the data flow from one place to another.
38
If you enjoyed this content and want to see more, we've got a brand new Data Literacy Foundations course, and it's entirely free.
39
You can check it out at mavenanalytics.io.
40
So whether you're an individual looking to build confidence, a leader seeking to empower and upskill your team, or a data professional just trying to to stay ahead of the curve,
41
this is the course for you.
42
We've got a lot to cover, so let's dive in.

Download App

Everything you need to speak fluently

AI PronunciationScore every sentence
IPA PracticeMaster every sound
VocabularyBuild your word bank
Vocab GameLearn while playing

Same Channel

FOR YOU

Recommend Video

Vocabulary and speaking notes for this lesson

This video has 42 sentences and 674 words to shadow. The speech runs for 4:14. The speaker talks at a natural 159 words per minute, close to everyday conversation. Only 78% of the words are among the 3,000 most common in English, so the vocabulary is demanding.

Key vocabulary in this video

15 less common words from the video, with pronunciation and meaning:

  • database /ˈdeɪtəˌbeɪs/ (noun) — A collection of (usually) organized information in a regular structure, usually but not necessarily in a machine-readable format accessible by a computer.
  • warehouse /ˈwɛə(ɹ)haʊs/ (noun) — A facility for storing large amounts of merchandise or products.
  • literacy /ˈlɪtəɹəsi/ (noun) — The ability to read and write.
  • cloud /ˈklaʊ̯d/ (noun) — A visible mass of water droplets suspended in the air.
  • skill /skɪl/ (noun) — A capacity to do something well; a technique, an ability, usually acquired or learned, as opposed to abilities that are regarded as innate.
  • extract /ˈɛkstɹækt/ (noun) — Something that is extracted or drawn out.
  • analytics /ˌæn.əˈlɪt.ɪks/ (noun) — The principles governing any of various forms of analysis.
  • analytical /ˌæn.əˈlɪt.ɪ.kəl/ (adjective) — Of or pertaining to analysis; resolving into elements or constituent parts
  • topic /ˈtɑpɪk/ (noun) — A subject; a theme; a category or general area of interest.
  • primarily /ˈpɹaɪ.mə.ɹə.li/ (adverb) — Of a primary or central nature, first and foremost.
  • confused /kənˈfjuːzd/ (adjective) — unable to think clearly or understand
  • ideal /aɪˈdi(ə)l/ (adjective) — Pertaining to ideas, or to a given idea.
  • capture /ˈkæp.(t)ʃɚ/ (verb) — To take control of; to seize by force or stratagem.
  • essentially /ɪˈsɛnʃəli/ (adverb) — In essence: by nature.
  • connect /kəˈnɛkt/ (verb) — To join (to another object): to attach, or to be intended to attach or capable of attaching, to another object.

Phrasal verbs you will hear

  • dive in (verb) — To start a new endeavor enthusiastically and wholeheartedly.
  • live in (verb) — To reside on the premises of one's employer (used especially of domestic staff such as nannies, cooks, maids, etc.)
  • run on (verb) — To continue without interruption
  • stand up (verb) — To rise from a lying or sitting position.
  • talk about (verb) — Used to draw attention to the speaker's characterization of someone or something.
  • work in (verb) — To find time or space for, amid other things.

Pronunciation to watch

The speaker uses 14 contractions and reduced forms, such as you're, aren't, they're. Say them the short way, as you hear them.

  • The “sh” and “zh” sounds: capture /ˈkæp.(t)ʃɚ/, essentially /ɪˈsɛnʃəli/, variation /ˌvɛəɹiˈeɪʃn̩/, automation /ˌɔ.təˈmeɪ.ʃən/, transactional /trænˈzækʃ(ə)nəl/
  • Long words — get the stress right: literacy /ˈlɪtəɹəsi/, analytics /ˌæn.əˈlɪt.ɪks/, analytical /ˌæn.əˈlɪt.ɪ.kəl/, primarily /ˈpɹaɪ.mə.ɹə.li/, essentially /ɪˈsɛnʃəli/

How to practise with this video

  1. Listen to the whole video once without speaking and note the words you do not know.
  2. Start at 0.75× speed, shadow it sentence by sentence, then go back to normal speed once it feels easy.
  3. Record yourself and compare with the original, paying attention to words like database, warehouse, literacy.

What is the Shadowing Technique?

Shadowing is a science-backed language learning technique originally developed for professional interpreter training and popularized by polyglot Dr. Alexander Arguelles. The method is simple but powerful: you listen to native English audio and immediately repeat it out loud — like a shadow following the speaker with just a 1–2 second delay. Unlike passive listening or grammar drills, shadowing forces your brain and mouth muscles to simultaneously process and reproduce real speech patterns. Research shows it significantly improves pronunciation accuracy, intonation, rhythm, connected speech, listening comprehension, and speaking fluency — making it one of the most effective methods for IELTS Speaking preparation and real-world English communication.

Shadowing technique: read the full step-by-step guide →