uLektz Skills

Learning Path

Non-Linear: Random Order

About the Course

Dear Students

This course is offered under Syllabus Completion program. It will help the students to revise and summarize your core topics for better preparation for semester exam. The course scheduled for 15 to 20 hours to covers the core topics by the faculty those who are currently teaching this course

Schedule for DATABASE MANAGEMENT SYSTEMS

Faculty : Dr. D. Jayaprabha

Live teaching from 13th June 2020 to 25th June 2020

Registration from on 7th May 2020 to 12th June 2020

OBJECTIVES

Classify modern and futuristic database applications based on size and complexity; design a database from understanding an Universe of Discourse, using ER diagrams; map ER model into Relational model and to normalize the relations; create a physical database from a design using DDL statements with appropriate key, domain and referential integrity constraints; analyze different ways of writing a query and justify which is the effective and efficient way; and compare and contrast various indexing strategies in different database systems and list key challenges in advanced database systems and to critique how they differ from traditional database systems.

Topics Focused On

File Systems Organization

Types of data models – Components of DBMS

SQL Standards – Data types

DDL-DML-DCL-TCL-Embedded SQL

Introduction-Properties of Transaction

Two Phase Commit Protocol-Dead lock

Overview of Physical Storage Media

B+ tree Index Files – B tree Index Files – Static Hashing

Dynamic Hashing – Introduction to Distributed Databases

Data Warehouse-Mining- Data marts.

Data Classification-Threats and risks

Distributed Databases-Architecture-Transaction Processing

Data Warehousing and Mining

Association rules

XML Databases

Features

Online live Teaching

Limited Participants Only

Taught by Experts those who are teaching the syllabus Currently

Selected and core Topics will be handled

Lecture Notes will be provided

Question Banks will be provided

For Further Details

Dr.A.Clementking

Director

INTEGRATED INTELLIGENT RESEARCH (IIR)

No 29 E, Sarojammal Complex 1st Floor,Keelkattalai, Chennai - 600117,

Mobile : +91 -9884568399 ;+91 9791163515. Email : iirindia2020@gmail.com

Web : www.iirgroups.org

Course Study Materials

Session 1

File Systems Organization on 13th JUNE 2020 SAT 11AM – 12PM

Session 2

Types of data models – Components of DBMS on 13th JUNE 2020 SAT 4 PM – 5PM

Session 3

SQL Standards – Data types on 15th JUNE 2020 MON 11AM – 12PM

Session 4

DDL-DML-DCL-TCL-Embedded SQL on 16th JUNE 2020 TUE 11AM – 12PM

Session 5

Introduction-Properties of Transaction on 17th JUNE 2020 WED 11AM – 12PM

Session 6

Two Phase Commit Protocol-Dead lock on 18th JUNE 2020 THU 11AM – 12PM

Session 7

Overview of Physical Storage Media on 19th JUNE 2020 FRI 11AM – 12PM

Session 8

B+ tree Index Files – B tree Index Files – Static Hashing on 20th JUNE 2020 SAT 11AM – 12PM

Session 9

Dynamic Hashing – Introduction to Distributed Databases on 20th JUNE 2020 SAT 4 PM – 5PM

Session 10

Data Warehouse-Mining- Data marts. on 22th JUNE 2020 MON 11AM – 12PM

Session 11

Data Classification-Threats and risks on 22th JUNE 2020 MON 4 PM – 5PM

Session 12

Distributed Databases-Architecture-Transaction Processing on 23th JUNE 2020 TUE 11AM – 12PM

Session 13

Data Warehousing and Mining on 24th JUNE 2020 WED 11AM – 12PM

Session 14

Association rules on 25th JUNE 2020 THU 11AM – 12PM

Session 15

XML Databases on 25th JUNE 2020 THU 4 PM – 5PM

The certificate issued for the Course will have

Student's Name
Photograph
Course Title
Certificate Number
Date of Course Completion
Name(s) and Logo(s) of the Certifying Bodies

Only the e-certificate will be made available. No Hard copies. The certificates issued by Integrated Intelligent Research . can be e-verifiable at www.ulektzskills.com/verify.

Students will be assessed both at the end of each module and at the end of the Course.
Students scoring a minimum of 50% in the assessments are considered for Certifications