Shadowing Practice: Installing MySQL and Creating Databases | MySQL for Beginners - Learn English Speaking with Video
בחר מצב תרגול
כל מצב פותח חדר תרגול במסך מלא.
159 משפטים
אם המשפטים קצרים או ארוכים מדי, לחץ על ערוך כדי להתאים אותם.
1
What's going on everybody?
2
Today we are going to be starting our MySQL tutorial series.
3
Now the entire MySQL series will be broken up into three smaller series.
4
We'll have our beginner, our intermediate, and our advanced.
5
This lesson is the very first lesson in the beginner series where we're going to walk through all of the beginner or the basics of MySQL.
6
Today we're going to be setting everything up so we'll be installing MySQL and then creating our database that we'll use to actually learn MySQL.
7
Now, before we get started, I wanted to let you know that I created three full MySQL courses over on analystbuilder.com.
8
I built a crash course for MySQL for people who are gonna be interviewing or taking technical interviews.
9
I also created a full MySQL course that's gonna cover everything from the basics all the way to the intermediate level.
10
And then lastly, I created an advanced course that's gonna teach you a lot of the more advanced things that an analyst would typically use.
11
Those courses are gonna go really in-depth and they're gonna have a lot of practice questions along the way.
12
and we'll also have full guided projects in there as well.
13
I'll have links in the description to all of those courses if you want to check those out.
14
Now, without further ado, let's jump on my screen and install MySQL and create our database.
15
All right, so let's get started by downloading MySQL.
16
We're going to come right over here to dev.mysql.com forward slash downloads forward slash installer and I will have that link in the description so you don't have to write all that out, but you should be seeing this page right here.
17
Now, we have to select an operating system.
18
I'm using a Windows machine.
19
And if you aren't, if you're using Linux or Mac or something else, it should populate it for you.
20
But if it doesn't, just select this dropdown and select your operating system.
21
Next, we have two different downloads.
22
We can install the MySQL installer community or MySQL installer web community.
23
This one is very small, but then you actually do have to download the installer.
24
It just gets it from the web.
25
This one, I'm going to download the actual installer.
26
It's larger, but this is the one I'm going to do.
27
I'm going to go ahead and select download.
28
It's going to ask me if I want to log in or create an account, and I don't.
29
I'm going to say, no, thanks.
30
Just start my download.
31
I'm going to save this in this desktop folder.
32
It doesn't really matter where you save it.
33
We're going to save that, and it's going to download.
34
It should be done in just a few seconds.
35
I'm going to go ahead and click on it, and it's going to open it up when it's finished, and we should get the interface or the UI for the actual installation for MySQL.
36
So here is the MySQL installer, and first thing we need to do is choose a setup type.
37
Now we're going to keep the developer default unless you really know what you're doing and you can select the server only, the client only, full, which is literally everything MySQL has to offer, or custom.
38
So we're going to keep this developer default just installing the things that we kind of need.
39
So let's go ahead and select next.
40
And for whatever reason on my computer, it's saying this path already exists.
41
You probably won't get that,
42
but I'm just going to go ahead and select next and then I'll select yes it keeps doing that I can't explain why but it keeps doing that for
43
me even though I've deleted it from my computer completely but it just remembers it somewhere in its memory now the next thing we need is to
44
check requirements now i just have this one it says i need to download this visual studio i'm not going to do
45
that but on your screen you may have multiple multiple requirements typically you're looking at something like this microsoft visual c plus plus
46
redistributable package what you need to do is download this all you have to do is click download once you download and install that on your computer and then
47
we go back all those should be gone that's the one that i see the most when i'm actually working with these requirements i had to install it myself when i got
48
this new laptop so go ahead and install that if you need to but if yours looks like mine we don't need this visual studio for what we're going to do we
49
want to go ahead and select next it is giving us a prompt that we haven't satisfied all the requirements but that's okay we're going to go ahead and
50
select yes as well now we're ready to install all of these things these are all things that mysql wants you to install the most important are the server and
51
the workbench but it does not hurt to have all these other things as well some of these connectors are also important so we're going to go ahead and execute
52
this will take just a few minutes i'll skip ahead when they're all done but this should take just a few minutes and then we'll
53
continue on installing mysql so everything just completed and now we're going to select next and now we need to actually configure our product now really the only one that we actually need to configure is the server the The router says we need to configure it,
54
and the samples and examples say we need to configure it as well, but really it's just the server.
55
Let's go ahead and select Next.
56
Now we're not going to change anything for this type and networking, unless you know what you're doing with the port, the X protocol port.
57
We're not going to change any of this.
58
We'll go ahead and select Next.
59
Next thing we need to do is select an authentication method.
60
I'm going to be using a password.
61
I'm not going to be using the legacy authentication method, so I'm just going to go ahead and create a password.
62
now for you and I keep getting this error and I can't explain why right here for you you should be creating a password at the bottom it's
63
remembering my password somehow and I really can't explain it but I'm going to create my password or check my password this is one that I
64
already created before I deleted it off my computer but it's still there so it's saying my password is still good but if you need to you should be
65
entering a password and then confirming your password and saving it and then you should also be checking it as well and then we're going to configure this as a MySQL server as a Windows service.
66
I'm going to keep that checked and we're going to start the MySQL server at system startup.
67
I like that automatically being there.
68
I don't want to mess with that.
69
So I'm going to keep it as it has it.
70
We're going to go ahead and select next.
71
And the last thing we do is just need to execute this and then everything we put in there is going to actually go.
72
So let's run this and execute it.
73
And that just finished.
74
So let's go ahead and select finish.
75
Now it says configuration complete for the server,
76
but we also need to configure these other two let's take a look at these really quickly we're not going to do anything on this it even
77
says we really don't need to do this we just need to click finish and configuration not needed next we'll do samples and
78
examples and we can input our password and all this is really going to do is put in some sample databases for us in our database, which if you want, you definitely can do that.
79
I just connected, and that worked.
80
I'm going to hit next and execute.
81
And it's basically just going to put in a database or two, some sample ones for you to look at.
82
And the configuration is complete.
83
You don't have to do that one, but we'll see that in just a second.
84
We're going to select next.
85
and now the installation is completely done and we can start my SQL workbench after setup and start my SQL shell after setup.
86
Now I'm not going to do the shell so I'm going to actually uncheck that and we're going to select finish.
87
Now my SQL just popped up for us and this is exactly what you should be seeing.
88
Now there's a lot of things in my SQL to learn and know how to do.
89
We're not going to be taking a look at all of that stuff today but in future lessons we'll walk through a lot of these different things that kind of correlate with different lessons or things that we're working on in MySQL.
90
The first thing that we're going to click on is right over here.
91
This is our local instance.
92
This is local to just our machine.
93
It's not a connection to, you know, some other database on the cloud or anything like that.
94
It's just our local instance.
95
We're going to go ahead and click on this.
96
So this is what you should be seeing right here.
97
This is where we're going to actually write all of our SQL code, and I'll show you all this in just a second, but this is where we can actually create our database, and our database is going to go right over here on this left-hand side.
98
The Silica one is actually a sample database.
99
It has a bunch of tables and views to procedures functions.
100
It has all these things in here if you want to go ahead and mess around with that.
101
What we're about to do is create our own database that we're going to be using throughout this entire series, both the beginner, intermediate, and advanced.
102
We'll use a lot of this.
103
And sometimes we'll import some other ones for different use cases, but this will serve for most of what we're trying to do throughout this entire series.
104
Now, what I'm going to do is I'm going to go ahead and I'm going to say, open a SQL script file in a new query tab.
105
And right here, it opened up to a folder that I already created this MySQL beginner series folder.
106
Within it, we have this right here, the parks and rec create underscore DB.
107
Now, in order to get this, you just have to go to the GitHub and download this file.
108
That's all you have to do.
109
We're then going to open this file.
110
So let's click on it.
111
We're going to say open.
112
And what you're now seeing is basically the query editor.
113
This is where you can write your code.
114
Now, we're not importing a database.
115
We're actually creating it by running code.
116
Now, because this is the first lesson in the beginner series, I'm going to assume that you don't know a ton about MySQL.
117
Really, all this is doing is creating the database name, and then we're inserting a few tables into that database, and then we're inserting data into those tables.
118
So this is all of our data that will go into these tables that we create.
119
We only have one, two, three different tables that we're going to be using.
120
So all you have to do to run this is click this lightning button right up here.
121
We're gonna go ahead and execute this.
122
If we come down to the bottom and we pull this up, this is our output.
123
This says six rows affected.
124
And we have a bunch of other things like create table, create table, insert, insert, create table, insert into.
125
These things are all working perfectly.
126
So now if we go ahead and click refresh in our schemas with this refresh button right here, this parks and recreation table is populated.
127
If we go under the tables, we see all of these things.
128
So now that we've actually created our database and our tables, that's really all we were trying to do in this lesson, but I just want to open up a table really quickly, show you what it looks like, show you how we can run code, and then in the next lesson, we'll start actually learning how to query this data.
129
So let's go up to employee demographics.
130
We're going to right click and select rows limit 1000.
131
This is going to open up a new window right up here, and it's going to say select everything from this database dot this table, employee demographics, and it ends with a semicolon.
132
Now right down here, we have this output window.
133
This is the actual data that sits in our table.
134
We have columns right here.
135
So employee ID, first name, last name, age, gender, and birth date.
136
And then here are all of our employees on each row.
137
So these are all separate rows.
138
We have Leslie Knope, Tom Haverford, and it goes on and on.
139
So this is all of our data.
140
The most important things to know when we're actually working with this, and I'm going to zoom in is if we hover over this query right here and we run it, we can select this execute, which is this lightning bolt with this I.
141
We're going to execute this and it's going to run this because we're highlighted over it.
142
Now, if we have two queries, let's say this one right here, but let's change it to employee underscore salary.
143
We'll do underscore salary.
144
Let's say we want to query this table.
145
So now if we highlight over this and we go up and select the lightning bolt with the eye.
146
Now we're looking at a different table.
147
But if we select, even if we're hovering over this, if we select this button, we're going to execute everything in this editor window.
148
So let's run this.
149
And now you can see at the bottom, we have two outputs, the employee demographics and the employee salary.
150
So this button is going to run everything in this editor window.
151
Whereas if we select this lightning bolt with the eye, we're doing everything that's just under where we have the cursor where we have it highlighted.
152
The very last thing that I want to mention is that right over here, you may have this up and you probably don't want that.
153
We're not going to do any SQL additions in the series.
154
You can get rid of that by clicking this button right here.
155
So starting in the next lesson, we'll have everything ready to go and we will start learning the basics of MySQL.
156
I hope you're able to follow along, get everything set up how we have it on the screen.
157
I am super excited about this series.
158
I just, I love SQL.
159
So I'm really, really, really excited to get started this with you guys i will see you guys in the next lesson
הורד אפליקציה
כל מה שאתה צריך כדי לדבר בשטף
הגיית AIציון לכל משפט
תרגול IPAשלוט בכל צליל
אוצר מיליםבנה את מאגר המילים שלך
משחק אוצר מיליםלמד תוך כדי משחק
אותו ערוץ
B24
What are KPIs and Metrics? | Data Fundamental for Beginners
Daily ConversationUniversity StudentsWorking Adults
B21
FREE Data Analyst Bootcamp!!
Daily ConversationUniversity Students
B21
Solving Easy SQL Interview Questions on Analyst Builder
Interview EnglishUniversity StudentsWorking Adults
C1Database vs Data Warehouse vs Data Lake | What is the Difference?
Business EnglishUniversity StudentsWorking Adults
FOR YOU
המלץ על סרטון
B23
344 משפטים
Meet New People! Self Introduction in English: Business English at Work
Business EnglishInterview EnglishUniversity Students
C12
129 משפטים
How to Become a Great Software Developer — Best Advice from Top-Notch Engineers
Business EnglishInterview EnglishUniversity Students
B22
210 משפטים
Top 10 Linux Job Interview Questions
Interview EnglishWorking Adults
C15
370 משפטים
FullStack Interview Questions (Junior & Mid)
Business EnglishInterview EnglishUniversity Students
C24
160 משפטים
Oracle database architecture explanation in details
Interview EnglishWorking Adults
B25
218 משפטים
My Entire Job Search Process: Software Engineer Resume & Interviews
Business EnglishInterview EnglishUniversity Students
B22
187 משפטים
How to ACTUALLY Get a DevOps Job in 2026
Interview EnglishUniversity StudentsWorking Adults
C13
101 משפטים
3.3k
Business EnglishInterview EnglishUniversity Students
C13
195 משפטים
Backend Interview Questions (Junior & Mid)
Interview EnglishUniversity StudentsWorking Adults
C112
113 משפטים
How to Interview for a Job in American English, part 1/5
American AccentInterview EnglishWorking Adults
C1217 משפטים
10 Data Analyst Interview Questions and Answers - Senior Data Analyst Explains
Interview EnglishUniversity StudentsWorking Adults
אוצר מילים והערות הגייה לשיעור הזה
שיעור הדיבור הזה ברמה C1 מבוסס על הסרטון “Installing MySQL and Creating Databases”. המילים שחוזרות הכי הרבה: select, mysql, ahead, table, database. בסרטון הזה יש 159 משפטים ו-2571 מילים לתרגול Shadowing. הדיבור נמשך 11:51. הדובר מדבר מהר, כ-217 מילים בדקה, אז צפו לצלילים מחוברים ומקוצרים. 85% מהמילים נמצאות בין 3,000 המילים הנפוצות ביותר באנגלית; כדאי ללמוד את השאר לפני שמתחילים.
אוצר מילים מרכזי בסרטון הזה
13 המילים המתקדמות ביותר בסרטון, עם ההגייה והמשמעות שלהן:
| מילה | הגייה | משמעות |
|---|---|---|
| password שם עצם | /ˈpæs.wɜɹd/ | סִיסְמָה |
| execute פועל | /ˈɛksɪˌkjuːt/ | להוציא להרוג |
| beginner שם עצם | /bəˈɡɪnɚ/ | מַתְחִיל, טִירוֹן |
| insert פועל | /ɪnˈsɝt/ | לְהַכְנִיס |
| folder שם עצם | /ˈfoʊldɚ/ | תִּיקִיָּה |
| demographic שם תואר | /ˌdɛm.əˈɡɹæf.ɪk/ | דֵּמוֹגְרָפִי |
| bolt שם עצם | /boʊlt/ | בורג \ בֹּרֶג |
| connector שם עצם | /kəˈnɛktɚ/ | מחבר |
| cursor שם עצם | /ˈkɜːsə/ | סמן |
| router שם עצם | /ˈɹaʊ.tɚ/ | נַתָּב |
| semicolon שם עצם | /ˈsɛmikoʊlən/ | נקודה ופסיק \ נְקֻדָּה וּפְסִיק |
| startup שם עצם | /ˈstɑɹtˌʌp/ | סטארטאפ, חברת סטארטאפ |
| recreation שם עצם | /ɹiːkɹiˈeɪʃən/ | נופש, פנאי |
Phrasal verbs שתשמעו
| מילה | משמעות |
|---|---|
| go up פועל | עָלָה |
משפטים שכדאי לחזור עליהם
משפטים קצרים ושלמים מהסרטון שאפשר להשתמש בהם בשיחה יומיומית:
- We'll have our beginner, our intermediate, and our advanced.
- This one, I'm going to download the actual installer.
- I'm going to go ahead and select download.
- I'm going to say, no, thanks.
- I'm going to save this in this desktop folder.
דקדוק בסרטון הזה
המבנים שהדובר משתמש בהם הכי הרבה, עם המילים המדויקות מהסרטון:
| מבנה | בסרטון |
|---|---|
| סביל (Passive voice) be + past participle — הדגש הוא על מה שקורה, לא על מי שעושה את הפעולה | will be broken · should be done · is put |
| הווה מושלם (Present perfect) have/has + past participle — פעולה שקרתה בעבר ועדיין יש לה חשיבות או השפעה עכשיו | I've deleted · haven't satisfied · we've actually created |
| משפטי זיקה (Relative clauses) who / which + clause — מידע נוסף על אדם או דבר | people who are · full, which is · execute, which is |
הגייה ששווה לשים לב אליה
הדובר משתמש ב-119 קיצורים וצורות מקוצרות, כמו we're, I'm, we'll. אמרו אותם בצורה הקצרה, כפי שאתם שומעים אותם.
- הצלילים של “sh” ו-“zh”: configuration /kənˌfɪɡ.əˈɹeɪ̯.ʃən/, authentication /ɔːˌθɛntɪˈkeɪʃn̩/, refresh /ɹɪˈfɹɛʃ/, recreation /ɹiːkɹiˈeɪʃən/
- מילים ארוכות — שימו לב להטעמה: demographic /ˌdɛm.əˈɡɹæf.ɪk/, configuration /kənˌfɪɡ.əˈɹeɪ̯.ʃən/, intermediate /ɪn.tə(ɹ)ˈmi.di.ət/, authentication /ɔːˌθɛntɪˈkeɪʃn̩/, semicolon /ˈsɛmikoʊlən/
צלילים שדוברי עברית מתקשים בהם:
- /w/ — שפתיים מעוגלות, לא /v/: password /ˈpæs.wɜɹd/, query /ˈkwɪɹ.i/, workbench /ˈwɝk.bɛnt͡ʃ/
- /æ/ — פתוח יותר מה-“אֶ” העברית, לא כמו “a” ב-“cup”: password /ˈpæs.wɜɹd/, demographic /ˌdɛm.əˈɡɹæf.ɪk/, lastly /ˈlæstli/, satisfy /ˈsætɪsfaɪ/, analyst /ˈænəlɪst/
- /r/ — הלשון לא נוגעת בשום מקום, לא ה-“ר” הגרונית: password /ˈpæs.wɜɹd/, configure /kənˈfɪɡə(ɹ)/, query /ˈkwɪɹ.i/, underscore /ˈʌn.dɚˌskoɹ/, demographic /ˌdɛm.əˈɡɹæf.ɪk/
איך לתרגל עם הסרטון הזה
- הקשיבו לכל הסרטון פעם אחת בלי לדבר, ורשמו את המילים שאתם לא מכירים.
- התחילו במהירות 0.75×, תרגלו Shadowing משפט אחר משפט, וחזרו למהירות רגילה כשזה מרגיש קל.
- הקליטו את עצמכם והשוו למקור, תוך תשומת לב למילים כמו password, execute, beginner.
מהי טכניקת השאדואינג?
שאדואינג היא טכניקת למידת שפה מבוססת מדע שפותחה במקור להכשרת מתורגמנים מקצועיים ופופולרית על ידי הפוליגלוט ד"ר אלכסנדר ארגואלס. השיטה פשוטה אך עוצמתית: אתה מקשיב לאודיו באנגלית ילידית וחוזר עליו בקול רם מיד — כמו צל העוקב אחרי הדובר עם עיכוב של 1–2 שניות בלבד. בניגוד להאזנה פסיבית או תרגילי דקדוק, שאדואינג מכריח את המוח והשרירים בפה לעבד ולשחזר דפוסי דיבור אמיתיים בו זמנית. מחקרים מראים שזה משפר משמעותית את דיוק ההגייה, האינטונציה, הקצב, הדיבור המחובר, הבנת השמיעה ושטף הדיבור — מה שהופך אותו לאחת השיטות היעילות ביותר להכנה לIELTS Speaking ולתקשורת באנגלית בעולם האמיתי.