Database Management Systems (DBMS)
5.0
(5)
35 learners
What you'll learn
This course includes
- 18.3 hours of video
- Certificate of completion
- Access on mobile and TV
Course content
1 modules • 107 lessons • 18.3 hours of video
Database Management Systems (DBMS)
107 lessons
• 18.3 hours
Database Management Systems (DBMS)
107 lessons
• 18.3 hours
- Lec: 01 | Introduction to Database Management Systems (DBMS) | DBMS | Bangla Tutorial 11:47
- Lec: 02 | Difference Between Data & Information | DBMS | Bangla Tutorial 09:49
- Lec: 03 | File System VS DBMS | DBMS | Bangla Tutorial 08:32
- Lec: 04 | Components of DBMS | DBMS | Bangla Tutorial 06:10
- Lec: 05 | 2-tier Architecture | DBMS | Bangla Tutorial 05:33
- Lec: 06 | 3-tier Architecture | DBMS | Bangla Tutorial 05:35
- Lec: 07 | OLAP vs OLTP | DBMS | Bangla Tutorial 07:30
- Lec: 08 | Data Abstraction | DBMS | Bangla Tutorial 05:07
- Lec: 09 | Data Independence | DBMS | Bangla Tutorial 04:28
- Lec: 10 | Types of Schema | Schema | DBMS | Bangla Tutorial 06:23
- Lec: 11 | 3 Schema Architecture | DBMS | Bangla Tutorial 08:30
- Lec: 12 | Unique constraint | Types of Constraints | DBMS | Bangla Tutorial 07:13
- Lec: 13 | not null & default constraints |Types of Constraints | DBMS | Bangla Tutorial 07:58
- Lec: 14 | Check Constraint | Types of Constraints | DBMS | Bangla Tutorial 05:15
- Lec: 15 | Candidate key | Super key | Alternative Key | DBMS | Bangla Tutorial 14:31
- Lec: 16 | Primary Key | Types of Constraints | DBMS | Bangla Tutorial 07:27
- Lec: 17 | Primary Key | DROP Primary Key | DBMS | Bangla Tutorial 07:03
- Lec: 18 | Foreign Key | DBMS | Bangla Tutorial 14:03
- Lec: 19 | Foreign Key | Drop Foreign Key | DBMS | Bangla Tutorial 16:38
- Lec: 20 | ER Diagram | Entity Relationship Diagram | DBMS | Bangla Tutorial 13:36
- Lec: 21 | Symbols of ER Diagram | DBMS | Bangla Tutorial 06:23
- Lec: 22 | Types of Entity | Strong Entity | Weak Entity | DBMS | Bangla Tutorial 13:02
- Lec: 23 | Types of Attributes | DBMS | Bangla Tutorial 09:52
- Lec: 24 | Types of Relationship | One to One | DBMS | Bangla Tutorial 09:51
- Lec: 25 | Types of Relationship | One to Many | Many to One | DBMS | Bangla Tutorial 08:25
- Lec: 26 | Types of Relationship | Many to Many | DBMS | Bangla Tutorial 09:21
- Lec: 27 | Degree of Relationship | DBMS | Bangla Tutorial 04:23
- Lec: 28 | Participation Constraints | DBMS | Bangla Tutorial 04:24
- Lec: 29 | Relational Model | DBMS | Bangla Tutorial 07:00
- Lec: 30 | Integrity Constraints | DBMS | Bangla Tutorial 09:11
- Lec: 31 | Normalization | DBMS | Bangla Tutorial 19:45
- Lec: 32 | First Normal Form | 1NF | DBMS | Bangla Tutorial 13:22
- Lec: 33 | Second Normal Form | 2NF | DBMS | Bangla Tutorial 16:59
- Lec: 34 | Third Normal Form | 3NF | DBMS | Bangla Tutorial 12:12
- Lec: 35 | Boyce - Codd Normal Form | BCNF | DBMS | Bangla Tutorial 13:41
- Lec: 36 | Fourth Normal Form | 4NF | DBMS | Bangla Tutorial 13:05
- Lec: 37 | 5th Normal Form | 5NF | Lossless & Lossy Decomposition | DBMS | Bangla Tutorial 16:42
- Lec: 38 | Relational Algebra | Types of Relational Algebra | DBMS | Bangla Tutorial 08:27
- Lec: 39 | Selection Operator | Relational Algebra | DBMS | Bangla Tutorial 14:00
- Lec: 40 | Projection Operator | Relational Algebra | DBMS | Bangla Tutorial 21:21
- Lec: 41 | Rename Operator | Relational Algebra | DBMS | Bangla Tutorial 12:35
- Lec: 42 | Union Operator | Relational Algebra | DBMS | Bangla Tutorial 10:04
- Lec: 43 | Set Intersection Operation | Relational Algebra | DBMS | Bangla Tutorial 08:28
- Lec: 44 | Set Difference Operation | Relational Algebra | DBMS | Bangla Tutorial 08:44
- Lec: 45 | Cartesian Product / Cross Product | Relational Algebra | DBMS | Bangla Tutorial 09:45
- Lec: 46 | Division Operator | Relational Algebra | DBMS | Bangla Tutorial 16:19
- Lec: 47 | Introduction to Joins | Types of Joins | Relational Algebra | DBMS | Bangla Tutorial 04:59
- Lec: 48 | Theta Join | Inner Join | Relational Algebra | DBMS | Bangla Tutorial 17:20
- Lec: 49 | Equi Join | Inner Join | Relational Algebra | DBMS | Bangla Tutorial 17:21
- Lec: 50 | Natural Join | Relational Algebra | DBMS | Bangla Tutorial 18:17
- Lec: 51 | Left Outer Join | Outer Join | Relational Algebra | DBMS | Bangla Tutorial 11:47
- Lec: 52 | Right Outer Join | Outer Join | Relational Algebra | DBMS | Bangla Tutorial 07:57
- Lec: 53 | Full Outer Join | Outer Join | Relational Algebra | DBMS | Bangla Tutorial 08:03
- Lec: 54 | Deletion Operator | Relational Algebra | DBMS | Bangla Tutorial 14:37
- Lec: 55 | Insertion Operator | Relational Algebra | DBMS | Bangla Tutorial 13:51
- Lec: 56 | Update Operation | Relational Algebra | DBMS | Bangla Tutorial 08:25
- Lec: 57 | Introduction to SQL | DBMS Bangla Tutorial 05:24
- Lec: 58 | Types of SQL statements / commands | DBMS | Bangla Tutorial 04:54
- Lec: 59 | CREATE command | Database & Table Creation | DDL Statement | SQL | DBMS | Bangla Tutorial 06:38
- Lec: 60 | Index | CREATE Command | DDL Statement | SQL | DBMS | Bangla Tutorial 10:52
- Lec: 61 | ALTER | DROP | RENAME | TRUNCATE commands in SQL | DDL Statement | DBMS | Bangla Tutorial 08:03
- Lec: 62 | INSERT command in SQL | DML Statement | DBMS | Bangla Tutorial 07:23
- Lec: 63 | UPDATE Command in SQL | DML Statement | DBMS | Bangla Tutorial 06:33
- Lec: 64 | DELETE Command in SQL | DML Statement | DBMS | Bangla Tutorial 07:34
- Lec: 65 | SELECT Command in SQL | DBMS | Bangla Tutorial 07:22
- Lec: 66 | SQL Operators | DBMS | Bangla Tutorial 02:55
- Lec: 67 | WHERE Clause | SQL | DBMS | Bangla Tutorial 05:20
- Lec: 68 | AND, OR, NOT operators in SQL | DBMS | Bangla Tutorial 11:52
- Lec: 69 | Like & Not Like Operators | SQL | DBMS | Bangla Tutorial 13:04
- Lec: 70 | Aggregate Functions | MIN(), MAX(), AVG(), SUM(), COUNT() | SQL | DBMS | Bangla Tutorial 09:46
- Lec: 71 | Subquery in SQL | SQL | DBMS | Bangla Tutorial 19:20
- Lec: 72 | IN & NOT IN operators in SQL | SQL | DBMS | Bangla Tutorial 15:30
- Lec: 73 | EXISTS & NOT EXISTS Operators | SQL | DBMS | Bangla Tutorial 13:13
- Lec: 74 | Between & Not Between Operators | SQL | DBMS | Bangla Tutorial 10:42
- Lec: 75 | GROUP BY Statement | SQL | DBMS | Bangla Tutorial 15:28
- Lec: 76 | INNER JOIN | SQL | DBMS | Bangla Tutorial 10:28
- Lec: 77 | LEFT JOIN | SQL | DBMS | Bangla Tutorial 14:12
- Lec: 78 | RIGHT JOIN | SQL | DBMS | Bangla Tutorial 11:11
- Lec: 79 | CROSS JOIN | SQL | DBMS | Bangla Tutorial 10:07
- Lec: 80 | ORDER BY Keyword | SQL | Bangla Tutorial 04:52
- Lec: 81 | LIMIT Clause | SQL | DBMS | Bangla Tutorial 10:24
- Lec: 82 | HAVING Clause | SQL | DBMS | Bangla Tutorial 13:39
- Lec: 83 | Problem solving with SQL | Find Second Highest Salary | SQL | DBMS | Bangla Tutorial 17:15
- Lec: 84 | Problem Solving with SQL 2 | Find Out Department Wise Employee Salary | Bangla Tutorial 08:42
- Lec: 85 | Problem Solving with SQL 3 | Find out those student information whose CGPA more than 3.5 17:12
- Lec: 86| Problem Solving with SQL 4 | Find out those students information who admitted at "2022" 14:16
- Lec: 87 | Transaction in DBMS | Read(), Write() | DBMS | Bangla Tutorial 15:54
- Lec: 88 | COMMIT & ROLLBACK in Transaction | DBMS | Bangla Tutorial 11:57
- Lec: 89 | ACID Properties in DBMS | Atomicity |Consistency| Isolation | Durability | Bangla Tutorial 12:09
- Lec: 90 | What is Schedule? | Serial vs Parallel | Transactions | DBMS | Bangla Tutorial 08:25
- Lec: 91 | Lost Update Problem (Write - Write) Conflict | Concurrency Control | DBMS |Bangla Tutorial 19:40
- Lec: 92|Non-Repeatable Read Problem |Read - Write Conflict |Concurrency Control|DBMS|Bangla Tutorial 07:19
- Lec: 93 | Dirty Read Problem| Write-Read Conflict | Concurrency Problem |DBMS | Bangla Tutorial 08:49
- Lec: 94 | Recoverable Vs Irrecoverable Schedule | DBMS | Bangla Tutorial 12:36
- Lec: 95 | Cascading Rollback | Concurrency Problem | DBMS | Bangla Tutorial 07:25
- Lec: 96 | Cascadeless Schedule | Concurrency Control | DBMS | Bangla Tutorial 04:31
- Lec: 97 | Strict Schedule | Concurrency Control | DBMS | Bangla Tutorial 03:34
- Lec: 98 | Serializability | Serializable Schedule | Concurrency Control | DBMS | Bangla Tutorial 08:11
- Lec: 99 | Conflict Serializability | Concurrency Control | DBMS | Bangla Tutorial 17:14
- Lec: 100 | View Serializability | Concurrency Control | DBMS | Bangla Tutorial 16:09
- Lec: 101 | Introduction to File Organization | DBMS | Bangla Tutorial 05:29
- Lec: 102 |Sequential File Organization | Pile File Method | Sorted File Method |DBMS|Bangla Tutorial 09:18
- Lec:103 | Heap File Organization | File Organization | DBMS | Bangla Tutorial 08:32
- Lec: 104 | Hash File Organization | File Organization | DBMS | Bangla Tutorial 07:18
- Lec: 105 | Indexed Sequential Access Method | ISAM | File Organization | DBMS | Bangla Tutorial 06:33
- Lec: 106 | B+ Tree File Organization | File Organization | DBMS | Bangla Tutorial 05:13
- Lec: 107 | Cluster File Organization | File Organization | DBMS | Bangla Tutorial 05:53
Take this course with you
Download the app to continue lessons from your phone anytime.
