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.

Private Course

Please sign in to contact responsible.

Responsible	Johir Ahemmod Chowduri
Last Update	01/11/2024
Completion Time	9 hours 26 minutes
Members	26

Course
Reviews

Johir Ahemmod Chowduri Md. Nur-A-Alam Siddik Shohag

Course Overivew
- Course Syllabus
  
  Preview
- Mark Distribution
  
  Preview
- Sample Question
  
  Preview
- Class Routine
  
  Preview
- Final Exam Suggestion :
  
  Preview
Lecture 1: Recall the concepts of advanced database system(Theory Chapter 1)
- Basic Concept of Database Management System
  
  Preview
- Database Management systems Introduction
  
  Preview
- Recorded Live Class Video 1
  
  Preview
Lecture 2: Apply Normalization (1NF, 2NF and 3NF) on result process database.(Practical 1)
- What is Normalization in SQL? | Database Normalization Forms - 1NF, 2NF, 3NF, BCNF
- Blog of "Database Normalization"
- Recorded Live Class Video 2
Lecture 3: Understand the Relational and XML Database (Theory Chapter 2)
- XML to Relational Database
- Recorded Live Class Video 3
Lecture 4: Perform the task to view Stored procedure (Practical 2)
- SQL Stored Procedures, Functions, and Views
  
  Preview
- Recorded Live Class Video 4
Lecture 5: Understand the Normalization( Theory Chapter 3)
- Basic Concept of Database Normalization
  
  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)
- Equi join and Non Equi Join in SQL Server Step by Step With Example
  
  Preview
- Recorded Live Class Video 6
- Recorded Live Class Video 7
Lecture 7: Perform the task to Primary introduction to DBA User create, granting privileges(Grant, Revoke, Commit, Rollback, Savepoint)(Practical 4)
- How to create an user and to grant all privileges
  
  Preview
- Recorded Live Class Video 8
Lecture 8: Understand the Query Execution and Optimization(Theory Chapter 4)
- sql query optimization by using SQL server query execution plan
  
  Preview
- Recorded Live Class Link
  
  Preview
Certification 01
- Certification
Lecture 9: Perform the task to view for Executing Query Operations: External sorting PROJECT and set operation(Practical 5)
- Live Class
Lecture 10: Understand the Transaction and Concurrency control (Theory Chapter 5)
- Live Class
- Transactions and Concurrency Control Patterns
  
  Preview