Shadowing Practice: Understand SQL Transactions in 5 Minutes - Learn English Speaking with Video

Choose a practice mode

Each mode opens a full-screen practice room.

61 sentences
If sentences are too short or too long, click Edit to adjust them.
1
Ever lost data because something crashed halfway through a database update?
2
SQL transactions are here to protect you.
3
In this video, I'll explain them in simple terms, so you can keep your data safe and consistent, even when things go wrong.
4
A transaction is one of the key concepts in all database management systems.
5
Transactions allow multiple database operations to be grouped into one unit.
6
Within a single transaction, a sequence of data operations either occurs completely or not at all.
7
All intermediate states within a single transaction are not visible to other transactions, and if the transaction cannot be successfully completed for some reason,
8
none of the results will be saved in the database.
9
The easiest way to understand database transactions is through the classic example of banking transactions.
10
Imagine we are working with a bank's database.
11
We have a table that contains information about clients and their available balances.
12
For simplicity, this is a table consisting of two columns, the client's name, and the available balance.
13
Let's assume we want to transfer $100 from Andrew's account to John's account.
14
To do this, we need to perform the following operations.
15
Reduce Andrew balance by $100 with the update command, then increase John balance by these $100.
16
To perform such operation, we need to do two actions.
17
It is necessary that all these actions execute together or not execute at all.
18
A short failure isn't critical if Andrew's first attempt to transfer John's money fails, and both simply keep their original balances.
19
However, if one operation is completed, for example, Andrew's money is deducted but John's account doesn't receive it, this leads to serious issues.
20
In the real world, anything can happen between these two operations.
21
A brief network outage, an error at the banking application level, or something else.
22
We need a guarantee that if something interrupts the completion of this group of operations,
23
none of the results of the intermediate commands will be recorded in the database,
24
and we can get this guarantee if we combine these actions into a single transaction.
25
In PostgreSQL, a transaction consists of a series of SQL commands between the begin and commit statements.
26
If during a transaction we decide not to commit the changes, for example, if Andrew's balance turns negative,
27
we can use the rollback command instead of commit undoing all modifications.
28
It's also important to understand how transactions interact with each other.
29
By default, the transaction isolation level in PostgreSQL is Red Committed.
30
This means that transactions only see the data that other transactions have confirmed
31
and do not see changes made by these transactions that have not yet been confirmed.
32
Let's look at this example in practice.
33
I already have a table prepared with the necessary data.
34
Let's execute a select.
35
We see two balance records let's execute the transaction step -by -step.
36
First, let's perform a begin.
37
We started a transaction.
38
Everything that will happen here in this connection is now occurring within this transaction.
39
Let's execute the next line.
40
Execute select.
41
We see the intermediate result, but it is visible only within our current transaction.
42
Let's open a parallel connection to the database and perform a select from that connection, meaning outside the scope of the current transaction.
43
Open a new connection and execute the query.
44
We see that here Andrew's balance is still displayed as 600,
45
although in another open transaction we started an update and Andrew's balance has already decreased by 100.
46
Let's go back there and continue the transaction perform the next update
47
and see how the data in the table looks now
48
we see that john's balance increased by 100
49
but i repeat we see all this only within the current transaction if we switch to parallel connection
50
everything is still the same as it was before the transaction was executed let's go back and finally commit the transaction
51
Now the result is fully committed, and we will see it within Parallel Transactions.
52
Let's verify this.
53
Execute this query.
54
Now we see the final result.
55
Everything that happened within the transaction block wasn't visible in other database sessions until the transaction was committed,
56
and if the transaction hadn't been committed but was rolled back, then the result of the intermediate executions wouldn't be visible.
57
Thanks for watching.
58
If you want to dive deeper, my complete SQL course on Udemy is available with a special offer for YouTube viewers.
59
You'll get hands -on exercises, quizzes, and advanced tips we didn't cover here.
60
Links in the description.
61
And don't forget to subscribe for more tutorials.

Download App

Everything you need to speak fluently

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

Recommend Video

Vocabulary and speaking notes for this lesson

This speaking lesson is built on the video “Understand SQL Transactions in 5 Minutes”. The speaker keeps coming back to these words: transaction, balance, database, execute, operation. This video has 61 sentences and 754 words to shadow. The speech runs for 4:40. The speaker talks at a natural 162 words per minute, close to everyday conversation. Only 79% of the words are among the 3,000 most common in English, so the vocabulary is demanding.

Key vocabulary in this video

15 words from the video worth learning, with pronunciation and meaning:

WordPronunciationMeaning
transaction noun/tɹænˈzækʃən/The act of conducting or carrying out (business, negotiations, plans).
database noun/ˈdeɪtəˌbeɪs/A collection of (usually) organized information in a regular structure, usually but not necessarily in a machine-readable format accessible by a computer.
execute verb/ˈɛksɪˌkjuːt/To kill, especially as punishment for a capital crime.
commit verb/kəˈmɪt/To give in trust; to put into charge or keeping; to entrust; to consign; used with to or formerly unto.
visible adjective/ˈvɪzɪb(ə)l/Able to be seen.
intermediate adjective/ɪn.tə(ɹ)ˈmi.di.ət/Being between two extremes, or in the middle of a range.
select verb/sɪˈlɛkt/To choose one or more elements of a set, especially a set of options.
parallel adjective/ˈpæ.ɹəˌlɛl/Equally distant from one another at all points.
occur verb/əˈkɜː/To happen or take place.
guarantee noun/ˌɡæɹ.ənˈtiː/Anything that assures a certain outcome.
confirm verb/kənˈfɝm/To strengthen; to make firm or resolute.
consist noun/kənˈsɪst/A lineup or sequence of railroad carriages or cars, with or without a locomotive, that form a unit.
query noun/ˈkwɪɹ.i/A question, an inquiry (US), an enquiry (UK).
consistent adjective/kənˈsɪs.tənt/Of a regularly occurring, dependable nature.
successfully adverb/səkˈsɛs.fə.li/In a successful manner; with success; without failing.

Phrasal verbs you will hear

WordMeaning
go back verbTo return to a place or state after having been there at a previous time.
roll back verbTo return to a prior state.

Sentences worth repeating

Short, complete lines from the video that you can reuse in everyday conversation:

  • Imagine we are working with a bank's database.
  • Let's look at this example in practice.
  • First, let's perform a begin.
  • Let's execute the next line.

Grammar in this video

The structures the speaker uses most, with the exact words from the video:

StructureIn the video
Passive voice be + past participle — the focus is on what happens, not who does itbe grouped · cannot be successfully completed · will be saved
Present perfect have/has + past participle — a past action that still matters nowhave confirmed · has already decreased

Pronunciation to watch

The speaker uses 9 contractions and reduced forms, such as didn't, doesn't, don't. Say them the short way, as you hear them.

  • The “sh” and “zh” sounds: transaction /tɹænˈzækʃən/, execution /ˌɛk.sɪˈkjuː.ʃən/, completion /kəmˈpliː.ʃən/, isolation /ˌaɪsəˈleɪʃən/, modification /ˌmɑdɪfɪˈkeɪʃən/
  • Long words — get the stress right: intermediate /ɪn.tə(ɹ)ˈmi.di.ət/, successfully /səkˈsɛs.fə.li/, execution /ˌɛk.sɪˈkjuː.ʃən/, isolation /ˌaɪsəˈleɪʃən/, modification /ˌmɑdɪfɪˈkeɪʃən/

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 transaction, database, execute.

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 →