Shadowing-Übung: PostgreSQL in 100 Seconds - Englisch Sprechen Lernen mit Video

Übungsmodus wählen

Jeder Modus öffnet einen Übungsraum im Vollbild.

28 Sätze
Wenn Sätze zu kurz oder zu lang sind, klicke auf Edit, um sie anzupassen.
1
PostgreSQL, the most trusted name in open -source relational databases.
2
Its development dates all the way back to 1986 at UC Berkeley, under the direction of Michael Stonebraker.
3
Like other pure relational databases, it stores data in tables, columns, and rows, and uses structured query language to read and write data.
4
However, PostgreSQL is technically an object relational database, which means it can create its own custom data types to store objects with properties
5
and support advanced features like inheritance and polymorphism.
6
When writing data, it runs fully ACID -compliant transactions, but also adds its own special sauce called multi -version concurrency control,
7
which gives each transaction a snapshot of the database, allowing multiple transactions to run at the same time without traffic jams or locks.
8
Developers also love its extensibility.
9
Queries can be reused by writing stored procedures, and it even supports languages beyond SQL like Python and C.
10
And it has a robust ecosystem of extensions, like PostGIS to provide geospatial data for apps like Uber, or Citus to shard and distribute the database to any scale,
11
or PG embedding to give AI chatbots long -term memory, and the list goes on.
12
To get started, you can download and install it locally, or better yet, use a free cloud database like Neon, which provides autoscaling out of the box and a nice UI to manage your data,
13
in addition to a bunch of other advanced features like branching.
14
Create a new database, then head over to the SQL editor to run your first query, or connect it to your IDE with an extension like SQL tools we could get started by creating a new table.
15
But because this is an object -relational database, let's begin by creating a custom data type, which defines the structure of an object with corresponding properties and types.
16
What's awesome about Postgres, though, is that we have more exotic data modeling options, like arrays can be used by putting brackets in front of a type,
17
then make it a two -dimensional array by adding another set of brackets.
18
We also have JSON data types to handle unstructured data, and even key value pairs with extensions like hstore.
19
Now that we have this custom type, we can use it within one or more tables, like one table for programmers and another for designers.
20
Once the table is created, we can then use an insert statement to add a row of data into it.
21
Notice the use of a double colon to cast a string into JSON or H store types.
22
And now finally, we can read the data with a select statement
23
that uses dot notation to access the properties on our custom object.
24
Every table has a unique primary key, and we can create relationships by storing the primary key from one table as the foreign key on another, like a programmer might own many Lambos.
25
We can then find those Lambos by doing a join query that compares the programmer's ID to the Lambo's owner ID.
26
This has been PostgreSQL in 100 seconds.
27
Big shout out to NeonDB for sponsoring and making this awesome database free to use in the cloud.
28
Thanks for watching, and I will see you in the next one.

App herunterladen

Alles, was du zum fließenden Sprechen brauchst

KI-AussprachebewertungJeder Satz bewertet
IPA-TrainingJeden Laut meistern
WortschatzBaue deinen Wortschatz auf
VokabelspielSpielend lernen
QR scannen
QR scannen
Download on theApp StoreGet it onGoogle Play
📺 Gleicher Kanal
A $6.3 billion open-weight model just got embarrassed by the French...C1
3

A $6.3 billion open-weight model just got embarrassed by the French...

Daily ConversationUniversity StudentsWorking Adults
OpenAI’s lead engineer was secretly a spy...C1
3

OpenAI’s lead engineer was secretly a spy...

Daily ConversationUniversity StudentsWorking Adults
There's a new Linux distro in town for developers...C1
5

There's a new Linux distro in town for developers...

American AccentDaily ConversationUniversity StudentsWorking Adults
Every app on Earth is now open source... whether it likes it or notC1
2

Every app on Earth is now open source... whether it likes it or not

Daily ConversationWorking Adults
OpenAI’s new browser feels familiar…B2
3

OpenAI’s new browser feels familiar…

American AccentBusiness EnglishUniversity StudentsWorking Adults
Intel chips can’t possibly be this bad… 100% crash rate?B2
6

Intel chips can’t possibly be this bad… 100% crash rate?

American AccentBusiness EnglishUniversity StudentsWorking Adults
Did Google just kickstart the intelligence explosion?C1
3

Did Google just kickstart the intelligence explosion?

American AccentBusiness EnglishDaily ConversationUniversity Students
Godot in 100 SecondsC1
2

Godot in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
The most interesting "hack" in history...C1
7

