0:00
Oh yes, all alaikum warahmatullahi
0:10
4th meeting will discuss
0:14
advanced databases, yes, ongoing.
0:24
let's have several chapters that will be
0:33
discussed in semester 5, yes,
0:39
Hi, the first is chapter 1, we will
0:43
access multi-tables on
0:46
Hi, base th10 tables, Well, we have already
0:53
tried life, like join, join, like
0:56
that, Yes, what are the inner joins, please
1:01
join, Bro, join, which we
1:04
discussed yesterday, so your understanding of using multi-
1:09
tables, then the second is the chapter on
1:14
manipulating databases with
1:16
multi-level SQL, well, what is it like, later
1:20
we will try to get to know subqueries in
1:24
databases, then various software and
1:30
what are the errors in sugar? Well,
1:32
next, chapter 3 is implementing
1:35
Evil on the client-server database system,
1:38
here, the understanding
1:41
along with client-server, what is it, then ah,
1:44
centralized DBMS detector,
1:46
Hi, there is a client-server texture, then
1:50
what are the advantages and disadvantages of client-server, and creating and
1:53
running SQL through the client,
1:56
then there is getting to know the Dr
2:00
DBMS architecture, Well, we will know, understand
2:02
the meaning of RDBMS, what is it, then
2:06
architecture rdbms the difference between
2:10
rdbms and dbms what is it then the
2:13
advantages and disadvantages of rdbms
2:17
next in chapter 5 we make
2:20
armed on rdbms so we are more
2:22
familiar with the database application on
2:25
rdbms then understand the application My SQL
2:29
create a database on rdbms
2:32
next in chapter 6 we will examine the
2:37
storage structure on rdbms like
2:40
various storage models on DPR
2:43
dbms types of file storage
2:46
Valley comes Hello There is a
2:49
storage classification on rdbms as well as storing
2:52
data on phpmyadmin all of which will be
2:55
studied in semester 5
2:58
Hi and in the next semester semester 6
3:01
or difficult in class 3 later there are
3:06
three more chapters left Ah next on
3:12
this website to access multi tables
3:15
on participants Well there is esgaio this has
3:18
inner join but chowindra joint outer
3:21
full join yes these are the various then well
3:28
before starting must be like you
3:31
or continue do you still remember the
3:33
data material taught in class eleven Raya
3:37
first morning yes it's been a long time since I opened
3:39
bukabuku I haven't practiced anymore Eh how to
3:42
create a database how
3:46
Hi kecret database the database name is
3:50
alive the easiest yes then
3:52
how to create a table in how to display the
3:55
table maximum minimum aggregate value
4:01
yes Brother 5 then Alter is dizzy or not
4:07
well the book that if 11 please
4:11
continue so it is used just continue
4:16
Hi after that continue yes steel Buster
4:22
earlier class 12 this is millions of
4:24
Base TH in class eleven previously okay well the
4:28
definition of using multi tables
4:32
here there is a database management system
4:34
a satipo system that is able to process
4:39
or organize databases on a
4:41
computer well in a database
4:43
already So it's very natural so in one
4:46
database consists of several tables yes
4:52
other the relationship between tables is still not
4:55
four yes want to win there is money but
4:59
this is many-to-one and medical many it must be
5:06
e-learning as an example seen
5:08
in the conceptual data modeling image
5:13
Hi MB Shady Lady there how many
5:17
tables are there approximately but
5:23
yo yeah based on the image above try the
5:25
customer table is related Saturday
5:29
1 with the message table message table
5:33
look again related 11 with the
5:38
product table you ordered also the same
5:43
one-to-one relationship to the invoice table
5:48
Hi and so on try to see well in
5:51
making soto applications sometimes we
5:53
also need to display data that does not
5:57
only come from one table but
6:01
can Bro table at the same time as
6:03
an example based on the image above we
6:06
want to display the customer's name and the type of
6:09
action he has ever done so for
6:12
this example we must be able to
6:14
combine at least two tables namely the
6:16
customer table And the Last
6:20
Message message yes How do you do the machine
6:24
Hi Kinanti how is the coding
6:29
for this meeting this is just
6:34
remembering actually the pole of class
6:40
Hi in each again like that yes already Buried the
6:44
SQL coding that has been used for a long time
6:51
how to make it how to make a table delete the
6:57
aggregate then join it
7:02
Hi more understood like that deepened
7:07
that first most from Ma'am for today
7:12
I Made the assignment
7:15
Hi actually there is an assignment biodaa
7:18
later yes most at the
7:20
next opportunity or the second meeting there will be an
7:23
assignment from Ma'am today That's enough for the
7:28
car shop guidance wassalamualaikum
7:32
warahmatullahi wabarakatuh
