- Видео 106
- Просмотров 522 999
Constant Learners - AI, ML, Computer Science
Индия
Добавлен 3 сен 2020
Hello friends!
I am an engineer based in Dubai.
Previously my channel was 'My Tiny Territory', but now it has been changed to 'Constant Learners' because I feel life is a phenomenon that requires constant learning.
Thank you so much for stopping by.
I am an engineer based in Dubai.
Previously my channel was 'My Tiny Territory', but now it has been changed to 'Constant Learners' because I feel life is a phenomenon that requires constant learning.
Thank you so much for stopping by.
33. UNION OPERATION | Relational Algebra | DBMS | #relational_algebra_query #relationaldatabase
#UNIONOPERATION #project #select #procedural_query_language
00:00 - Introduction
02:05 - UNION of 2 tables
07:07 - UNION of columns from different tables
07:17 - Example 1
09:15 - Example 2
12:35 - Example 3
15:13 - Example 4
32. PROJECTION OPERATION -
ruclips.net/video/Ydu4dmL21rc/видео.html
31. SELECTION OPERATION -
ruclips.net/video/Jm40Q5BYAPk/видео.html
30. Relational Algebra -
ruclips.net/video/KEF_PwGaHKg/видео.html
Relational query language (procedural/non-procedural) -
ruclips.net/video/qaJKQ8Ml8xs/видео.html
DBMS complete syllabus -
ruclips.net/video/I2CVUzy5xhQ/видео.html
Playlists available on the channel --
DBMS complete syllabus -
ruclips.net/video/_JV6r2KExek/видео.html&pp=gAQBiAQB
Big data a...
00:00 - Introduction
02:05 - UNION of 2 tables
07:07 - UNION of columns from different tables
07:17 - Example 1
09:15 - Example 2
12:35 - Example 3
15:13 - Example 4
32. PROJECTION OPERATION -
ruclips.net/video/Ydu4dmL21rc/видео.html
31. SELECTION OPERATION -
ruclips.net/video/Jm40Q5BYAPk/видео.html
30. Relational Algebra -
ruclips.net/video/KEF_PwGaHKg/видео.html
Relational query language (procedural/non-procedural) -
ruclips.net/video/qaJKQ8Ml8xs/видео.html
DBMS complete syllabus -
ruclips.net/video/I2CVUzy5xhQ/видео.html
Playlists available on the channel --
DBMS complete syllabus -
ruclips.net/video/_JV6r2KExek/видео.html&pp=gAQBiAQB
Big data a...
Просмотров: 39
Видео
32. PROJECTION OPERATION | Relational Algebra | DBMS | #relational_algebra_query #relationaldatabase
Просмотров 64Месяц назад
#PROJECTIONOPERATION #select #procedural_query_language 01:35 - SELECT revision 03:59 - PROJECT 05:05 - Example 1 06:02 - Example 2 07:51 - Example 3 31. SELECTION OPERATION - ruclips.net/video/Jm40Q5BYAPk/видео.html 30. Relational Algebra - ruclips.net/video/KEF_PwGaHKg/видео.html Relational query language (procedural/non-procedural) - ruclips.net/video/qaJKQ8Ml8xs/видео.html DBMS complete syl...
31. SELECTION OPERATION | Relational Algebra | DBMS | #relational_algebra_query #relationaldatabase
Просмотров 632 месяца назад
#SELECTIONOPERATION #select #procedural_query_language 00:28 - Introduction to relational algebra 01:35 - SELECT 03:59 - understand the output 05:05 - Example 1 06:02 - Example 2 07:51 - Example 3 09:15 - Relational and Logical operators 30. Relational Algebra - ruclips.net/video/KEF_PwGaHKg/видео.html Relational query language (procedural/non-procedural) - ruclips.net/video/qaJKQ8Ml8xs/видео.h...
30. Relational Algebra | DBMS | #relational_algebra_query #relationaldatabase #sql
Просмотров 843 месяца назад
#procedural_query_language 00:20 - Introduction to relational algebra 01:30 - Basics 05:25 - Why relational algebra? 07:20 - Characteristics of relational algebra 09:40 - Operations in relational algebra Relational query language (procedural/non-procedural) - ruclips.net/video/qaJKQ8Ml8xs/видео.html DBMS complete syllabus - ruclips.net/video/I2CVUzy5xhQ/видео.html Playlists available on the cha...
29. Relational Query Language | DBMS | #relational_algebra_query #relationaldatabase #sql
Просмотров 1464 месяца назад
#non-procedural_query_language #procedural_query_language 00:00 - Introduction to query languages 03:05 - Why do we need relational query language? 04:19 - Types of relational query language 04:30 - Procedural and non-procedural query language DBMS complete syllabus - ruclips.net/video/I2CVUzy5xhQ/видео.html Playlists available on the channel DBMS complete syllabus - ruclips.net/video/_JV6r2KEx...
28. Boyce-Codd Normal Form | BCNF | #BCNF #normalform
Просмотров 1307 месяцев назад
00:00 - Requirements 00:50 - Introduction to Boyce-Codd Normal Form 01:49 - Rules for BCNF 02:40 - Trivial FD 04:00 - Non-trivial FD 06:13 - Example Previous videos - 19. Normalization| Insertion, Updation and Deletion Anomaly - ruclips.net/video/AN2s-fh-pd0/видео.html 21. Trivial and non-trivial functional dependency - ruclips.net/video/ULlSj90N2jU/видео.html DBMS complete syllabus - ruclips.n...
27. Third Normal Form | 3NF | Transform a table to 3NF | #3NF #normalform
Просмотров 1257 месяцев назад
00:00 - Introduction to 3rd Normal Form 00:20 - Requirements 02:09 - Rules for 3NF 02:35 - Transitive Dependency 03:40 - Example 1 06:00 - Example 2 09:55 - Example 3 Previous videos - 26. Second Normal Form | 2nd NF - ruclips.net/video/Kwvu3CbYxzk/видео.html 19. Normalization| Insertion, Updation and Deletion Anomaly - ruclips.net/video/AN2s-fh-pd0/видео.html 24. Partial dependency | Prime and...
26. Second Normal Form | 2nd NF | Database Normalization | DBMS complete syllabus playlist
Просмотров 1558 месяцев назад
00:00 - Introduction to 2nd Normal Form 00:50 - Rules for a relation to be in 2NF 01:30 - Partial dependency 06:15 - Example 1 11:20 - Example 2 Previous videos - 25. First Normal Form | 1st NF - ruclips.net/video/c_uKijumDWk/видео.html 19. Normalization| Insertion, Updation and Deletion Anomaly - ruclips.net/video/AN2s-fh-pd0/видео.html 24. Partial dependency | Prime and Non-prime attributes -...
25. First Normal Form | 1st NF | Database Normalization | DBMS complete syllabus playlist
Просмотров 1848 месяцев назад
00:00 - Introduction to Database Normalization 01:00 - Levels of Normalization i.e. Normal Forms 02:00 - 1st NF - Atomic attributes 03:33 - Ways to transform relation in 1st NF 08:35 - 1st NF - Attribute domain must be consistent 10:15 - 1st NF - Unique attribute names 11:10 - 1st NF - The order of rows/columns must not be fixed Previous videos - 19. Normalization| Insertion, Updation and Delet...
24. Partial dependency | Prime and Non-prime attributes | DBMS complete syllabus playlist
Просмотров 2868 месяцев назад
Previous videos - 23. Find all the Candidate Keys in a relation - ruclips.net/video/sMG99YR63k4/видео.html 22. Attribute Closure - ruclips.net/video/ARtYYKF3fzg/видео.html 12. Keys | Super Keys - ruclips.net/video/JvS9Nldtd4U/видео.html 13. Candidate Keys - ruclips.net/video/I2CVUzy5xhQ/видео.html 21. Properties & Types of Functional Dependency - ruclips.net/video/ULlSj90N2jU/видео.html DBMS co...
23. Find all the Candidate Keys in a relation | DBMS complete syllabus playlist
Просмотров 5738 месяцев назад
Previous videos - 22. Attribute Closure - ruclips.net/video/ARtYYKF3fzg/видео.html 12. Keys | Super Keys - ruclips.net/video/JvS9Nldtd4U/видео.html 13. Candidate Keys - ruclips.net/video/I2CVUzy5xhQ/видео.html 21. Properties & Types of Functional Dependency - ruclips.net/video/ULlSj90N2jU/видео.html DBMS complete syllabus - ruclips.net/video/I2CVUzy5xhQ/видео.html Playlists available on the cha...
22. Attribute Closure | DBMS complete syllabus playlist
Просмотров 1539 месяцев назад
00:00 - Introduction 00:34 - What is Attribute Closure 02:05 - How to find Attribute Closure? 05:45 - Why do we find Attribute Closure? 06:10 - How to find Super & Candidate key 09:40 - Example to learn short cuts Previous videos - 21. Properties & Types of Functional Dependency - ruclips.net/video/ULlSj90N2jU/видео.html DBMS complete syllabus - ruclips.net/video/I2CVUzy5xhQ/видео.html Playlist...
21. Properties & Types of Functional Dependency | FD in DBMS | DBMS complete syllabus playlist
Просмотров 1879 месяцев назад
00:00 - What is FD? 02:42 - Properties of FD 13:10 - Types of FD Previous videos - 20. Functional Dependency | Determinants & Dependents | FD in DBMS - ruclips.net/video/vkv1vvTUP-4/видео.html DBMS complete syllabus - ruclips.net/video/I2CVUzy5xhQ/видео.html Playlists available on the channel DBMS complete syllabus - ruclips.net/video/_JV6r2KExek/видео.html&pp=gAQBiAQB Big data analysis - rucli...
20. Functional Dependency | Determinants & Dependents | FD in DBMS | DBMS complete syllabus playlist
Просмотров 1649 месяцев назад
00:00 - What is FD? 04:30 - How to represent or denote FD? 07:00 - Cases where FD exists and does not exist 07:20 - (1) If there are same Determinants 10:00 - (2) If there are same Dependents 13:00 - (3) If the Determinant is Unique 14:00 - Real life example Previous videos - 15. Foreign Keys - ruclips.net/video/AMt3y5PA-cU/видео.html 14. Primary Keys | Alternate keys | Composite keys | Real-li...
19. Normalization| Insertion, Updation and Deletion Anomaly | DBMS complete syllabus playlist
Просмотров 2899 месяцев назад
19. Normalization| Insertion, Updation and Deletion Anomaly | DBMS complete syllabus playlist
18. Many-to-Many relationship in DBMS | Cardinality | DBMS complete syllabus playlist
Просмотров 1149 месяцев назад
18. Many-to-Many relationship in DBMS | Cardinality | DBMS complete syllabus playlist
17. One-to-many & Many-to-one relationship in DBMS | DBMS complete syllabus playlist
Просмотров 27210 месяцев назад
17. One-to-many & Many-to-one relationship in DBMS | DBMS complete syllabus playlist
16. Cardinality | One-to-one relationship in DBMS | DBMS complete syllabus playlist
Просмотров 12610 месяцев назад
16. Cardinality | One-to-one relationship in DBMS | DBMS complete syllabus playlist
15. Foreign Keys | Referential integrity | Real-life examples
Просмотров 11810 месяцев назад
15. Foreign Keys | Referential integrity | Real-life examples
14. Primary Keys | Alternate keys | Composite keys | Real-life examples
Просмотров 17010 месяцев назад
14. Primary Keys | Alternate keys | Composite keys | Real-life examples
13. Candidate Keys | Real-life examples
Просмотров 12710 месяцев назад
13. Candidate Keys | Real-life examples
12. Keys | Super Keys | Real-life examples
Просмотров 18110 месяцев назад
12. Keys | Super Keys | Real-life examples
11. Integrity Constraints | Real-life examples
Просмотров 39210 месяцев назад
11. Integrity Constraints | Real-life examples
10. Data Models | Real-life examples
Просмотров 4,6 тыс.10 месяцев назад
10. Data Models | Real-life examples
9. Instances & schemas | Real-life examples
Просмотров 307Год назад
9. Instances & schemas | Real-life examples
8. 3-Schema architecture | Data abstraction | Data Independence | Real-life examples
Просмотров 386Год назад
8. 3-Schema architecture | Data abstraction | Data Independence | Real-life examples
7. 2-tier and 3-tier architecture | With real life examples | DBMS complete syllabus
Просмотров 651Год назад
7. 2-tier and 3-tier architecture | With real life examples | DBMS complete syllabus
6. Database design process | With real life examples | Explanation and notes
Просмотров 5 тыс.Год назад
6. Database design process | With real life examples | Explanation and notes
5. Applications of DBMS | Explanation and notes
Просмотров 453Год назад
5. Applications of DBMS | Explanation and notes
4. File System vs DBMS | Disadvantages of file system | Real life example | Explanation and notes
Просмотров 406Год назад
4. File System vs DBMS | Disadvantages of file system | Real life example | Explanation and notes
very good explanation
great explanation
I am hoping that you could write the query by yourself. If you couldn't, kindly watch the video one more time. It's not difficult. You can do it. Still if you haven't been able to do it, check out the answer shared in this comment. If you still don't get it, simply write a comment with your question and I'll respond as quickly as possible. Keep learning! And thank you for watching. Π(first_name, last_name) (σ(enrollment_date >= '2022-01-01' ∧ enrollment_date <= '2022-12-31' ∧ dept = 'Physics') (Students)) ∪ Π(first_name, last_name) (σ(hire_date >= '2022-01-01' ∧ hire_date <= '2022-12-31' ∧ dept = 'Physics') (Professors))
hello i am jyothsna tommorow is my dbms exam and your video helped me alot and alot in a way that i have revised my total chapter within 15 min thankyou soo much 💕❤ u have really nailled it 🫡 i am in university but no one have explained this clear once again thanks alot from all my frnds side also
Oh, thank you so much! I hope your exam went well... All the best for the rest of the papers.
Thank you so much for this wonderful explanation!
Thank you! Glad it was helpful. You're very welcome!
nice
Thanks
6
Thank you 👍
Welcome
am just starting to learn data analysis, hope this will teach me the concept and principles of data analysis ?
i like your teaching,
@@StanIzuchukwu thank you
Tq❤
Nice explanation ❤
درس جميل
Shukran
Clear explanation. Oucw, TMV Telangana.
Thank you
Now I understand data models thank you
You're most welcome 🙂
Mam, still how many concepts in DBMS are left? If possible, can you please list them, i can refer those using other resources. I'm currently preparing for interviews, this would be a very great help for me
Hey! Study the basic Relational Algebric expressions with examples. Based on that you can get questions on SQL. How to select databases in SQL, select tables, modify, delete or store data in the tables. What if you need some data from 2 or more than 2 tables, which operation would you use? U must know the basic programming in SQL like SELECT, JOIN, etc and a basic understanding of how we query the databases in SQL
Normalization, data integrity and security, ACID properties, data warehousing, backup and recovery ka little knowledge will be helpful. I'm assuming you've done architecture and models, normalization. Some knowledge about NoSQL databases will also be helpful. If the time is short, brushing up the top layers of all of this will be enough. You must sound knowledgeable, they must know that you know some things about all of these.
Very very very very clear explanation. Im saying this after referring to many youTube channels, many articles and many chat GTP responses. You gave me a better understanding about this concept. Thank you so much for your time, i know this would have taken lot of efforts, like creating the PPT's, scripting, fetching sensible and easy examples. Kudos to your work & keep the good work going THANKS !
Thank you. That is very motivating 😊
Your explanations are very detailed and indepth
Oh thank you so much!
Very nice explanation and presentation ❤
Thank you very much
Very mich imformative .. all the basic info is covered in it ... thank you so much.❤ tomorrow is my exam❤❤❤
Thank you How was your exam? Which semester? Which board?
tnxs
You're welcome
This is a very great video, and explanation was also very clear
Thank you!
Bca students assemble ----------✊
gud explanation mam very underrated but solid content
Thank you!!
supper madam
Thank you very much
supper madam
Thank you very much
Extremely helpful and time saving
Thank you
It helped me a lot😊
I'm happy it did 😊
Who is watching this video 3 hours ago before exam 😭😂
Me!🤦🏽 4hours later Exam🥹😭
Me😂😂😂
Hope you did well!!!
Us bro us😂
Me too🤣
love your teaching
Thank you!
Very helpful thank you so much ❤
You're very welcome!! And thank you.
It's superb thank you so much ❤
Thank you too
Great tutorial 👍❤❤
Thank you
Features of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data AnalysisFeatures of R language | Big Data Analysis
👍👍👍
Very good explanation.
Thank you
Watching 4hrs before the exam whish me all the best
Sorry I am late to wish you luck, but I hope your exam went well.
Yet to see the results I will make a note. Hoping for the better 🙌
@@abhiabhishekmakala2462 Best of luck for your results
Got them 20/30
It was so important to me❤
I found your explanation really good; I wish I could you give you a hug. Amazing Tutor you are!
Ohh thank you so much 🥰 That's very kind of you
Worst way of teaching, no one understand this
Thank you
love this course,thank u very much
You're welcome
thk u very much for this series.
it's good
why do all Indian RUclips videos start with "Hello Friends"?
Suggest a better start
@ConstantLearners_AI_ML_CS "Hey, thank you for joining us today" "Hi viewers" P.s. your videos are awesome. Thanks for creating amazing content bro ♥️
@@Jaygee488 Will make sure to include those in the further videos. Make sure to check those out. But this video is a very old one, and my recent videos start with "Hello learners". Thank you for you kind words
Is there any problem
@@JintoSteny I don't know, you tell me
just theoritical
The video was too long to add more examples. Though I tried to include as many as I could.
Very helpful Video thanks 😊
Most welcome 😊
تسلمي ي وليه لولولوي❤❤
You're very welcome
Never seen a seamless explanation like this before .. Thank you mam, you are the best 🥰🤍
Thanks a lot 😊
Thank you ! I have no past knowledge about data organization but I came across your videos and everything was well explained, can’t wait to fully understand the whole concept and become an expert in it
You're very welcome. That's awesome!
Thank you ma'am 💗💗
Most welcome 😊