Home
Online Admission
Blog
Student Application
Courses
Support
Career
Wiki
Events
Forum
Home
Job Placement Cell
Gallery
Covid Information
Library
Contact us
Shop
About
0
0
Sign in
Contact Us
Courses
Advanced Database Management System
Class Routine
Nav
Home
└
Advanced Database Management System
└
Class Routine
Advanced Database Management System
0 %
Course content
Course Overivew
Course Syllabus
Advanced Database Management System Course Syllabus
Mark Distribution
Sample Question
Class Routine
Final Exam Suggestion :
Lecture 1: Recall the concepts of advanced database system(Theory Chapter 1)
Basic Concept of Database Management System
Database Management systems Introduction
Recorded Live Class Video 1
Recorded Live Class Video
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"
blog
Recorded Live Class Video 2
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
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
Recorded Live Class Video 4
Lecture 5: Understand the Normalization( Theory Chapter 3)
Basic Concept of Database Normalization
Recorded Live Class Video 5
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
Recorded Live Class Video 6
Recorded Live Class Video 6
Recorded Live Class Video 7
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
Recorded Live Class Video 8
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
SQL Join(Inner Join, Left Join, Right Join, Full Join)
Certification 01
Certification
Certification 01
Lecture 9: Perform the task to view for Executing Query Operations: External sorting PROJECT and set operation(Practical 5)
Live Class
Live Class Link
Lecture 10: Understand the Transaction and Concurrency control (Theory Chapter 5)
Live Class
Live Class Link
Transactions and Concurrency Control Patterns
Class Routine
Prev
Set Done
Next
Fullscreen
About
Comments (
0
)
Statistics
Share
Views
0
Total Views
0
Members Views
0
Public Views
Actions
0
Likes
0
Dislikes
0
Comments
Share on Social Networks
Share Link
Copy Text
Share by mail
Please
login
to share this document by email.