Advanced 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)
- 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

sql query optimization by using SQL server query execution plan

SQL server query execution plan-
sql query optimization by using SQL server query execution plan

Views
0	Total Views
0	Members Views
0	Public Views

Actions
0	Likes
0	Dislikes
0	Comments

Advanced Database Management System

sql query optimization by using SQL server query execution plan

Share on Social Networks

Share Link

Share by mail

Embed in your website