Inner vs. Outer Joins in SQL
9:20
9 жыл бұрын
SQL Three Table Join Examples
14:13
10 жыл бұрын
SQL WHERE versus HAVING Example
11:45
10 жыл бұрын
Fourth Normal Form vs ER Modeling
5:37
Normalization:  The First Normal Form
12:04
Update Anomalies
12:46
11 жыл бұрын
When to Index an RDBMS
10:58
11 жыл бұрын
DBMS Indexing: The Basic Concept
9:52
Introducing Aggregation in SQL
9:46
11 жыл бұрын
Translation Part 2
8:49
11 жыл бұрын
Translation Part 1
8:04
11 жыл бұрын
Additional Join Syntax Options
9:21
11 жыл бұрын
Intro to Joins
13:08
11 жыл бұрын
Ternary Relationships
11:26
11 жыл бұрын
Пікірлер
@user-yg5oz2pq1u
@user-yg5oz2pq1u 3 ай бұрын
Great video sir, out of the 3 video's my professor had us watch, I like this the most. Liked and Subbed
@douaabousnina
@douaabousnina 4 ай бұрын
thank you!
@fitking1234
@fitking1234 7 ай бұрын
u posted after 8 years hope you are doing fine and great sir. I hope u a better health . in this side of screen is someone from Pakistan
@udanasrimal
@udanasrimal 7 ай бұрын
Thank you sir❤
@flipsmash
@flipsmash 7 ай бұрын
Most welcome
@ZiiiP2142
@ZiiiP2142 9 ай бұрын
Very good info, cheers.
@jorisreevenvas5571
@jorisreevenvas5571 9 ай бұрын
What a clear explaination!! i have exams in 2 hours and you helped me out god bless you!!
@jaderabbit1267
@jaderabbit1267 Жыл бұрын
Thank you for the video. It was very helpful
@Myself_9037
@Myself_9037 Жыл бұрын
I have a doubt. I have table with two fields, one field is array in table 1 uID | Contact 2 | 1221,1223 3 | 1123 Now value of 1221 and 1223 are in table Two. I want a query to join table 1 and table 2 using array of field2
@pathumsrinath401
@pathumsrinath401 Жыл бұрын
Super explanation 🤍
@mohammadahmedragab837
@mohammadahmedragab837 Жыл бұрын
thank you so much for this valuable helpful video
@charger2dagame
@charger2dagame Жыл бұрын
Thank you for taking time out to make this video. It really helped me to understand the concept of RI.
@flipsmash
@flipsmash Жыл бұрын
Thanks. So glad to hear it!
@alefalfa
@alefalfa Жыл бұрын
awsome explanation. Thanks!
@mahrou616
@mahrou616 Жыл бұрын
Thank you, Sir
@lorenzorichards7093
@lorenzorichards7093 Жыл бұрын
Design the database for a programming support environment. In this environment programmers produce programs, which are written in given programming languages. Each program is written by a given programmer, can call other programs, and can be used by given users. Users are recognized by their log-in names. Programmers are recognized by their log-in name and by their code. Programs have compound names that include the program's name, the extension and the programmer's code. Programs have a version number, a date and a short description; some programs interact with DBMSs. Each DBMS maintains stored data in the form of relations, with several attributes and one primary key. Each database is defined by a database administrator, who is a programmer specialized in data management. State clearly any assumptions you make. Good morning, I seem to having issues creating the ERD with ISA what did I do wrong?
@flipsmash
@flipsmash Жыл бұрын
Sorry, this looks to be homework. You should seek help via your instructor/institution
@more-uv4nl
@more-uv4nl Жыл бұрын
you made me pass my exam <3
@guliyevshahriyar
@guliyevshahriyar Жыл бұрын
thank you very much!
@seyyedrizmy4732
@seyyedrizmy4732 Жыл бұрын
Hi in the video about the subclasses, wont they be applicable when there is covering constraint and not the disjoint??
@GunnyJoeGarcia
@GunnyJoeGarcia 2 жыл бұрын
Good video. Terrible soul patch.
@TuanPham-fc2oy
@TuanPham-fc2oy 2 жыл бұрын
Very well explained
@ashleylove6840
@ashleylove6840 2 жыл бұрын
Thank you so much!! I can only understand theis topics with you, my professor is really bad at explaining things. This will definitely help me throughout the semester.
@flipsmash
@flipsmash 2 жыл бұрын
Happy to help!
@UNKNOWN-ms7gz
@UNKNOWN-ms7gz 10 ай бұрын
same as u
@mickeywebb6850
@mickeywebb6850 2 жыл бұрын
Your weakest video TBH.
@medAmineRg
@medAmineRg 2 жыл бұрын
that was very helful sir tankyou so much
@AbbSalehi
@AbbSalehi 2 жыл бұрын
Thanks for your clear explanation, that is something I was looking for!
@sitaramrathi7483
@sitaramrathi7483 2 жыл бұрын
यह तो एक उदाहरण के लिये दिये है इसी तरह से अलग अलग परिवारो के अगर हजारों लिखने हो तो कैसे होगा
@noufa99
@noufa99 2 жыл бұрын
ty hoping to remember this while having my final!
@Escko
@Escko 2 жыл бұрын
Great...ty!!!
@keethsamarakoon2607
@keethsamarakoon2607 2 жыл бұрын
thanks for the lecture ...
@arts.maimounah
@arts.maimounah 2 жыл бұрын
Thank you so much Sir⭐⭐ amazing lesson , great representaion 👍
@L33TTechReviewer
@L33TTechReviewer 2 жыл бұрын
awesome vid, very easy to understand, Thanks!
@danielaguiar9807
@danielaguiar9807 2 жыл бұрын
This video might get me a job, thanks man
@wizzard211
@wizzard211 2 жыл бұрын
Don’t see the difference between 1 and 3
@gchehabayesa1006
@gchehabayesa1006 2 жыл бұрын
Thanks for the explanation. The only con I see is that to generate an index you first need to scan the whole thing. But I guess its pro as that you only have to scan once.
@MuhammadRafliYulistiawan
@MuhammadRafliYulistiawan 3 жыл бұрын
Thank you, Sir
@sergey5551
@sergey5551 3 жыл бұрын
Useful info starts at 4:46.
@winnumber101
@winnumber101 3 жыл бұрын
“The concept of albums is kind of going away” even more true now
@scavbh01
@scavbh01 3 жыл бұрын
Thanks!!!
@smitmangukiya
@smitmangukiya 3 жыл бұрын
Thank you
@sirawitmahanin5679
@sirawitmahanin5679 3 жыл бұрын
@6:00 In the case of 1:N without (weak entity), it does not make sense to me to have the same song with 37 different Songs# (assume that all songs are the same, i.e. same record/version).
@dickiie9970
@dickiie9970 3 жыл бұрын
how do u paste the previous copy as u did?
@flipsmash
@flipsmash 3 жыл бұрын
You can use the up and down arrows to scroll through all of your previous statements. You can also literally copy and paste in PuTTY (and, presumably other SSH clients). In PuTTY, to copy just click and drag your mouse to highlight what you want copied. It is automatically added to the clipboard. Then to paste, just right click.
@mzamomahaeng268
@mzamomahaeng268 3 жыл бұрын
excellent explanation 👌 thank you
@miguele7563
@miguele7563 3 жыл бұрын
How is the index table sorted if it has characters instead of numbers? Great Video!
@ichaverterhemba4827
@ichaverterhemba4827 3 жыл бұрын
It can be indexed/sorted alphabetically. My suggestion
@Qaboom
@Qaboom 3 жыл бұрын
Ha, worth the watch for the Far Side trivia alone! Nice explanation, thanks.