The most interesting "hack" in history...

American AccentBusiness EnglishUniversity StudentsWorking Adults
Grok 4 pushes humanity closer to AGI… but there’s a problemB2
1

Grok 4 pushes humanity closer to AGI… but there’s a problem

American AccentBusiness EnglishUniversity StudentsWorking Adults
Array Map in 100 SecondsC1
3

Array Map in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
Docker in 100 SecondsC1
30

Docker in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
The one OpenAI announcement that can actually make you money...C1
10

The one OpenAI announcement that can actually make you money...

American AccentDaily ConversationUniversity StudentsWorking Adults
How to NOT Fail a Technical InterviewC1
6

How to NOT Fail a Technical Interview

American AccentInterview EnglishUniversity StudentsWorking Adults
10 weird OSS projects you need right now...C1
12

10 weird OSS projects you need right now...

American AccentBusiness EnglishUniversity StudentsWorking Adults
Firefox and Tor hit with 9.8 critical level exploitB2
3

Firefox and Tor hit with 9.8 critical level exploit

American AccentBusiness EnglishUniversity StudentsWorking Adults
5 open source tools that replaced my $320/mo AI stack...B2
3

5 open source tools that replaced my $320/mo AI stack...

American AccentBusiness EnglishUniversity StudentsWorking Adults
25 crazy software bugs explainedB2
10

25 crazy software bugs explained

American AccentDaily ConversationUniversity StudentsWorking Adults
C++ in 100 SecondsC1
2

C++ in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
DHH has gone completely off the rails...C1
1

DHH has gone completely off the rails...

American AccentBusiness EnglishUniversity StudentsWorking Adults
✨ Empfohlenes Video
Amazon Athena explained in 120 seconds💡C1
15
29 Sätze

Amazon Athena explained in 120 seconds💡

Daily ConversationUniversity StudentsWorking Adults
Redis Crash Course - the What, Why and How to use Redis as your primary databaseC1
231 Sätze

Redis Crash Course - the What, Why and How to use Redis as your primary database

Daily ConversationUniversity StudentsWorking Adults
GPT-6 Astra Solved Chess. Unbelievable.C1
1
436 Sätze

GPT-6 Astra Solved Chess. Unbelievable.

Daily ConversationWorking Adults
SELECT COUNT (*) can impact your Backend Application Performance, here is whyC1
1
156 Sätze

SELECT COUNT (*) can impact your Backend Application Performance, here is why

Daily ConversationWorking Adults
The hottest programming skill in 2026C1
1
96 Sätze

The hottest programming skill in 2026

Daily ConversationUniversity StudentsWorking Adults
The Secret Sauce Behind NoSQL: LSM TreeC1
1
77 Sätze

The Secret Sauce Behind NoSQL: LSM Tree

Daily ConversationUniversity StudentsWorking Adults
Course Preview | SC-100 | Microsoft Cybersecurity ArchitectC1
1
60 Sätze

Course Preview | SC-100 | Microsoft Cybersecurity Architect

Daily ConversationWorking Adults
I Bet Nobody Has Ever Explained the Backend Ecosystem Like This BeforeC1
1
164 Sätze

I Bet Nobody Has Ever Explained the Backend Ecosystem Like This Before

Daily ConversationWorking Adults
Database Sharding! Designing Data-Intensive Applications chapter 6C1
1
689 Sätze

Database Sharding! Designing Data-Intensive Applications chapter 6

Daily ConversationUniversity StudentsWorking Adults
GitHub Copilot now controls your command line...C1
1
68 Sätze

GitHub Copilot now controls your command line...

Daily ConversationUniversity StudentsWorking Adults
I Tried PewDiePie's Odysseus AI So You Don't Have ToC1
1
341 Sätze

I Tried PewDiePie's Odysseus AI So You Don't Have To

Daily ConversationWorking Adults
How I Made $30,000 Hacking Broken Access ControlC1
1
207 Sätze

How I Made $30,000 Hacking Broken Access Control

Daily ConversationWorking Adults

Wortschatz und Sprechhinweise zu dieser Lektion

Diese Sprechübung basiert auf dem Video „PostgreSQL in 100 Seconds“. Diese Wörter kommen am häufigsten vor: database, table, type, object, relational. Dieses Video enthält 28 Sätze und 539 Wörter zum Nachsprechen. Der gesprochene Teil dauert 2:36. Der Sprecher spricht schnell, etwa 207 Wörter pro Minute – rechne mit verbundenen und verkürzten Lauten. Nur 75 % der Wörter gehören zu den 3.000 häufigsten im Englischen, der Wortschatz ist also anspruchsvoll.

