Download "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения"

"videoThumbnail Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения

Загрузка и установка СУБД ORACLE / Илья Хохлов

Загрузка и установка СУБД ORACLE / Илья Хохлов

Channel: Prime Soft

Поиск повторяющихся записей в запросах Access

Поиск повторяющихся записей в запросах Access

Channel: Уроки по Microsoft Access

Максимальная длина строки в запросе Access (функция Len)

Максимальная длина строки в запросе Access (функция Len)

Channel: Уроки по Microsoft Access

Превью канала "Уроки По Microsoft Access"

Превью канала "Уроки По Microsoft Access"

Channel: Уроки по Microsoft Access

Урок 18 | Воронка продаж | Бизнес-дашборды в Excel

Урок 18 | Воронка продаж | Бизнес-дашборды в Excel

Channel: Институт бизнес аналитики

5 вариантов дашборда по продажам

5 вариантов дашборда по продажам

Channel: Институт бизнес аналитики

Курс SQL Базы данных ORACLE. Илья Хохлов. Урок 1-1. Реляционные базы данных

Курс SQL Базы данных ORACLE. Илья Хохлов. Урок 1-1. Реляционные базы данных

Channel: Prime Soft

Готовая база данных Access Успеваемость студентов (3 из 4)

Готовая база данных Access Успеваемость студентов (3 из 4)

Channel: Уроки по Microsoft Access

SQL

Собеседование

База данных

Илья Хохлов

sql,

базыданных

собеседование

ильяхохлов

курсыпрайм

00:00:01

subscribers my name is or boilers today,

00:00:04

as promised, I have prepared a short

00:00:06

video on typical questions in

00:00:09

language interviews and put together if

00:00:12

you are preparing to change

00:00:13

jobs to get a new desired position of

00:00:15

the vacancy that you wanted to get, then

00:00:19

you are probably now preparing to

00:00:20

drag and your knowledge of language and

00:00:22

knowledge of language and knowledge of databases,

00:00:24

or if you consider yourself to be a claims guru,

00:00:28

then this role has cakes especially for

00:00:30

you, let’s try to solve different

00:00:32

cameras, interesting problems together, those

00:00:35

problems are approximately the same,

00:00:37

such problems are now offered at

00:00:39

interviews, of course not all these tasks are

00:00:41

not exactly these tasks, but approximately such

00:00:44

tasks are offered now at

00:00:45

interviews, approximately I chose 7

00:00:48

interesting tasks and included them in this

00:00:49

video, part 1 I’m going to do another

00:00:52

part on tasks and so part 1 let’s

00:00:55

solve the problem together to test

00:00:57

how good you are you know

00:00:59

the square so let's start the problem first

00:01:04

there are just tables taken out of

00:01:06

context here is a table 3 columns the first

00:01:09

column of the prostate cooking line numbers

00:01:11

the first column the line numbers and the second

00:01:12

column the name of musical

00:01:14

instruments and the number without the class of the

00:01:16

music instrument note that the eye

00:01:20

musical instruments are not filled in

00:01:21

every line is on lada there are empty

00:01:24

values, so there is a query, you need to say

00:01:28

what lines this query will return, and

00:01:31

so there is a table like this with musical

00:01:34

instruments and

00:01:36

with the class musical instruments,

00:01:38

figuratively speaking, both figurative class it does not

00:01:42

belong not as a musical instrument,

00:01:43

in fact, I am not a musician, but something like

00:01:45

this There is such a table, so

00:01:47

you need to tell me the lines with which

00:01:51

dress codes, figuratively speaking, what

00:01:53

lines from the table will be returned by this query,

00:01:56

look carefully at the request,

00:01:58

carefully look at the request, which

00:02:00

lines please tell me the lines with

00:02:02

which identifiers this query will return,

00:02:05

let’s think about it, I’ll give you a little

00:02:07

time, I can don’t say anything so that you

00:02:09

concentrate

00:02:12

select the lines from table 1 those lines

00:02:16

for in the head where in the column kvass this

00:02:21

value is not equal and that is, dick you not but

