• رقم الدرس : 31
  • 00:06:02

  • sql introduction tutorial DBMS Lec-31 Bhanu Priya

  • تشغيل

دروس الكورس

  1. 1- DBMS tutorial for beginners DBMS Lec-01 Bhanu Priya
  2. 2- What is database DBMS Lec-02 Bhanu Priya
  3. 3- components of data base systems DBMS Lec-03 Bhanu Priya
  4. 4- DBMS Building blocks & Applications DBMS Lec-04 Bhanu Priya
  5. 5- DBMS architecture 1 tier 2 tier 3 tier DBMS Lec-05 Bhanu Priya
  6. 6- DBMS STRUCTURE DBMS Lec-06 Bhanu Priya
  7. 7- Database users in dbms with example administrators DBMS Lec-07 Bhanu Priya
  8. 8- Data Independence in dbms Logical and Physical data DBMS Lec-08 Bhanu Priya
  9. 9- attributes in dbms DBMS Lec-09 Bhanu Priya
  10. 10- type of attributes in dbms DBMS Lec-10 Bhanu Priya
  11. 11- er model in dbms components DBMS Lec-11 Bhanu Priya
  12. 12- ER model to relational model DBMS Lec-12 Bhanu Priya
  13. 13- Mapping relationship in dbms DBMS Lec-13 Bhanu Priya
  14. 14- mapping wek entity and hierarachy DBMS Lec-14 Bhanu Priya
  15. 15- relational model in dbms DBMS Lec-15 Bhanu Priya
  16. 16- constraints in dbms key, domain & referential integrity DBMS Lec-16 Bhanu Priya
  17. 17- Keys in dbms Introduction types of keys DBMS Lec-17 Bhanu Priya
  18. 18- super key in dbms DBMS Lec-18 Bhanu Priya
  19. 19- Candidate key in dbms DBMS Lec-19 Bhanu Priya
  20. 20- Primary key in dbms keys in DBMS DBMS Lec-20 Bhanu Priya
  21. 21- Foreign key in dbms DBMS Lec-21 Bhanu Priya
  22. 22- Keys in database Secondary key DBMS Lec-22 Bhanu Priya
  23. 23- Keys in database Composite key DBMS Lec-23 Bhanu Priya
  24. 24- Relational algebra in database management system introduction DBMS Lec-24 Bhanu Priya
  25. 25- Relational algebra operations in dbms DBMS Lec-25 Bhanu Priya
  26. 26- Relational algebra operations in dbms select operation DBMS Lec-26 Bhanu Priya
  27. 27- Relational algebra operations in dbms projection operation DBMS Lec-27 Bhanu Priya
  28. 28- Relational algebra operations in dbms set difference operation DBMS Lec-28 Bhanu Priya
  29. 29- Relational algebra operations in dbms union operation DBMS Lec-29 Bhanu Priya
  30. 30- Relational algebra operations in dbms Cartesian product operation DBMS Lec-30 Bhanu Priya
  31. 31- sql introduction tutorial DBMS Lec-31 Bhanu Priya
  32. 32- sql joins with examples Inner join DBMS Lec-32 Bhanu Priya
  33. 33- outer joins in sql with examples DBMS Lec-33 Bhanu Priya
  34. 34- Outer join Left, Right & Full DBMS Lec-34 Bhanu Priya
  35. 35- Aggregate functions in dbms DBMS Lec-35 Bhanu Priya
  36. 36- DDL : CREAT, DROP SQL Commands DBMS Lec-36 Bhanu Priya
  37. 37- DDL : ALTER, RENAME & TRUNCATE SQL Commands DBMS Lec-37 Bhanu Priya
  38. 38- dml in sql with examples DBMS Lec-38 Bhanu Priya
  39. 39- DCLl commands in sql with examples GRANT, REVOKE DBMS Lec-39 Bhanu Priya
  40. 40- pl sql concepts DBMS Lec-40 Bhanu Priya
  41. 41- PL SQL example DBMS Lec-41 Bhanu Priya
  42. 42- triggers in dbms DBMS Lec-42 Bhanu Priya
  43. 43- triggers in database with example DBMS Lec-43 Bhanu Priya
  44. 44- functional dependency in dbms DBMS Lec-44 Bhanu Priya
  45. 45- fully functional dependency in dbms transitive dependency DBMS Lec-45 Bhanu Priya
  46. 46- decomposition in dbms DBMS Lec-46 Bhanu Priya
  47. 47- lossless decomposition in dbms DBMS Lec-47 Bhanu Priya
  48. 48- normalization in database DBMS Lec-48 Bhanu Priya
  49. 49- 1nf normalization example Decomposition DBMS Lec-49 Bhanu Priya
  50. 50- 2NF normalization example Decomposition DBMS Lec-50 Bhanu Priya
  51. 51- 3nf normalization example DBMS Lec-51 Bhanu Priya
  52. 52- bcnf normalization in database with example DBMS Lec-52 Bhanu Priya
  53. 53- 4nf normalization in database with example DBMS Lec-53 Bhanu Priya
  54. 54- Relational calculus in dbms DBMS Lec-54 Bhanu Priya
  55. 55- Tuple Relational Calculus in dbms TRC DBMS Lec-55 Bhanu Priya
  56. 56- Domain relational calculus in dbms DRC DBMS Lec-56 Bhanu Priya
  57. 57- transaction management in dbms tutorial DBMS Lec-57 Bhanu Priya
  58. 58- ACID properties database Part -1/2 DBMS Lec-58 Bhanu Priya
  59. 59- ACID properties databas Part -2/2 DBMS Lec-59 Bhanu Priya
  60. 60- Transaction states in database example DBMS Lec-60 Bhanu Priya
  61. 61- Concurrency Control conflicts of serializabity of transactions DBMS Lec-61 Bhanu Priya
  62. 62- Lock based protocol in database concurrency control techniques DBMS Lec-62 Bhanu Priya
  63. 63- deadlock in database DBMS Lec-63 Bhanu Priya
  64. 64- Two phase locking example DBMS Lec-64 Bhanu Priya
  65. 65- Time stamping method in database DBMS Lec-65 Bhanu Priya
  66. 66- Time stamp ordering protocol in database DBMS Lec-66 Bhanu Priya
  67. 67- database recovery management DBMS Lec-67 Bhanu Priya
  68. 68- Physical storage in database DBMS Lec-68 Bhanu Priya
  69. 69- File organization in database importance Part -1/2 DBMS Lec-69 Bhanu Priya
  70. 70- file organization in database Importance Part-2/2 DBMS Lec-70 Bhanu Priya
  71. 71- Indexing in database example DBMS Lec-71 Bhanu Priya
  72. 72- classification indexing DBMS Lec-72 Bhanu Priya
  73. 73- primary indexing in database indexing DBMS Lec-73 Bhanu Priya
  74. 74- secondary indexing in database indexing DBMS Lec-74 Bhanu Priya
  75. 75- cluster indexing in database indexing DBMS Lec-75 Bhanu Priya
  76. 76- B+ tree in database Introduction & Example DBMS Lec-76 Bhanu Priya
  77. 77- B tree in database Introduction DBMS Lec-77 Bhanu Priya
  78. 78- B tree in database Example DBMS Lec-78 Bhanu Priya
  79. 79- need of query processing DBMS Lec-79 Bhanu Priya
  80. 80- query cost measures DBMS Lec-80 Bhanu Priya
  81. 81- materialized view in database DBMS Lec-81 Bhanu Priya
  82. 82- Sorting in database systems Algorithm DBMS Lec-82 Bhanu Priya
  83. 83- Sorting in data base systems Example DBMS Lec-83 Bhanu Priya