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

Ders oluşturuluyor...
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.
📺 Aynı Kanal
Anthropic begged the world to stop AI… then shipped thisB2
3

Anthropic begged the world to stop AI… then shipped this

American AccentBusiness EnglishUniversity StudentsWorking Adults
A $6.3 billion open-weight model just got embarrassed by the French...B2
3

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

Business EnglishUniversity StudentsWorking Adults
7 Things No Programmer Ever Wants to HearB2
2

7 Things No Programmer Ever Wants to Hear

American AccentBusiness EnglishWorking Adults
80% of programmers are NOT happy… why?B2
1

80% of programmers are NOT happy… why?

American AccentBusiness EnglishUniversity StudentsWorking Adults
Raspberry Pi Explained in 100 SecondsB2
4

Raspberry Pi Explained in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
Tragic mistake... Anthropic leaks Claude’s source codeC1
3

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

American AccentBusiness EnglishUniversity StudentsWorking Adults
100+ Docker Concepts you Need to KnowC1

100+ Docker Concepts you Need to Know

American AccentBusiness EnglishUniversity StudentsWorking Adults
The mystery is solved... and the answer is 40x cheaper than ClaudeC1
3

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

American AccentBusiness EnglishUniversity StudentsWorking Adults
An ex-OpenAI researcher just deleted language from the LLM...B2
8

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

American AccentBusiness EnglishUniversity StudentsWorking Adults
25 crazy software bugs explainedB2
9

25 crazy software bugs explained

American AccentBusiness EnglishUniversity StudentsWorking Adults
Git Explained in 100 SecondsB2
9

Git Explained in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
There's a new Linux distro in town for developers...B2
5

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

American AccentBusiness EnglishUniversity StudentsWorking Adults
The "vibe coding" mind virus explained…B2
5

The "vibe coding" mind virus explained…

American AccentBusiness EnglishUniversity StudentsWorking Adults
Linux got wrecked by backdoor attackB2
4

Linux got wrecked by backdoor attack

American AccentBusiness EnglishUniversity StudentsWorking Adults
7 Programming myths that waste your timeB2
4

7 Programming myths that waste your time

American AccentBusiness EnglishUniversity StudentsWorking Adults
Nvidia CUDA in 100 SecondsC1
15

Nvidia CUDA in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
OpenAI’s new browser feels familiar…B2
3

OpenAI’s new browser feels familiar…

American AccentBusiness EnglishUniversity StudentsWorking Adults
Meta's new model wants "deep access" to your personal life...C1
2

Meta's new model wants "deep access" to your personal life...

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
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
✨ Video Öner
Amazon Athena explained in 120 seconds💡C1
15
29 cümleler

Amazon Athena explained in 120 seconds💡

Business EnglishUniversity StudentsWorking Adults
PostgreSQL Architecture Explained: Deep Dive for BeginnersC2
1
83 cümleler

PostgreSQL Architecture Explained: Deep Dive for Beginners

Business EnglishUniversity StudentsWorking Adults
C++ in 100 SecondsC1
2
30 cümleler

C++ in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
How to Create Gold, Silver, and Bronze Tables in Postgres for a Medallion Data Architecture!C1
2
202 cümleler

How to Create Gold, Silver, and Bronze Tables in Postgres for a Medallion Data Architecture!

Business EnglishUniversity StudentsWorking Adults
Redis Crash Course - the What, Why and How to use Redis as your primary databaseC1
231 cümleler

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

Business EnglishUniversity StudentsWorking Adults
Easy Migration from Postgres to Databricks LakebaseC1
2
339 cümleler

Easy Migration from Postgres to Databricks Lakebase

Business EnglishUniversity StudentsWorking Adults
SELECT COUNT (*) can impact your Backend Application Performance, here is whyC1
1
156 cümleler

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

Business EnglishUniversity StudentsWorking Adults
The Secret Sauce Behind NoSQL: LSM TreeC1
1
77 cümleler

The Secret Sauce Behind NoSQL: LSM Tree

Business EnglishUniversity StudentsWorking Adults
Gemma 4 Just Released - Whats In? In 2026!C1
1
28 cümleler

Gemma 4 Just Released - Whats In? In 2026!

Business EnglishUniversity StudentsWorking Adults
Python3 For Pentesting - IntroductionC1
1
80 cümleler

Python3 For Pentesting - Introduction

Business EnglishUniversity StudentsWorking Adults
Gaussian Naive Bayes, Clearly Explained!!!C1
7
107 cümleler

Gaussian Naive Bayes, Clearly Explained!!!

Business EnglishUniversity StudentsWorking Adults
Claude Code: The Advanced Guide (99% of Devs Skip These Features)C1
1
309 cümleler