00:02:26

that is, you need to select from the pen in the image

00:02:29

the identifier of the lines where you

00:02:32

select and the identifier of those lines where in in the

00:02:36

column I am a class and this value is not equal, but

00:02:38

please tell me what lines

00:02:40

this request looks like, you

00:02:42

may have been waiting for a long time, maybe you are

00:02:44

ready to answer,

00:02:45

let's check how you answered, a

00:02:48

special one runs through this table and selects

00:02:52

these lines for you according to this condition,

00:02:53

select the despector and those lines from

00:02:55

tables where the class is not equal to this, but

00:02:59

Saturday and moves the variable across the table for

00:03:00

each line from my graph, the site is

00:03:03

not equal to from the textbook, and if it is not equal,

00:03:05

it means this. need on a tripod no one to

00:03:07

the line we need we need to show and

00:03:09

so they look at the first line the case of a

00:03:11

nickname there neo and there just the whole

00:03:13

Perovsky falls out it will not be the final

00:03:16

set takes free the second line the

00:03:19

case is not Caucasus this is not and there what

00:03:22

we have there on y of course

00:03:24

you basically know how to work if you compare on and if

00:03:27

on y is not equal to but

00:03:28

[music] the

00:03:30

result will also be no although it’s like

00:03:35

how emptiness can be equal to but

00:03:37

it’s not equal to but but no less equal to too but that

00:03:41

is, it turns out that the answer will be no

00:03:43

if you compare something as a basis then the answer

00:03:46

will always be no here we have but a direct

00:03:49

comparison is either equal or not equal to

00:03:51

you have nothing to compare you can’t you remember

00:03:53

this is the countries line also appears

00:03:58

3 line b is not equal and of course would not is

00:04:01

equal to a and so line 3 drum will end up

00:04:05

in our result set, that is, number

00:04:06

3 will fit

00:04:07

perfectly, number 4 will also be in currencies because

00:04:11

this comparison goes again, number

00:04:13

five will not work because here a and the

00:04:18

last penny on the price is equal to and

00:04:22

it turns out force k3 and . 6 I hope that

00:04:26

they answered the same way, if not, then it’s worth

00:04:29

repeating the system again, the work will be repeated

00:04:32

on you, so let’s take the next task,

00:04:34

task 2, here are the colors, we continue the topic,

00:04:37

they work again, the favorite topic of

00:04:41

employers or leading specialists

00:04:44

who will interview you, they

00:04:46

will test your knowledge with a new one, here I am I’m

00:04:49

almost sure that you will go to work and they

00:04:51

will ask you something about work again,

00:04:53

like to test it out, change it well, do you

00:04:56

understand that you cannot be compared,

00:04:58

so the second task is on the same topic,

00:05:00

select the correct statements, there are

00:05:03

several possible options, let’s

00:05:05

see, we have several

00:05:06

statements select from them true on y is

00:05:10

not equal to 1 so it is or not so will be true

00:05:14

or false result

00:05:15

yes or no but y is not equal to 1 yes or no the

00:05:20

second statement on the moon is equal to st yes

00:05:22

or no so it is or not so it may be

00:05:25

but equal on y can be speech

00:05:27

statement is true true or false

00:05:29

4 we don’t have on y and and from the statement

00:05:33

cash is on but what do you think which

00:05:37

of these statements are true let’s

00:05:40

pause for a while try to solve this

00:05:42

problem I’m marking the number in the bowl I’m here for

00:05:46

seconds let’s think please

00:05:48

which of these statements are true

00:05:50

tell me exactly the world statement

00:05:53

which in your opinion is true

00:05:56

think carefully like this ten

00:05:59

seconds have passed

00:06:01

in fact the only correct

00:06:03

statement is 5 that for us this is cash

00:06:06

cash in understanding this is emptiness this

00:06:09

uncertainty and this uncertainty

00:06:11

yes that is this as if it’s not only just that

00:06:13

it’s also uncertainty, but the first

00:06:17

statement is incorrect

00:06:19

because the uncertainty is not equal to

