Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
0
1
00:00:01,792 --> 00:00:02,560
Hi everyone
1
2
00:00:03,072 --> 00:00:04,864
Welcome to your first exercise
2
3
00:00:05,888 --> 00:00:08,192
As I told you in the introduction to this course
3
4
00:00:08,704 --> 00:00:11,008
With every important topic that we cover
4
5
00:00:11,264 --> 00:00:12,800
We'll provide you with an exercise
5
6
00:00:13,312 --> 00:00:17,408
It is important that you test your skills and are sure that you are ready for the
6
7
00:00:17,664 --> 00:00:18,688
Next lecture
7
8
00:00:19,712 --> 00:00:21,504
So, here's how exercises will go
8
9
00:00:21,760 --> 00:00:23,808
In every exercise you will have one or two
9
10
00:00:24,064 --> 00:00:25,344
Activities to perform
10
11
00:00:25,600 --> 00:00:26,624
Try to do it yourself
11
12
00:00:27,136 --> 00:00:28,160
If you not able to do it
12
13
00:00:28,416 --> 00:00:30,464
Refer the attached presentation
13
14
00:00:30,720 --> 00:00:34,304
in the lecture if you are still are unable to do it go through the lecture again
14
15
00:00:34,560 --> 00:00:40,704
And even after that if you are not able to do it please do post your questions in the discussion Forum and
15
16
00:00:40,960 --> 00:00:41,984
We will be happy to help you
16
17
00:00:42,496 --> 00:00:43,776
In the first exercise
17
18
00:00:44,288 --> 00:00:47,104
You have to create a database called classroom
18
19
00:00:47,616 --> 00:00:49,152
Once you have created this classroom
19
20
00:00:49,408 --> 00:00:51,968
Open the query tool and start writing the query
20
21
00:00:52,480 --> 00:00:56,320
Using the query you have to create a table named science class
21
22
00:00:56,576 --> 00:00:57,600
In this database
22
23
00:00:58,112 --> 00:01:01,184
And this science class table should have three columns
23
24
00:01:01,440 --> 00:01:02,720
First is enrollment number
24
25
00:01:03,232 --> 00:01:05,024
Which should be an integer data type
25
26
00:01:06,048 --> 00:01:07,328
Second his name
26
27
00:01:07,840 --> 00:01:09,120
Which is a variable character
27
28
00:01:09,376 --> 00:01:10,144
and third is
28
29
00:01:10,912 --> 00:01:13,216
Science marks which is also integer
29
30
00:01:13,728 --> 00:01:14,496
Take your time
30
31
00:01:14,752 --> 00:01:15,520
Try to do this
31
32
00:01:15,776 --> 00:01:18,080
If you are able to do this you ready for the next lecture
32
33
00:01:18,592 --> 00:01:19,872
If you are not able to do this
33
34
00:01:20,128 --> 00:01:23,712
revisit the videos which cover creation of database and creation of table
2705
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.
Afrikaans
Akan
Albanian
Amharic
Arabic
Armenian
Azerbaijani
Basque
Belarusian
Bemba
Bengali
Bihari
Bosnian
Breton
Bulgarian
Cambodian
Catalan
Cebuano
Cherokee
Chichewa
Chinese (Simplified)
Chinese (Traditional)
Corsican
Croatian
Czech
Danish
Dutch
English
Esperanto
Estonian
Faroese
Finnish
Galician
Georgian
German
Greek
Guarani
Haitian Creole
Hausa
Hawaiian
Hebrew
Hmong
Hungarian
Icelandic
Indonesian
Irish
Italian
Japanese
Kazakh
Kinyarwanda
Kirundi
Kongo
Korean
Krio (Sierra Leone)
Kurdish
Kyrgyz
Laothian
Latin
Latvian
Lithuanian
Luganda
Luo
Luxembourgish
Macedonian
Malagasy
Malay
Maltese
Maori
Mauritian Creole
Moldavian
Mongolian
Myanmar (Burmese)
Montenegrin
Nepali
Norwegian
Pashto
Persian
Polish
Portuguese (Brazil)
Portuguese (Portugal)
Quechua
Romanian
Romansh
Russian
Samoan
Scots Gaelic
Serbian
Sesotho
Setswana
Seychellois Creole
Shona
Sindhi
Sinhalese
Slovak
Slovenian
Somali
Spanish
Swedish
Tajik
Thai
Tigrinya
Tonga
Turkish
Turkmen
Ukrainian
Uzbek
Vietnamese
Welsh
Wolof