シャドーイング練習: 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発音採点文ごとに採点
IPA練習すべての音をマスター
単語学習自分の単語帳を作る
単語ゲーム遊びながら覚える
FOR YOU

おすすめ動画

このレッスンの語彙とスピーキングのポイント

このスピーキングレッスンは、動画「Understand SQL Transactions in 5 Minutes」を教材にしています。 繰り返し出てくる語は次のとおりです:transaction, balance, database, execute, operation。 この動画には、シャドーイング用の文が61文、単語が754語あります。 音声の長さは4:40です。 話す速さは1分あたり約162語で、日常会話に近い自然なペースです。 英語の頻出3,000語に含まれる単語は79%だけなので、語彙は難しめです。

この動画の重要語彙

動画に出てくる覚えておきたい単語15語を、発音と意味つきで紹介します。

単語発音意味
transaction 名詞/tɹænˈzækʃən/処理
database 名詞/ˈdeɪtəˌbeɪs/データベース
execute 動詞/ˈɛksɪˌkjuːt/処刑する, 消す
commit 動詞/kəˈmɪt/預ける, 任せる
visible 形容詞/ˈvɪzɪb(ə)l/見える, 目に見える
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/質問
sequence 名詞/ˈsiː.kwəns/順序
default 名詞/dɪˈfɔlt/デフォルト
execution 名詞/ˌɛk.sɪˈkjuː.ʃən/実行, 執行

動画に出てくる句動詞

単語意味
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

注意したい発音

話し手はdidn't, doesn't, don'tなど、短縮形や弱形を9回使っています。聞こえたとおりの短い形で発音しましょう。

  • 「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/

日本語話者が苦手な音:

  • /r/ と /l/ の区別 — /l/ は舌先を歯茎につけ、/r/ はどこにもつけない: parallel /ˈpæ.ɹəˌlɛl/, tutorial /ˌtjuːˈtɔːɹɪəl/
  • /v/ — /b/ にならないように、上の歯を下唇に当てる: visible /ˈvɪzɪb(ə)l/, dive /daɪv/, verify /ˈvɛɹɪfaɪ/, viewer /ˈvju.ɚ/
  • /f/ — 「フ」ではなく、上の歯と下唇で出す: confirm /kənˈfɝm/, successfully /səkˈsɛs.fə.li/, default /dɪˈfɔlt/, halfway /ˌhæfˈweɪ/, verify /ˈvɛɹɪfaɪ/

この動画での練習方法

  1. まず声を出さずに動画を最後まで聞き、知らない単語をメモします。
  2. まず0.75倍速で一文ずつシャドーイングし、慣れてきたら通常の速度に戻します。
  3. 自分の声を録音して元の音声と比べます。transaction, database, executeなどの単語に特に注意しましょう。

シャドーイングとは?英語上達に効果的な理由

シャドーイング(Shadowing)は、もともとプロの通訳者養成プログラムで開発された言語学習法で、多言語習得者として知られるDr. Alexander Arguelles によって広く普及されました。方法はシンプルですが非常に効果的:ネイティブスピーカーの英語を聞きながら、1〜2秒の遅延で声に出してすぐに繰り返す——まるで「影(shadow)」のように話者を追いかけます。文法ドリルや受動的なリスニングと異なり、シャドーイングは脳と口の筋肉が同時にリアルタイムで英語を処理・再現することを強制します。研究により、発音精度、抑揚、リズム、連音、リスニング力、そして会話の流暢さが大幅に向上することが確認されています。IELTSスピーキング対策や自然な英語コミュニケーションを目指す方に特におすすめです。

シャドーイングのやり方: ステップ別の完全ガイドを読む →