00:06:22

one, suddenly there’s just one there,

00:06:24

so we can’t say this, the

00:06:26

second statement is

00:06:29

gunner anal, that is, basically it’s

00:06:31

impossible to compare at all, not like ordinary

00:06:33

operations on the side and less more equal is

00:06:35

not equal they do not fit the answer will always

00:06:37

be a lie

00:06:39

based can only be worked with

00:06:41

is not or from from from notes that's why

00:06:45

5 the only

00:06:47

true statement is that uncertainty is

00:06:49

uncertainty to us ethanol

00:06:52

simply then this is simplicity that's why the

00:06:54

unit on the dimensional

00:06:56

statement here will be

00:06:59

a point 5

00:07:02

next task problem number 3, too,

00:07:05

we have a table of the second most table, you’re

00:07:07

not used to spoons, you already have a rough

00:07:09

idea,

00:07:10

you need to understand again which lines will be

00:07:13

selected in the next queries,

00:07:15

I hope that here too there are like operators, you

00:07:17

know, you know how to work with percentages,

00:07:20

please tell me which lines will be selected

00:07:22

for the data squad let's think

00:07:27

so you come to work come to

00:07:30

work for example to a position

00:07:33

leads to get to work for the

00:07:35

position of arches of the sheet or May Krasovsky

00:07:37

servers so they give you this

00:07:40

task like how will you answer which lines

00:07:43

will be selected you need to select those lines in the

00:07:45

table where

00:07:47

in graph we know the meaning starts with a

Description:

Типичные вопросы на собеседовании по языку SQL. Решаем задачи вместе. У Вас скоро собеседование по SQL или Вы считаете себя Гуру? Проверьте свои знания! Попытайтесь решить каверзные задачи ;) Моя книга самоучитель по SQL: https://play.google.com/store/books/details?id=MLSREAAAQBAJ

Preparing download options

Popular

HD video

Only sound

All

* — If the video is playing in a new tab, go to it, then right-click on the video and select "Save video as..."

** — Link intended for online playback in specialized players

Questions about downloading video

How can I download "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения" video?

http://unidownloader.com/ website is the best way to download a video or a separate audio track if you want to do without installing programs and extensions.
The UDL Helper extension is a convenient button that is seamlessly integrated into YouTube, Instagram and OK.ru sites for fast content download.
UDL Client program (for Windows) is the most powerful solution that supports more than 900 websites, social networks and video hosting sites, as well as any video quality that is available in the source.
UDL Lite is a really convenient way to access a website from your mobile device. With its help, you can easily download videos directly to your smartphone.

Which format of "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения" video should I choose?

The best quality formats are FullHD (1080p), 2K (1440p), 4K (2160p) and 8K (4320p). The higher the resolution of your screen, the higher the video quality should be. However, there are other factors to consider: download speed, amount of free space, and device performance during playback.

Why does my computer freeze when loading a "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения" video?

The browser/computer should not freeze completely! If this happens, please report it with a link to the video. Sometimes videos cannot be downloaded directly in a suitable format, so we have added the ability to convert the file to the desired format. In some cases, this process may actively use computer resources.

How can I download "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения" video to my phone?

You can download a video to your smartphone using the website or the PWA application UDL Lite. It is also possible to send a download link via QR code using the UDL Helper extension.

How can I download an audio track (music) to MP3 "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения"?

The most convenient way is to use the UDL Client program, which supports converting video to MP3 format. In some cases, MP3 can also be downloaded through the UDL Helper extension.

How can I save a frame from a video "Типичные вопросы на СОБЕСЕДОВАНИИ по SQL / Примеры задач и их решения"?

This feature is available in the UDL Helper extension. Make sure that "Show the video snapshot button" is checked in the settings. A camera icon should appear in the lower right corner of the player to the left of the "Settings" icon. When you click on it, the current frame from the video will be saved to your computer in JPEG format.

What's the price of all this stuff?

It costs nothing. Our services are absolutely free for all users. There are no PRO subscriptions, no restrictions on the number or maximum length of downloaded videos.