Database Management System

0 %

Course content

Course Overivew
Lecture 1: Recall the concepts of advanced database system(Theory Chapter 1)
Lecture 2: Apply Normalization (1NF, 2NF and 3NF) on result process database.(Practical 1)
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
- Recorded Live Class Video 4
Lecture 5: Understand the Normalization( Theory Chapter 3)
- Basic Concept of Database Normalization
- 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)
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
- 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
- Recorded Live Class Link
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

Completed