Тёмный
notyournormalbrother
notyournormalbrother
notyournormalbrother
Подписаться
A lecture and lab tutorial for database
PHP to Oracle Connection
9:00
Год назад
SQL Exercise and Answer
25:57
3 года назад
Basic SQL in 1 Hour++
1:17:43
3 года назад
Data Warehouse Part 4
23:34
4 года назад
Data Warehouse Part 3
12:44
4 года назад
Data Warehouse Part 2
6:01
4 года назад
Data Warehouse Part 1
9:39
4 года назад
Working with Sequence & Schema Creation
25:20
4 года назад
Distributed DBMS Part 5
5:00
4 года назад
Distributed DBMS Part 4
34:03
4 года назад
Distributed DBMS Part 3
6:53
4 года назад
Distributed DBMS Part 2
6:57
4 года назад
Distributed DBMS Part 1
10:09
4 года назад
Transactions & DML Part 3
19:06
4 года назад
Transactions & DML Part 2
25:01
4 года назад
Transactions & DML Part 1
12:46
4 года назад
Query Processing
16:17
4 года назад
Set Operators
25:59
4 года назад
SQL Exercise and Solution
22:54
4 года назад
ERD Exercise Solution
15:34
4 года назад
Subqueries Part 2
26:06
4 года назад
Subqueries Part 1
16:59
4 года назад
Join Operation Part 4
11:07
4 года назад
Join Operation Part 3
8:09
4 года назад
Join Operation Part 2
13:22
4 года назад
Join Operation Part 1
6:42
4 года назад
Комментарии
@cikpon79
@cikpon79 12 дней назад
i got this erre "ORA-24960 the attribute OCI_ATTR_PASSWORD is greater than the maximum allowable length of 1024" can u give me the solution?
@adibsarkawi3532
@adibsarkawi3532 Месяц назад
Terima kasih
@afbsnasbm
@afbsnasbm 3 месяца назад
sir klau minit 23:04 kita terbalikkan on tu contoh m.staffid=s.mgrid sama maksud tak sir
@muhammadakmal4025
@muhammadakmal4025 3 месяца назад
terbaik sir, lagi 2 jam saya exam dan saya dah faham
@amneeyusree2173
@amneeyusree2173 3 месяца назад
cantekkkk sirr thankyou
@milans2373
@milans2373 3 месяца назад
In my php info() there is no oci8. How can fix this?
@Rannagorer_Goppo
@Rannagorer_Goppo 4 месяца назад
pls give testdatabse.php file
@mann9108
@mann9108 4 месяца назад
damnn bro i finally did it, thankyou very much
@ABINETDEGEFA
@ABINETDEGEFA 4 месяца назад
very clear and simple explanation
@sitinurzulaikha7957
@sitinurzulaikha7957 4 месяца назад
love it ❤❤❤
@asyraflutfi8669
@asyraflutfi8669 5 месяцев назад
Tq sirr🫡🫡
@nurathirah_.
@nurathirah_. 6 месяцев назад
may i ask if the application table is considered a bridge entity or not?
@unseen_dev
@unseen_dev 6 месяцев назад
Exactly like the slides my college teaches, much needed. Thanks, brooooooooooooooooooo!!!!!!!!!!
@MurryTic
@MurryTic 6 месяцев назад
Thanks a lot. Your vid just saved my master degree. :)
@iborhan36
@iborhan36 7 месяцев назад
One and only video in the whole of youtube that uses box to specify entity and attributes together. THANK YOU SO MUCH FOR MAKING THIS VIDEO!
@muhammadabdansyakuro1641
@muhammadabdansyakuro1641 8 месяцев назад
waalaikumussalam
@wonderland2508
@wonderland2508 8 месяцев назад
Thank you so much for this! You explain much more better than my lecturer. I understand it now. <3 <3
@liro.2552
@liro.2552 9 месяцев назад
thank you so much sir, you save me
@itsshida3622
@itsshida3622 11 месяцев назад
thank you so much! really appreciated it!
@HP-ez2pp
@HP-ez2pp 11 месяцев назад
😁
@jolie2194
@jolie2194 Год назад
Great Explanation, Hope to hear more like this material delivery
@azmisyaiz4357
@azmisyaiz4357 Год назад
Assalamualaikum sir, I just wanna thank you a lot for creating such amazing videos and explaination. Alhamdulillah sy dapat A dalam subject Db Engineering berkat pengajaran lecturer + video2 sir ...😘
@muhammadfarhatnazmibinmohd9955
Top 10 Anime Best Savior All Of Time
@PatRose
@PatRose 7 месяцев назад
welcome to the rice fields mf
@jerungbiru55
@jerungbiru55 Год назад
nice
@nuradamdnl
@nuradamdnl Год назад
thanks sir 🙏 you're a livesaver
@trigobrooken6260
@trigobrooken6260 Год назад
Thank you Sir
@aimeemurillo9739
@aimeemurillo9739 Год назад
This has helped me so so much! Thank you for explaining it all so well
@DunTrann
@DunTrann Год назад
Thank you verry much
@jay_prajapati36
@jay_prajapati36 Год назад
Which software are you used for this?
@notyournormalbrother
@notyournormalbrother Год назад
Videoscribe
@andrian.budiluhur
@andrian.budiluhur Год назад
thank you brother
@ikmalasraf8850
@ikmalasraf8850 Год назад
Is it possible to have a combination of self join with any outer join to output data from a single table? If yes, will it be 1 real table + 2 'imaginary' tables?
@notyournormalbrother
@notyournormalbrother Год назад
yes u can. but what do u mean by imaginary table?
@ikmalasraf8850
@ikmalasraf8850 Год назад
@@notyournormalbrother What I mean is when we select 2-3 same tables but differentiate it with alias .For example SELECT employees e JOIN employees m .... JOIN employees l ..
@notyournormalbrother
@notyournormalbrother Год назад
@@ikmalasraf8850 there is no imaginary table. All are tables inside the database. Oracle just treat them differently because you gv it different names because they are all the same tables.
@iremimsena
@iremimsena Год назад
Thank you so much☺...
@ashikinawang6568
@ashikinawang6568 2 года назад
sir macam mane nak bezakan strong relationship dgn weak relationship..masa mana perlu guna garis lurus tu atau garis putus2 tu.. saya keliru yg tu ?
@notyournormalbrother
@notyournormalbrother 2 года назад
weak relationship - bila ada connection between strong and strong entities. (putus-putus) strong relationship - bila ada connection between strong entity with weak entity (solid line) strong entity - can exist on its own weak entity - need strong entity to exist (contoh, bridge entity)
@devgeethevirus7323
@devgeethevirus7323 2 года назад
I LIKE HOW YOU TEACH ... THANK YOU.
@serenedipity4052
@serenedipity4052 2 года назад
THANK YOUUUUU💕
@serenedipity4052
@serenedipity4052 2 года назад
THANK YOUUU!! 💕
@serenedipity4052
@serenedipity4052 2 года назад
THANK YOU! I LEARNED SO MUCH IN MY LESSON 4 BECAUSE OF YOU! 🙏💕
@Djhkm1000
@Djhkm1000 3 года назад
Semoga Allah permudahkan urusan sir, sbb sir dh permudahkan urusan saya
@arishaafini269
@arishaafini269 3 года назад
yes its very useful . Thank You !
@mottledbubble
@mottledbubble 3 года назад
thank you so much bro
@yashp
@yashp 3 года назад
Hi, where did you get the questions from? I need them to revise
@yashp
@yashp 3 года назад
How did you do the drawing animations?
@notyournormalbrother
@notyournormalbrother 3 года назад
iPad Pro + Apple pencil with Microsoft whiteboard
@notyournormalbrother
@notyournormalbrother 3 года назад
For animation, videoscribe + easy sketch
@yashp
@yashp 3 года назад
hi, which software did you use to draw? Awesome video btw I understood the concepts well
@notyournormalbrother
@notyournormalbrother 3 года назад
Hi. I use few software. Easy sketch and videoscribe
@notyournormalbrother
@notyournormalbrother 3 года назад
For drawing, i use ipad pro + apple pencil on Microsoft whiteboard
@SurajSharma-gv5ij
@SurajSharma-gv5ij 3 года назад
Sir I want to ask questions related to database will you give me your mail id
@notyournormalbrother
@notyournormalbrother 3 года назад
the answer at 12:40 - the subquery should be select max(count(isbn)) from WRITE group by authorid; sorry for the confusion.
@radhifauzan3502
@radhifauzan3502 3 года назад
Thank You Sir Hamiz!
@radhifauzan3502
@radhifauzan3502 3 года назад
assalam sir, by the end of this topic (relational model) are the question on test 1 will ask us to draw a complete ERD?
@notyournormalbrother
@notyournormalbrother 3 года назад
yup. soalan mmg normally kena lukis complete erd. You can check exercise playlist to see example of the question
@radhifauzan3502
@radhifauzan3502 3 года назад
notyournormalbrother thank you sir hamiz ☺️
@akim5030
@akim5030 3 года назад
Bang, kalau students dgn courses entity bukan one to many? Keliru sikit
@notyournormalbrother
@notyournormalbrother 3 года назад
courses ni refer to subjects yang dia ambil. contoh course: database. so, 1 subject many students, 1 student many subjects. 1 student boleh ambil banyak courses at the same time. contoh, satu semester kan student boleh ambil 5-6 courses kan. same goes, dalam satu semester, takkan sorang je ambil course database. ramai student ambil. So, maximum occurences utk student dengan course akan jadi, many students, many courses. Hence, kena ada bridge la in between students and courses.
@r.t.8592
@r.t.8592 3 года назад
Hi, how to represent "read_only", "view" roles or authentication on entities tables in ERD if that was written in the problem scenario please, also for the visitors users to an online forum , do we have to represent them in a separate entity please?
@notyournormalbrother
@notyournormalbrother 3 года назад
Sorry, I dont get your question. But, read only table can be done with alter statement. You create the table as usual, insert all the data needed, then alter the table into read only status to make sure the table cannot be updated or deleted. But, if you want the user has read only on the system, you need to handle it at your coding. For visitor of online forum, if you did not want to store their data, no need new entity. If you want to keep their details, they are not visitors, they have become user already.
@LuciaSilva-ek3qr
@LuciaSilva-ek3qr 3 года назад
Very good explanation. Tkx