Claude Code: The Advanced Guide (99% of Devs Skip These Features)

Business EnglishUniversity StudentsWorking Adults

Bu dersin kelimeleri ve konuşma notları

Bu konuşma dersi “PostgreSQL in 100 Seconds” videosuna dayanıyor. En çok tekrarlanan kelimeler: database, table, type, object, relational. Bu videoda gölgeleme çalışması için 28 cümle ve 539 kelime var. Konuşma bölümü 2:36 sürüyor. Konuşmacı hızlı konuşuyor, dakikada yaklaşık 207 kelime; bu yüzden birbirine bağlanan ve zayıflayan sesler duyacaksınız. Kelimelerin yalnızca %75’i İngilizcede en sık kullanılan 3.000 kelime arasında, bu yüzden kelime dağarcığı zorlayıcı.

Bu videodaki önemli kelimeler

Videodan öğrenmeye değer 15 kelime, telaffuzu ve anlamıyla:

KelimeTelaffuzAnlam
database isim/ˈdeɪtəˌbeɪs/veritabanı, veri tabanı
custom isim/ˈkʌstəm/adet, görenek
query isim/ˈkwɪɹ.i/sorgulama
extension isim/ɪkˈstɛnʃən/uzatma, teşmil
cloud isim/ˈklaʊ̯d/bulut
array isim/əˈɹeɪ/elbise, giyecek
bracket isim/ˈbɹækɪt/ayraç, parantez
programmer isim/ˈpɹoʊɡɹæmɚ/programcı
compare fiil/kəmˈpɛɚ/karşılaştırmak, kıyaslamak
procedure isim/pɹəˈsiː.d͡ʒə/işlem, prosedür
designer isim/dɪˈzaɪnɚ/tasarımcı, dizayncı
string isim/stɹɪŋ/ip, tel
developer isim/dɪˈvɛləpɚ/geliştirici
jam isim/ˈd͡ʒæm/reçel, murabba
install fiil/ɪnˈstɔl/indirmek

Dikkat edilecek telaffuzlar

  • “sh” ve “zh” sesleri: extension /ɪkˈstɛnʃən/, transaction /tɹænˈzækʃən/, shout /ʃaʊt/, dimensional /daɪˈmɛn.ʃə.nəl/, notation /noʊˈteɪʃən/
  • Uzun kelimeler — vurguyu doğru yere koyun: 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/

Türkçe konuşanların zorlandığı sesler:

  • Kelime başındaki ünsüz kümesi — araya ünlü eklemeyin: query /ˈkwɪɹ.i/, transaction /tɹænˈzækʃən/, cloud /ˈklaʊ̯d/, bracket /ˈbɹækɪt/, programmer /ˈpɹoʊɡɹæmɚ/
  • /æ/ — “e”den daha açık: transaction /tɹænˈzækʃən/, bracket /ˈbɹækɪt/, programmer /ˈpɹoʊɡɹæmɚ/, jam /ˈd͡ʒæm/, chatbot /ˈtʃætbɑt/

Bu videoyla nasıl çalışılır

  1. Videonun tamamını konuşmadan bir kez dinleyin ve bilmediğiniz kelimeleri not edin.
  2. 0,75× hızla başlayın, cümle cümle tekrar edin ve kolaylaşınca normal hıza dönün.
  3. Kendinizi kaydedin ve orijinaliyle karşılaştırın; database, custom, query gibi kelimelere özellikle dikkat edin.

Gölgeleme Tekniği Nedir?

Gölgeleme, başlangıçta profesyonel tercüman eğitimi için geliştirilen ve çok dilli Dr. Alexander Arguelles tarafından popüler hale getirilen, bilim destekli bir dil öğrenme tekniğidir. Yöntem basit ama güçlüdür: ana dili İngilizce olan bir sesi dinler ve hemen yüksek sesle tekrar edersiniz — konuşmacıyı 1-2 saniye gecikmeyle takip eden bir gölge gibi. Pasif dinleme veya dilbilgisi alıştırmalarının aksine, gölgeleme beyninizi ve ağız kaslarınızı gerçek konuşma kalıplarını eşzamanlı olarak işlemeye ve yeniden üretmeye zorlar. Araştırmalar, telaffuz doğruluğu, tonlama, ritim, bağlı konuşma, dinleme anlama ve konuşma akıcılığını önemli ölçüde geliştirdiğini göstermektedir — bu da onu IELTS Konuşma hazırlığı ve gerçek dünya İngilizce iletişimi için en etkili yöntemlerden biri yapar.

Shadowing tekniği: adım adım eksiksiz rehberi okuyun →