Pratica di Shadowing: Understand SQL Transactions in 5 Minutes - Impara a parlare inglese con i video

Scegli una modalità di pratica

Ogni modalità apre una sala di pratica a schermo intero.

61 frasi
Se le frasi sono troppo corte o troppo lunghe, clicca su Edit per modificarle.
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.

Scarica l'app

Tutto ciò che serve per parlare fluentemente

Pronuncia con IAVoto per ogni frase
Pratica IPAPadroneggia ogni suono
VocabolarioCostruisci il tuo lessico
Gioco di vocabolarioImpara giocando
FOR YOU

Video consigliato

Vocabolario e note di pronuncia per questa lezione

Questa lezione di conversazione si basa sul video “Understand SQL Transactions in 5 Minutes”. Le parole che ritornano più spesso: transaction, balance, database, execute, operation. Questo video contiene 61 frasi e 754 parole da ripetere con lo shadowing. Il parlato dura 4:40. Chi parla ha un ritmo naturale di circa 162 parole al minuto, vicino a una conversazione quotidiana. Solo il 79% delle parole rientra nelle 3.000 più comuni dell’inglese, quindi il lessico è impegnativo.

Vocaboli chiave di questo video

15 parole del video che vale la pena imparare, con pronuncia e significato:

ParolaPronunciaSignificato
database sostantivo/ˈdeɪtəˌbeɪs/database, base di dati
execute verbo/ˈɛksɪˌkjuːt/giustiziare
commit verbo/kəˈmɪt/affidare, impegnarsi
visible aggettivo/ˈvɪzɪb(ə)l/visibile
intermediate aggettivo/ɪn.tə(ɹ)ˈmi.di.ət/intermedio
select verbo/sɪˈlɛkt/scegliere, selezionare
parallel aggettivo/ˈpæ.ɹəˌlɛl/parallelo
occur verbo/əˈkɜː/verificarsi
guarantee sostantivo/ˌɡæɹ.ənˈtiː/garanzia
confirm verbo/kənˈfɝm/cresimare
consist sostantivo/kənˈsɪst/composizione, configurazione
query sostantivo/ˈkwɪɹ.i/interrogativo, domanda
consistent aggettivo/kənˈsɪs.tənt/costante, continuo
successfully avverbio/səkˈsɛs.fə.li/con successo
sequence sostantivo/ˈsiː.kwəns/sequenza

I phrasal verb che sentirai

ParolaSignificato
go back verbotornare

Frasi da ripetere

Frasi brevi e complete del video che puoi riutilizzare nella conversazione di tutti i giorni:

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

La grammatica di questo video

Le strutture che chi parla usa di più, con le parole esatte del video:

StrutturaNel video
Forma passiva be + participio passato — conta ciò che accade, non chi lo fabe grouped · cannot be successfully completed · will be saved
Present perfect have/has + participio passato — un’azione passata che conta ancora adessohave confirmed · has already decreased

Pronuncia a cui fare attenzione

Chi parla usa 9 contrazioni e forme ridotte, come didn't, doesn't, don't. Pronunciale nella forma breve, così come le senti.

  • I suoni “sh” e “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/
  • Parole lunghe — attenzione all’accento: 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/

I suoni difficili per chi parla italiano:

  • Consonante finale — senza aggiungere una vocale dopo: database /ˈdeɪtəˌbeɪs/, execute /ˈɛksɪˌkjuːt/, commit /kəˈmɪt/, intermediate /ɪn.tə(ɹ)ˈmi.di.ət/, select /sɪˈlɛkt/
  • /æ/ — più aperta della “e”: transaction /tɹænˈzækʃən/, parallel /ˈpæ.ɹəˌlɛl/, guarantee /ˌɡæɹ.ənˈtiː/, halfway /ˌhæfˈweɪ/, interact /ɪn.təˈɹækt/

Come esercitarsi con questo video

  1. Ascolta tutto il video una volta senza parlare e annota le parole che non conosci.
  2. Inizia a velocità 0,75×, fai shadowing frase per frase e torna alla velocità normale quando diventa facile.
  3. Registrati e confronta con l’originale, facendo attenzione a parole come database, execute, commit.

Cos'è la tecnica dello Shadowing?

Shadowing è una tecnica di apprendimento delle lingue supportata da studi scientifici, originariamente sviluppata per la formazione dei traduttori professionisti e resa popolare dal poliglotta Dr. Alexander Arguelles. Il metodo è semplice ma potente: ascolti un audio in inglese di madrelingua e lo ripeti immediatamente ad alta voce — come un'ombra che segue il parlante con un ritardo di solo 1–2 secondi. A differenza dell'ascolto passivo o degli esercizi di grammatica, lo shadowing costringe il tuo cervello e i muscoli della bocca a elaborare e riprodurre simultaneamente i modelli di discorso reale. La ricerca dimostra che migliora significativamente la precisione della pronuncia, l'intonazione, il ritmo, il discorso connesso, la comprensione dell'ascolto e la fluidità del parlato — rendendolo uno dei metodi più efficaci per la preparazione alla prova di speaking dell'IELTS e per la comunicazione reale in inglese.

Tecnica dello shadowing: leggi la guida completa passo dopo passo →