Wichtiger Wortschatz in diesem Video

15 lernenswerte Wörter aus dem Video, mit Aussprache und Bedeutung:

WortAusspracheBedeutung
database Substantiv/ˈdeɪtəˌbeɪs/Datenbank
custom Substantiv/ˈkʌstəm/Brauch, Gewohnheit
query Substantiv/ˈkwɪɹ.i/Frage
extension Substantiv/ɪkˈstɛnʃən/Ausdehnung, Erweiterung
transaction Substantiv/tɹænˈzækʃən/Geschäftsabwicklung, Geschäftsdurchführung
cloud Substantiv/ˈklaʊ̯d/Wolke, Gewölk
array Substantiv/əˈɹeɪ/Bekleidung, Tracht
bracket Substantiv/ˈbɹækɪt/Winkel, Träger
programmer Substantiv/ˈpɹoʊɡɹæmɚ/Programmierer, Programmiererin
compare Verb/kəmˈpɛɚ/vergleichen, komparieren
select Verb/sɪˈlɛkt/auswählen
procedure Substantiv/pɹəˈsiː.d͡ʒə/Verfahren, Verfahrensweise
designer Substantiv/dɪˈzaɪnɚ/Designer, Designerin
string Substantiv/stɹɪŋ/Schnur
connect Verb/kəˈnɛkt/verbinden

Aussprache, auf die du achten solltest

  • Die Laute „sh“ und „zh“: extension /ɪkˈstɛnʃən/, transaction /tɹænˈzækʃən/, shout /ʃaʊt/, dimensional /daɪˈmɛn.ʃə.nəl/, notation /noʊˈteɪʃən/
  • Lange Wörter – auf die Betonung achten: developer /dɪˈvɛləpɚ/, technically /ˈtɛk.nɪˌkəl.i/, dimensional /daɪˈmɛn.ʃə.nəl/, inheritance /ɪnˈhɛɹɪtəns/, ecosystem /ˈikoʊˌsɪstəm/

Laute, die Deutschsprachigen schwerfallen:

  • Stimmhafter Auslaut — /b/, /d/, /g/, /z/, /v/ am Wortende nicht verhärten: cloud /ˈklaʊ̯d/, columns /ˈkɑləmz/, correspond /ˌkoɹəˈspɑnd/, embed /ɪmˈbɛd/, shard /ˈʃɑːd/
  • /æ/ — offener als „ä“: transaction /tɹænˈzækʃən/, bracket /ˈbɹækɪt/, programmer /ˈpɹoʊɡɹæmɚ/, jam /ˈd͡ʒæm/, chatbot /ˈtʃætbɑt/
  • /dʒ/ — stimmhaft, nicht „tsch“: procedure /pɹəˈsiː.d͡ʒə/, jam /ˈd͡ʒæm/

So übst du mit diesem Video

  1. Höre dir das ganze Video einmal an, ohne zu sprechen, und notiere die Wörter, die du nicht kennst.
  2. Beginne mit 0,75-facher Geschwindigkeit, sprich Satz für Satz nach und wechsle zur normalen Geschwindigkeit, sobald es leichtfällt.
  3. Nimm dich auf und vergleiche mit dem Original; achte dabei auf Wörter wie database, custom, query.

Was ist die Shadowing-Technik?

Shadowing ist eine wissenschaftlich fundierte Sprachlerntechnik, die ursprünglich für die professionelle Dolmetscherausbildung entwickelt und durch den Polyglotten Dr. Alexander Arguelles populär gemacht wurde. Die Methode ist einfach aber wirkungsvoll: Du hörst englisches Audio von Muttersprachlern und wiederholst es sofort laut — wie ein Schatten, der dem Sprecher mit nur 1–2 Sekunden Verzögerung folgt. Anders als passives Hören oder Grammatikübungen zwingt Shadowing dein Gehirn und deine Mundmuskulatur, gleichzeitig echte Sprachmuster zu verarbeiten und zu reproduzieren. Studien zeigen, dass es Aussprachegenauigkeit, Intonation, Rhythmus, verbundene Sprache, Hörverständnis und Sprechflüssigkeit signifikant verbessert — was es zu einer der effektivsten Methoden für die IELTS Speaking-Vorbereitung und reale englische Kommunikation macht.

Shadowing-Technik: die vollständige Schritt-für-Schritt-Anleitung lesen →