Constant Learners - AI, ML, Computer Science
Constant Learners - AI, ML, Computer Science
  • Видео 106
  • Просмотров 522 999
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...
Просмотров: 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

Комментарии

  • @inturukamala8928
    @inturukamala8928 5 дней назад

    very good explanation

  • @fatimaali1125
    @fatimaali1125 6 дней назад

    great explanation

  • @ConstantLearners_AI_ML_CS
    @ConstantLearners_AI_ML_CS 7 дней назад

    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))

  • @JyothsnaPotta
    @JyothsnaPotta 9 дней назад

    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

    • @ConstantLearners_AI_ML_CS
      @ConstantLearners_AI_ML_CS 8 дней назад

      Oh, thank you so much! I hope your exam went well... All the best for the rest of the papers.

  • @joshuandulinga5015
    @joshuandulinga5015 23 дня назад

    Thank you so much for this wonderful explanation!

  • @astitvasingh9182
    @astitvasingh9182 26 дней назад

    nice

  • @prasadbura8544
    @prasadbura8544 Месяц назад

    6

  • @Maxii_deva_32
    @Maxii_deva_32 Месяц назад

    Thank you 👍

  • @StanIzuchukwu
    @StanIzuchukwu Месяц назад

    am just starting to learn data analysis, hope this will teach me the concept and principles of data analysis ?

  • @StanIzuchukwu
    @StanIzuchukwu Месяц назад

    i like your teaching,

  • @HariniRaju-n4l
    @HariniRaju-n4l Месяц назад

    Tq❤

  • @sktechypedia
    @sktechypedia Месяц назад

    Nice explanation ❤

  • @larabyacine3397
    @larabyacine3397 Месяц назад

    درس جميل

  • @MisstAshh0
    @MisstAshh0 Месяц назад

    Clear explanation. Oucw, TMV Telangana.

  • @Precise-qo3jx
    @Precise-qo3jx Месяц назад

    Now I understand data models thank you

  • @thellaidhinesh8929
    @thellaidhinesh8929 Месяц назад

    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

    • @ConstantLearners_AI_ML_CS
      @ConstantLearners_AI_ML_CS Месяц назад

      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

    • @ConstantLearners_AI_ML_CS
      @ConstantLearners_AI_ML_CS Месяц назад

      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.

  • @thellaidhinesh8929
    @thellaidhinesh8929 2 месяца назад

    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 !

  • @thellaidhinesh8929
    @thellaidhinesh8929 2 месяца назад

    Your explanations are very detailed and indepth

  • @parmjitkaur4498
    @parmjitkaur4498 2 месяца назад

    Very nice explanation and presentation ❤

  • @praritthakur9624
    @praritthakur9624 2 месяца назад

    Very mich imformative .. all the basic info is covered in it ... thank you so much.❤ tomorrow is my exam❤❤❤

  • @Cloudy_vibe_7
    @Cloudy_vibe_7 2 месяца назад

    tnxs

  • @thellaidhinesh8646
    @thellaidhinesh8646 2 месяца назад

    This is a very great video, and explanation was also very clear

  • @YaseenmYaseenm-lt2cc
    @YaseenmYaseenm-lt2cc 2 месяца назад

    Bca students assemble ----------✊

  • @gudivadabharathsekhar9807
    @gudivadabharathsekhar9807 2 месяца назад

    gud explanation mam very underrated but solid content

  • @user-te4yf6mq9h
    @user-te4yf6mq9h 3 месяца назад

    supper madam

  • @user-te4yf6mq9h
    @user-te4yf6mq9h 3 месяца назад

    supper madam

  • @fatimaali9785
    @fatimaali9785 3 месяца назад

    Extremely helpful and time saving

  • @Vigyan-ik9rv
    @Vigyan-ik9rv 3 месяца назад

    It helped me a lot😊

  • @SIGMAMALEUTUBE
    @SIGMAMALEUTUBE 3 месяца назад

    Who is watching this video 3 hours ago before exam 😭😂

  • @user-ig1dd8iu5u
    @user-ig1dd8iu5u 3 месяца назад

    love your teaching

  • @sonamraj5323
    @sonamraj5323 3 месяца назад

    Very helpful thank you so much ❤

  • @sonamraj5323
    @sonamraj5323 4 месяца назад

    It's superb thank you so much ❤

  • @ljaykhan520
    @ljaykhan520 4 месяца назад

    Great tutorial 👍❤❤

  • @Mrguy-zy2bl
    @Mrguy-zy2bl 4 месяца назад

    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

  • @EthioQuestions
    @EthioQuestions 4 месяца назад

    👍👍👍

  • @NagarajS-xn5hx
    @NagarajS-xn5hx 4 месяца назад

    Very good explanation.

  • @abhiabhishekmakala2462
    @abhiabhishekmakala2462 4 месяца назад

    Watching 4hrs before the exam whish me all the best

  • @YosephTilahun-nr2uo
    @YosephTilahun-nr2uo 5 месяцев назад

    It was so important to me❤

  • @aghamajesurobo
    @aghamajesurobo 5 месяцев назад

    I found your explanation really good; I wish I could you give you a hug. Amazing Tutor you are!

  • @krishnaa5351
    @krishnaa5351 5 месяцев назад

    Worst way of teaching, no one understand this

  • @din-do-that
    @din-do-that 5 месяцев назад

    love this course,thank u very much

  • @din-do-that
    @din-do-that 5 месяцев назад

    thk u very much for this series.

  • @davidmugendi5430
    @davidmugendi5430 5 месяцев назад

    it's good

  • @Jaygee488
    @Jaygee488 6 месяцев назад

    why do all Indian RUclips videos start with "Hello Friends"?

    • @ConstantLearners_AI_ML_CS
      @ConstantLearners_AI_ML_CS 5 месяцев назад

      Suggest a better start

    • @Jaygee488
      @Jaygee488 5 месяцев назад

      @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 ♥️

    • @ConstantLearners_AI_ML_CS
      @ConstantLearners_AI_ML_CS 5 месяцев назад

      @@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

    • @JintoSteny
      @JintoSteny 2 месяца назад

      Is there any problem

    • @Jaygee488
      @Jaygee488 Месяц назад

      @@JintoSteny I don't know, you tell me

  • @prabinkoirala5604
    @prabinkoirala5604 6 месяцев назад

    just theoritical

    • @ConstantLearners_AI_ML_CS
      @ConstantLearners_AI_ML_CS 5 месяцев назад

      The video was too long to add more examples. Though I tried to include as many as I could.

  • @pallabikumari8253
    @pallabikumari8253 6 месяцев назад

    Very helpful Video thanks 😊

  • @doaa2064
    @doaa2064 7 месяцев назад

    تسلمي ي وليه لولولوي❤❤

  • @marvii13
    @marvii13 7 месяцев назад

    Never seen a seamless explanation like this before .. Thank you mam, you are the best 🥰🤍

  • @hessaaa4914
    @hessaaa4914 7 месяцев назад

    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

  • @_Christie_moonlight
    @_Christie_moonlight 7 месяцев назад

    Thank you ma'am 💗💗