Learn Database Management : Video Tutorials

Meilleur tutoriel vidéo sur la gestion de bases de données pour les débutants

★ Table of Contents ★

1) Introduction

2) Database System Applications

3) Database System Versus File System

4) Data Abstraction

5) Instances And Schemas

6) Database Users And User Interfaces

7) Database Administrator

8) Data Models

9) Database Languages

10) Database System Structure

11) Entity And Entity Set

12) Attribute And Domain

13) Keys Super, Candidate, Primary, Alternate

14) Keys Foreign, Partial, Secondary

15) Keys Unique, Surrogate, Composite

16) Mapping Cardinalities

17) Relationship And Relationship Sets

18) Entity Relationship Diagram

19) Symbols In ER-Diagram

20) Mapping Cardinalities In ER-Diagram

21) ER-Diagram With Role-Indicators

22) ER-Diagram With Ternary Relationship

23) Weak Entity Set With Total Participation

24) Specialization And Generalization

25) ER-Diagram With Aggregation

26) ER-Diagram With Existence Dependency

27) Forming Schemas From ER-Diagram

28) Case Study On Banking System

29) Question Solve On ER-Diagram

30) Introduction To Relational Calculus

31) Tuple Relational Calculus

32) Tuple Relational Calculus Query Example

33) Domain Relational Calculus Query Example

34) Safety Of Expressions Of Domain And Tuple Relational Calculus

35) Formal Definition Of Domain Relational Calculus

36) Select Operation In Relational Algebra

37) Project Operation In Relational Algebra

38) Union Operation In Relational Algebra

39) Set-Difference Operation In Relational Algebra

40) Set Intersection Operation In Relational Algebra

41) Cartesian Product Operation In Relational Algebra

42) Rename Operation In Relational Algebra

43) Join Operation In Relational Algebra

44) Division Operation In Relational Algebra

45) Assignment Operation In Relational Algebra

46) Aggregate Function In Relational Algebra

47) Deletion Operation On Database Using Relational Algebra

48) Insert Operation On Database Using Relational Algebra

49) Update Operation On Database Using Relational Algebra

50) View Using Relational Algebra

51) Question Solve On Relational Algebra

52) Basic Structure Of SQL

53) Select From Where

54) Rename In SQL

55) String Related Operations In SQL

56) Ordering Tuples In SQL

57) Union And Intersect Operation In SQL

58) Except Operation In SQL

59) DMS - Aggregate Functions In SQL

60) Null Values In SQL

61) Set Membership In SQL

62) Set Comparison In SQL

63) Test For Empty Relations In SQL

64) Test For Absence Of Duplicate Tuples In SQL

65) Assignment On Company Database Query

66) Functional Dependencies (FDs)

67) Introduction To Normalization Of Database

68) First Normal Form (INF)

69) Second Normal Form (2NF)

70) Third Normal Form (3NF)

71) Boyce-Codd Normal Form (BCNF)

72) Fourth Normal Form 4NF

73) Closure On Attribute Sets

74) Canonical Cover Of FDs

75) 3NF Algorithm

76) 3NF Algorithm Problem Solve

77) Algorithm To Check Whether A Decomposition Is Lossless

78) Question Solve On Normalization

79) Question Solve On Functional Dependency

80) Question Solve On Referential Integrity

81) Disk Management

82) Pages And Blocks

83) IO Time To Access A Page

84) Heap Files

85) Index And Index Structure

86) Sorted Files

87) Storage Structure

88) Clustered Index

89) Unclustered Structure

90) Problem On Cost Of Range Search

91) Sparse Vs. Dense Index

92) Two Level Index

93) Multi Level Index

94) Index Sequential Access Method ISAM

95) B-Tree Definition And Properties

96) B-Tree An Example

97) B+ Tree

98) Insertion And Deletion Of B+ Tree

99) Hash Index

100) Choosing A Hash Function

101) Problems Of Hash Addresses

102) Extendable Hashing

103) Question Solve On B Tree

104) Question Solve On Disk Scheduling

105) Introduction To Query Processing

-------------------------------------------------------

Disclaimer : Developer claims no credit for any video embedded in this app unless otherwise noted. Videos embedded in this app are copyright to its respectful owners. If there is an video appearing in this app that belongs to you and you do not want it to appear in this app, please contact us via email and it will be promptly removed.