Download "05 Ejemplo 3 Funciones de base de datos"

Please wait. We're preparing links for easy ad-free video watching and downloading.

Previous video: Моя кухня Таня Next video: DCOLOR MUSIC - Видео

DCOLOR MUSIC - Видео

DCOLOR MUSIC - Видео

Channel: DCOLOR MUSIC

Моя кухня Таня

Моя кухня Таня

Channel: Моя кухня Таня

"Empathy" Old School Freestyle Type Beat | Underground Hip Hop Rap Instrumental | Antidote Beats

"Empathy" Old School Freestyle Type Beat | Underground Hip Hop Rap Instrumental | Antidote Beats

Channel: Antidote Beats

La vereda de la puerta de atras extremoduro

La vereda de la puerta de atras extremoduro

Channel: wiceone

05

Ejemplo

3

Funciones

de

base

de

datos

00:00:00

Hello, in this video we are going to see the use of

00:00:03

the database functions. We have

00:00:05

a list with the sales of our

00:00:08

commercials, products, channel and

00:00:10

amount, and we want to ask several

00:00:14

questions to the database, content of

00:00:16

each commercial, how much each

00:00:18

commercial came for. internet etc. and for

00:00:20

that we are going to use the database functions

00:00:22

because first of all I want to know

00:00:25

how much I have sold this commercial

00:00:27

so I put this cell and write

00:00:30

equal sum bird

00:00:33

I open parentheses and give the assistant

00:00:37

for the function the base functions of

00:00:39

data, whatever it is, at the

00:00:41

same time, whatever it is,

00:00:44

they always have the same structure. You have to

00:00:46

tell them what the database is. In

00:00:48

this case, I indicate the entire range.

00:00:57

Then they ask me what is the name

00:00:59

of the field that I want to add as I want.

00:01:02

add the sales, I can tell you or

00:01:05

write sales, which

00:01:07

is never really advisable because as soon as you

00:01:10

make a mistake, I put a space, I don't put the

00:01:11

links on the space, I can put the name of the

00:01:14

field or it

00:01:16

refers to the cells where they are in

00:01:18

the field. by the g3 or see that the

00:01:22

sales column 1 2 3 4 5 and 6

00:01:26

is the sixth column and here the

00:01:29

criteria must be in

00:01:33

another range of cells and must

00:01:36

contain at least the name of one

00:01:37

column that you see that the commercial and below

00:01:40

some data if there is more than one column and

00:01:43

the data is in the same row,

00:01:46

the two simultaneous conditions must be met

00:01:47

and if they are in two

00:01:50

different rows they must be met

00:01:51

alternatively kas and xaki in criteria

00:01:53

I choose this and accept and message that the

00:01:57

sum of Javier's sales is 2,402

00:02:01

euros

00:02:02

I want to know now the sums of

00:02:04

Javier's sales online, that is,

00:02:07

not Javier's entire mind, but only

00:02:10

Javier's sales that have been

00:02:12

online, that is, they must be fulfilled

00:02:14

the two conditions simultaneously and that is why

00:02:17

they are in the same row because

00:02:20

we would do equal equal to b of sum I can

00:02:25

launch the function b here by I'm going

00:02:27

to formulas insert the function and within

00:02:31

the database category

00:02:34

go from zuma

00:02:37

velez sum base of data the image before

00:02:44

sir the range the name of the field that

00:02:47

I want to add 1 2 3 4 5 and 6

00:02:50

6

00:02:52

and the criteria that it has to meet well

00:02:55

this here I am

00:02:57

going to accept and it tells me that the

00:02:59

sales are 714 and 41 euros

00:03:02

yes I Change the commercial here and

00:03:05

write, for example, Raquel.

00:03:09

You see that I would change

00:03:12

Raquel's sales on the internet. Well, here to

00:03:15

press the Javier.

00:03:19

You see that it does not discriminate between uppercase and

00:03:21

lowercase letters. You can put it in

00:03:22

any way.

00:03:23

I want to know now the sales between

00:03:27

March 15, but on January 15 and

00:03:30

May 15, well now it doesn't matter to

00:03:33

simplify the data to this range

00:03:36

here I'm going to call it

00:03:39

data for phone data

00:03:43

accessible data data

00:03:45

clicked formulas

00:03:46

assign name and I call it data

00:03:50

and accept I

00:03:52

have also put here data and give the

00:03:55

lens

00:03:56

if you see now without minimizing the zoom

00:04:00

bay let me show you what the range is

00:04:02

called data

00:04:08

well we are here I write the same

00:04:12

instead of sum as before apro

00:04:15

parentheses

00:04:18

database data it is not necessary

00:04:21

to write it all name of the field and

00:04:23

wants to add 1 2 3 4 5 and 6

00:04:27

click to change the cells and the

00:04:30

criteria he pointed out

00:04:33

the criteria and accept we

00:04:36

continue how much Javier's sales add up

00:04:38

gr that you see that Raquel and

00:04:41

Javier are in

00:04:44

different rows which will make me

00:04:46

add up all of Raquel's sales and all of

00:04:48

Javier's sales and if I put it I

00:04:50

would have put here commercial and Javier,

00:04:53

well it would be practically impossible for me

00:04:56

it would be zero because there won't be any

00:04:57

I will have commercials that are Raquel and the

00:05:00

commercial is Javier you see that there is

00:05:03

a formula here It may be that we will write

00:05:05

abc equal to sum parentheses on the

00:05:13

data drop-down which was how we had named the

00:05:15

range of the field to the database

00:05:18

name of the field 6 which was sales and the

00:05:22

criteria indicate both at the same time

00:05:26

and accept

00:05:29

you see now the following is Very similar

00:05:32

to the previous one, I want to count how many

00:05:36

sales there are

00:05:38

after 30 of 6 that are not

00:05:41

collected. You see that since the conditions

00:05:44

are in the same row, they

00:05:47

must be given because at the same time I go to

00:05:51

formulas, insert the function within the

00:05:55

category. of database the child can

00:05:57

count

00:05:59

database data field name

00:06:03

how I want to count and I can count the

00:06:06

sales by dates by collected whatever I

00:06:09

want I click on dates and criteria all of

00:06:12

these you

00:06:19

see seven operations and I want to count

00:06:23

now all the sales of I want to add

00:06:27

the Sales of the commercial Javier or of the

00:06:30

finance course, since they are not on the same

00:06:34

line, they are alternative conditions because

00:06:37

we continue the same formulas, insert the

00:06:40

function

00:06:41

within the database category, the

00:06:43

son of the

00:06:49

database sum, I write data

00:06:52

in the field name, I write sales, I

00:06:56

leave here or indicated

00:06:59

and criteria

00:07:01

this here

00:07:05

and accept

00:07:07

well, thank you very much now what you

00:07:09

have to try is to do it in this

00:07:12

cell here

Description:

On this page you can download the media «05 Ejemplo 3 Funciones de base de datos» highest quality possible WITHOUT any restrictions on the number of downloads or download speed.

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 "05 Ejemplo 3 Funciones de base de datos" 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 "05 Ejemplo 3 Funciones de base de datos" 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 "05 Ejemplo 3 Funciones de base de datos" 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 "05 Ejemplo 3 Funciones de base de datos" 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 "05 Ejemplo 3 Funciones de base de datos"?

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 "05 Ejemplo 3 Funciones de base de datos"?

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.