Learn Database Management : Video Tutorials
★ 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.
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.
Category : Education
Related searches