Advanced Database Management System
This Course Conducted by
Johir Ahemmod Chowduri
Instructor of Computer Technology
Daffodil Polytechnic Institute
INTENTION
• To be able to acquire the knowledge and skill in the Relational and XML Database.
• To be able to acquire the knowledge and skill in the Normalization & Query Optimization
• To be able to acquire the knowledge and skill in the Transaction and Concurrency control.
• To be able to acquire the knowledge and skill in the Crash Recovery and Backup, Security and
Privacy.
• To be able to acquire the knowledge and skill in the Parallel and Distributed Databases, Mobile &
• Intelligent Databases, Object Oriented DBMS, Database applications.
SHORT DESCRIPTION
Relational and XML Database, Normalization, Query Optimization, Transaction and Concurrency control, Crash Recovery and Backup, Security and Privacy, Parallel and Distributed Databases, Mobile & Intelligent Databases, Object Oriented DBMS, Database applications.
| Last Update | 01/16/2021 |
|---|---|
| Completion Time | 8 hours 35 minutes |
| Members | 1 |
-
Lecture 1: Recall the concepts of advanced database system(Theory Chapter 1)
-
Free preview
-
Free preview
-
-
Live Class for Chapter 1
-
Free preview
-
Free preview
-
Free preview
-
-
Lecture 2: Apply Normalization (1NF, 2NF and 3NF) on result process database.(Practical 1)
-
Free preview
-
Blog of "Database Normalization"
-
-
Live Class for Chapter 2
-
Free preview
-
Recorded Live Class Video 2
-
Free preview
-
-
Lecture 3: Understand the Relational and XML Database (Theory Chapter 2)
-
Free preview
-
-
Live Class for Chapter 3
-
Free preview
-
Recorded Live Class Video 3
-
Free preview
-
-
Lecture 4: Perform the task to view Stored procedure (Practical 2)
-
Free preview
-
-
Live Class for Chapter 4
-
Free preview
-
Free preview
-
Free preview
-
-
Lecture 5: Understand the Normalization( Theory Chapter 3)
-
Free preview
-
Free preview
-
-
Live Class for Chapter 5
-
Free preview
-
Free preview
-
Recorded Live Class Video 5
-
-
Lecture 6: Perform the task to view Join concept such as Simple, equi, non equi, self, outer join(Practical 3)
-
Free preview
-
-
Live Class for Chapter 6
-
Free preview
-
Recorded Live Class Video 6
-
Free preview
-
-
Live Class for Chapter 6
-
Free preview
-
Free preview
-
Free preview
-
-
Lecture 7: Perform the task to Primary introduction to DBA User create, granting privileges(Grant, Revoke, Commit, Rollback, Savepoint)(Practical 4)
-
Free preview
-
-
Live Class for Lecture 7
-
Free preview
-
Free preview
-
-
Lecture 8: Understand the Query Execution and Optimization(Theory Chapter 4)
-
Free preview
-
-
Lecture 10: Understand the Transaction and Concurrency control (Theory Chapter 5)
-
Free preview
-
Free preview
-
-
Lecture 14: Understand Parallel and Distributed Databases (Theory Chapter 7)
-
Free preview
-
-
Lecture 16: Understand Object Oriented DBMS Overview of object (Theory Chapter 8)
-
Free preview
-