Shadowing Practice: PostgreSQL in 100 Seconds - Learn English Speaking with Video

PostgreSQL, the most trusted name in open -source relational databases.

Its development dates all the way back to 1986 at UC Berkeley, under the direction of Michael Stonebraker.

Like other pure relational databases, it stores data in tables, columns, and rows, and uses structured query language to read and write data.

However, PostgreSQL is technically an object relational database, which means it can create its own custom data types to store objects with properties

and support advanced features like inheritance and polymorphism.

When writing data, it runs fully ACID -compliant transactions, but also adds its own special sauce called multi -version concurrency control,

which gives each transaction a snapshot of the database, allowing multiple transactions to run at the same time without traffic jams or locks.

Developers also love its extensibility.

Queries can be reused by writing stored procedures, and it even supports languages beyond SQL like Python and C.

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,

or PG embedding to give AI chatbots long -term memory, and the list goes on.

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,

in addition to a bunch of other advanced features like branching.

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.

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.

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,

then make it a two -dimensional array by adding another set of brackets.

We also have JSON data types to handle unstructured data, and even key value pairs with extensions like hstore.

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.

Once the table is created, we can then use an insert statement to add a row of data into it.

Notice the use of a double colon to cast a string into JSON or H store types.

And now finally, we can read the data with a select statement

that uses dot notation to access the properties on our custom object.

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.

We can then find those Lambos by doing a join query that compares the programmer's ID to the Lambo's owner ID.

This has been PostgreSQL in 100 seconds.

Big shout out to NeonDB for sponsoring and making this awesome database free to use in the cloud.

Thanks for watching, and I will see you in the next one.

📺 Zelfde Kanaal

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

✨ Aanbevolen Video

B2 Shadowing Practice Missing A Connection At The Airport

2,521

12 zinnen

B2 Shadowing Practice Missing A Connection At The Airport

Travel EnglishDaily ConversationUniversity Students

9 zinnen

Is meditation the quietening of thought? | Krishnamurti

Daily ConversationUniversity StudentsWorking Adults

6 zinnen

Neuroscience of Time

University StudentsWorking Adults

IELTS Speaking Part3 | Do people go to the countryside to travel or to live?#ieltsspeakingsample

553

5 zinnen

IELTS Speaking Part3 | Do people go to the countryside to travel or to live?#ieltsspeakingsample

IELTS PrepHigh School StudentsUniversity Students

24 zinnen

IELTS Speaking Part 2: A Place That Changed My Perspective

IELTS PrepUniversity StudentsWorking Adults

You Need to Believe in Yourself I Robert Greene

191

12 zinnen

You Need to Believe in Yourself I Robert Greene

Business EnglishUniversity StudentsWorking Adults

How Cell Phones Impact Our Relationships

253

24 zinnen

How Cell Phones Impact Our Relationships

Business EnglishDaily ConversationUniversity Students

207

28 zinnen

Weekly Team Meeting: Project Status Update

Business EnglishWorking Adults

if you wear nice clothes #denzelwashington #motiationalspeech #motivation

713

9 zinnen

if you wear nice clothes #denzelwashington #motiationalspeech #motivation

Business EnglishUniversity StudentsWorking Adults

118

16 zinnen

Can Earth Run Out of Water?

IELTS PrepTOEFL PrepUniversity Students

13 zinnen

We are educated to compare | Krishnamurti

IELTS PrepTOEFL PrepUniversity Students

25 zinnen

Woordenschat en spreektips bij deze les

Deze spreekles is gebaseerd op de video “PostgreSQL in 100 Seconds”. Deze woorden komen het vaakst terug: database, table, type, object, relational. Deze video bevat 28 zinnen en 539 woorden om na te spreken. Het gesproken deel duurt 2:36. De spreker praat snel, ongeveer 207 woorden per minuut, dus reken op verbonden en ingeslikte klanken. Slechts 75% van de woorden hoort bij de 3.000 meest gebruikte Engelse woorden, dus de woordenschat is pittig.

Belangrijke woorden in deze video

15 woorden uit de video die het leren waard zijn, met uitspraak en betekenis:

Woord	Uitspraak	Betekenis
database zelfstandig naamwoord	/ˈdeɪtəˌbeɪs/	database, databank
custom zelfstandig naamwoord	/ˈkʌstəm/	manieren, gebruiken
query zelfstandig naamwoord	/ˈkwɪɹ.i/	vraag, verzoek
extension zelfstandig naamwoord	/ɪkˈstɛnʃən/	uitbreiding, extensie
cloud zelfstandig naamwoord	/ˈklaʊ̯d/	wolk
bracket zelfstandig naamwoord	/ˈbɹækɪt/	haakje
programmer zelfstandig naamwoord	/ˈpɹoʊɡɹæmɚ/	programmeur
compare werkwoord	/kəmˈpɛɚ/	vergelijken
select werkwoord	/sɪˈlɛkt/	uitkiezen, selecteer
procedure zelfstandig naamwoord	/pɹəˈsiː.d͡ʒə/	procedure
designer zelfstandig naamwoord	/dɪˈzaɪnɚ/	ontwerper, designer
string zelfstandig naamwoord	/stɹɪŋ/	draad, koord
connect werkwoord	/kəˈnɛkt/	verbinden
define werkwoord	/dɪˈfaɪn/	bepalen, determineren
developer zelfstandig naamwoord	/dɪˈvɛləpɚ/	ontwikkelaar, ontwerper

Uitspraak om op te letten

De klanken “sh” en “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 woorden — let op de klemtoon: 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/

Klanken die Nederlandstaligen lastig vinden:

Stemhebbende eindmedeklinker — /b/, /d/, /g/, /z/, /v/ niet verscherpen: cloud /ˈklaʊ̯d/, columns /ˈkɑləmz/, correspond /ˌkoɹəˈspɑnd/, embed /ɪmˈbɛd/, shard /ˈʃɑːd/
/æ/ — opener dan de Nederlandse “e”: transaction /tɹænˈzækʃən/, bracket /ˈbɹækɪt/, programmer /ˈpɹoʊɡɹæmɚ/, jam /ˈd͡ʒæm/, chatbot /ˈtʃætbɑt/
/g/ — een harde plofklank, geen Nederlandse “g”: programmer /ˈpɹoʊɡɹæmɚ/, exotic /ɪɡˈzɑtɪk/

Zo oefen je met deze video

Luister de hele video één keer zonder te spreken en noteer de woorden die je niet kent.
Begin op 0,75× snelheid, spreek zin voor zin na en ga terug naar normale snelheid zodra het makkelijk gaat.
Neem jezelf op en vergelijk met het origineel; let daarbij op woorden als database, custom, query.

Wat is de Shadowing-techniek?

Shadowing is een wetenschappelijk onderbouwde taalleermethode die oorspronkelijk is ontwikkeld voor professionele tolkentraining en gepopulariseerd door polyglot Dr. Alexander Arguelles. De methode is eenvoudig maar krachtig: je luistert naar native Engelse audio en herhaalt het onmiddellijk hardop — als een schaduw die de spreker volgt met slechts 1–2 seconden vertraging. In tegenstelling tot passief luisteren of grammaticadrills, dwingt shadowing je hersenen en mondspieren om echte spraakpatronen tegelijkertijd te verwerken en te reproduceren. Onderzoek toont aan dat het de uitspraaknauwkeurigheid, intonatie, ritme, verbonden spraak, luisterbegrip en spreekvaardigheid aanzienlijk verbetert — waardoor het een van de meest effectieve methoden is voor IELTS Speaking-voorbereiding en echte Engelse communicatie.

Shadowing-techniek: lees de volledige stap-voor-stap-gids →

Shadowing Practice: PostgreSQL in 100 Seconds - Learn English Speaking with Video

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

DNS Explained in 100 Seconds

Anthropic begged the world to stop AI… then shipped this

One man just liberated Fable... and now it’s illegal

7 Things No Programmer Ever Wants to Hear

80% of programmers are NOT happy… why?

Raspberry Pi Explained in 100 Seconds

Tragic mistake... Anthropic leaks Claude’s source code

100+ Docker Concepts you Need to Know

Docker in 100 Seconds

The mystery is solved... and the answer is 40x cheaper than Claude

An ex-OpenAI researcher just deleted language from the LLM...

25 crazy software bugs explained

Git Explained in 100 Seconds

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

The "vibe coding" mind virus explained…

Linux got wrecked by backdoor attack

7 Programming myths that waste your time

Nvidia CUDA in 100 Seconds

OpenAI’s new browser feels familiar…