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

Equi join and Non Equi Join in SQL Server Step by Step With Example

In this Video We Learn Equi join and Non Equi Join in SQL Server Step by Step With Example

With
Prof: Muhammad Safdar Dogar

Rating

0 0

There are no comments for now.