跟读练习: Understand SQL Transactions in 5 Minutes - 通过视频学习英语口语

选择练习模式

每种模式都会打开全屏练习室。

61 句
如果句子过短或过长,请点击 Edit 进行调整。
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.

下载应用

流利口语所需的一切

AI 发音评分逐句打分
音标练习掌握每个音
词汇学习建立你的词库
词汇游戏边玩边学
FOR YOU

推荐视频

本课的词汇与口语要点

这节口语课以视频“Understand SQL Transactions in 5 Minutes”为素材。 视频中反复出现的词有:transaction, balance, database, execute, operation。 这段视频共有 61 个句子、754 个单词可供跟读。 讲话部分时长为 4:40。 说话人语速自然,每分钟约 162 个词,接近日常对话。 只有 79% 的单词属于英语最常用的 3,000 词,词汇难度较高。

视频中的重点词汇

视频中 15 个值得学习的单词,附发音和释义:

单词发音释义
transaction 名词/tɹænˈzækʃən/處理 /处理
database 名词/ˈdeɪtəˌbeɪs/數據庫 /数据库
execute 动词/ˈɛksɪˌkjuːt/處決 /处决, 處死 /处死
visible 形容词/ˈvɪzɪb(ə)l/看得見 /看得见, 可看見的 /可看见的
intermediate 形容词/ɪn.tə(ɹ)ˈmi.di.ət/中間 /中间, 中級 /中级
select 动词/sɪˈlɛkt/選 /选, 挑選 /挑选
parallel 形容词/ˈpæ.ɹəˌlɛl/平行的
occur 动词/əˈkɜː/發生 /发生
guarantee 名词/ˌɡæɹ.ənˈtiː/保證 /保证
confirm 动词/kənˈfɝm/證實 /证实, 確認 /确认
consist 名词/kənˈsɪst/編組 /编组
query 名词/ˈkwɪɹ.i/問題 /问题, 質問 /质问
consistent 形容词/kənˈsɪs.tənt/一貫的 /一贯的
sequence 名词/ˈsiː.kwəns/序列, 順序 /顺序
default 名词/dɪˈfɔlt/違約 /违约, 暴雷

视频中出现的短语动词

单词释义
go back 动词回去, 返回

值得反复跟读的句子

视频中简短而完整的句子,可以直接用在日常对话里:

  • 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.

视频中的语法

说话人最常用的结构,并附上视频中的原话:

结构视频中的用法
被动语态 be + 过去分词 — 强调发生了什么,而不是谁做的be grouped · cannot be successfully completed · will be saved
现在完成时 have/has + 过去分词 — 过去发生但与现在仍有关联的事have confirmed · has already decreased

需要注意的发音

说话人用了 9 次缩略和弱读形式,例如 didn't, doesn't, don't。请按听到的简短形式来说。

  • “sh” 和 “zh” 音: 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/
  • 长单词——注意重音位置: 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/

中文母语者容易读错的音:

  • /v/ — 不要读成 /w/,上齿轻触下唇: visible /ˈvɪzɪb(ə)l/, dive /daɪv/, verify /ˈvɛɹɪfaɪ/, viewer /ˈvju.ɚ/
  • 词尾辅音 — 要读清楚,后面不要加元音: database /ˈdeɪtəˌbeɪs/, execute /ˈɛksɪˌkjuːt/, commit /kəˈmɪt/, intermediate /ɪn.tə(ɹ)ˈmi.di.ət/, select /sɪˈlɛkt/
  • /r/ 和 /l/ 的区别: parallel /ˈpæ.ɹəˌlɛl/, tutorial /ˌtjuːˈtɔːɹɪəl/

如何用这段视频练习

  1. 先完整听一遍视频,不要开口,记下不认识的单词。
  2. 先用 0.75 倍速逐句跟读,熟练之后再回到正常速度。
  3. 录下自己的声音并与原声对比,特别注意 transaction, database, execute 这类单词。

什么是跟读法?

跟读法 (Shadowing) 是一种有科学依据的语言学习技巧,最初开发用于专业口译员的培训,并由多语言者Alexander Arguelles博士普及。这个方法简单而强大:您在听英语母语原声的同时立即大声重复——就像是一个延迟1-2秒紧跟说话者的影子。与被动听力或语法练习不同,跟读法强迫您的大脑和口腔肌肉同时处理并模仿真实的讲话模式。研究表明它能显着提高发音准确性,语调,节奏,连读,听力理解和口语流利度——使其成为雅思口语备考和真实英语交流最有效的方法之一。

影子跟读法: 阅读完整分步指南 →