تدريب Shadowing: PostgreSQL in 100 Seconds - تعلم التحدث بالإنجليزية عبر الفيديو

جارٍ إنشاء الدرس...
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.
📺 نفس القناة
A $6.3 billion open-weight model just got embarrassed by the French...B2
2

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

DNS Explained in 100 SecondsC1
2

DNS Explained in 100 Seconds

American AccentBusiness EnglishUniversity StudentsWorking Adults
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
One man just liberated Fable... and now it’s illegalB2
2

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

American AccentBusiness 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
Did Google just kickstart the intelligence explosion?C1
2

Did Google just kickstart the intelligence explosion?

American AccentBusiness EnglishDaily ConversationUniversity Students
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
When open-sourcing your code goes wrong...C1
7

When open-sourcing your code goes wrong...

American AccentBusiness EnglishUniversity StudentsWorking Adults
Docker in 100 SecondsC1
29

Docker in 100 Seconds

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
✨ فيديو موصى به
B2 Shadowing Practice Missing A Connection At The AirportB2
2,488
12 جمل

B2 Shadowing Practice Missing A Connection At The Airport

Travel EnglishDaily ConversationUniversity Students
Is meditation the quietening of thought? | KrishnamurtiC1
92
9 جمل

Is meditation the quietening of thought? | Krishnamurti

Daily ConversationUniversity StudentsWorking Adults
IELTS Speaking Part3 | Do people go to the countryside to travel or to live?#ieltsspeakingsampleB2
538
5 جمل

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

IELTS PrepHigh School StudentsUniversity Students
Neuroscience of TimeC1
40
6 جمل

Neuroscience of Time

University StudentsWorking Adults
IELTS Speaking Part 2: A Place That Changed My PerspectiveC1
71
24 جمل

IELTS Speaking Part 2: A Place That Changed My Perspective

American AccentBritish AccentIELTS PrepUniversity StudentsWorking Adults
You Need to Believe in Yourself I Robert GreeneB2
180
12 جمل

You Need to Believe in Yourself I Robert Greene

Business EnglishUniversity StudentsWorking Adults
Can Earth Run Out of Water?C1
115
16 جمل

Can Earth Run Out of Water?

IELTS PrepTOEFL PrepUniversity Students
How Cell Phones Impact Our RelationshipsB2
230
24 جمل

How Cell Phones Impact Our Relationships

Business EnglishDaily ConversationUniversity Students
if you wear nice clothes #denzelwashington #motiationalspeech #motivationB1
670
9 جمل

if you wear nice clothes #denzelwashington #motiationalspeech #motivation

Business EnglishUniversity StudentsWorking Adults
never ever put me in a position where I have to show you how ruthless I can bebe #denzelwashingtonB2
419
11 جمل

never ever put me in a position where I have to show you how ruthless I can bebe #denzelwashington

Business EnglishDaily ConversationUniversity Students
Psychology of Intelligence: Learn Faster Than Everyone Around YouC1
83
50 جمل

Psychology of Intelligence: Learn Faster Than Everyone Around You

Business EnglishUniversity StudentsWorking Adults
Weekly Team Meeting: Project Status UpdateB2
175
28 جمل

Weekly Team Meeting: Project Status Update

American AccentBusiness EnglishWorking Adults

المفردات وملاحظات التحدث لهذا الدرس

هذا الدرس في المحادثة مبني على الفيديو “PostgreSQL in 100 Seconds”. أكثر الكلمات تكرارًا في الفيديو: database, table, type, object, relational. يحتوي هذا الفيديو على 28 جملة و539 كلمة للتدرب على الترديد. مدة الكلام 2:36. يتكلم المتحدث بسرعة، نحو 207 كلمة في الدقيقة، لذا ستسمع كثيرًا من وصل الكلمات واختزال الأصوات. 75% فقط من الكلمات ضمن أكثر 3,000 كلمة شيوعًا في الإنجليزية، فالمفردات صعبة نسبيًا.

أهم المفردات في هذا الفيديو

15 كلمة من الفيديو تستحق التعلّم، مع النطق والمعنى:

الكلمةالنطقالمعنى
database اسم/ˈdeɪtəˌbeɪs/قَاعِدَة بَيَانَات
custom اسم/ˈkʌstəm/عَادَة, عُرْف
query اسم/ˈkwɪɹ.i/اِسْتِعْلام
transaction اسم/tɹænˈzækʃən/صَفْقَة
cloud اسم/ˈklaʊ̯d/سَحَاب, غَيْم
bracket اسم/ˈbɹækɪt/قَوْس
programmer اسم/ˈpɹoʊɡɹæmɚ/مُبَرْمِج, مُبَرْمِجَة
compare فعل/kəmˈpɛɚ/قَارَنَ
select فعل/sɪˈlɛkt/اِخْتَارَ
procedure اسم/pɹəˈsiː.d͡ʒə/اِجْرَاء
designer اسم/dɪˈzaɪnɚ/مُصَمِّم, مُصَمِّمَة
string اسم/stɹɪŋ/وَتَر
connect فعل/kəˈnɛkt/رَبَطَ
jam اسم/ˈd͡ʒæm/مُرَبًّى
install فعل/ɪnˈstɔl/رَكَّبَ

نطق يحتاج إلى انتباه

  • أصوات “sh” و“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/
  • الكلمات الطويلة — انتبه لموضع النبر: 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/

أصوات يجدها متحدثو العربية صعبة:

  • /p/ — ليس /b/: انطقه مع نفخة هواء: programmer /ˈpɹoʊɡɹæmɚ/, compare /kəmˈpɛɚ/, procedure /pɹəˈsiː.d͡ʒə/, developer /dɪˈvɛləpɚ/, sponsor /ˈspɒn.səː/
  • تتابع الصوامت — لا تضف حركة بينها: query /ˈkwɪɹ.i/, extension /ɪkˈstɛnʃən/, transaction /tɹænˈzækʃən/, cloud /ˈklaʊ̯d/, bracket /ˈbɹækɪt/

كيف تتدرب بهذا الفيديو

  1. استمع إلى الفيديو كاملًا مرة واحدة دون أن تتكلم، ودوّن الكلمات التي لا تعرفها.
  2. ابدأ بسرعة 0.75×، وردّد جملة جملة، ثم عُد إلى السرعة العادية عندما يصبح الأمر سهلًا.
  3. سجّل صوتك وقارنه بالأصل، مع الانتباه إلى كلمات مثل database, custom, query.

ما هي تقنية التظليل الصوتي؟

التظليل الصوتي (Shadowing) تقنية تعلم لغة مدعومة علمياً، طُورت أصلاً لتدريب المترجمين الفوريين المحترفين. الطريقة بسيطة لكنها قوية: تستمع لصوت إنجليزي أصلي وتكرره فوراً بصوت عالٍ — كظل يتبع المتحدث بتأخير 1-2 ثانية. تُظهر الأبحاث تحسناً كبيراً في دقة النطق والتنغيم والإيقاع وربط الأصوات والاستماع والطلاقة.

تقنية الشادوينغ: اقرأ الدليل الكامل خطوة بخطوة →