Course Details
DEPARTMENT OF COMPUTER SCIENCE & ENGINEERING

DATABASE MANAGEMENT SYSTEMS

Introduction to DBMS, Syllabus Discussion,Course objectives, course outcomes,File system vs DBMS Advantages of DBMS.

DATABASE MANAGEMENT SYSTEMS

SQL Commands

DATABASE MANAGEMENT SYSTEMS

SQL Commands with examples

DATABASE MANAGEMENT SYSTEMS

ER model

DATABASE MANAGEMENT SYSTEMS

Design issuues and EER model

DATABASE MANAGEMENT SYSTEMS

Key constraints

DATABASE MANAGEMENT SYSTEMS

Aggregate functions

DATABASE MANAGEMENT SYSTEMS

practice on triggers

DATABASE MANAGEMENT SYSTEMS

practice on SQL statements

DATABASE MANAGEMENT SYSTEMS

Vires,cursors,stored procedures

DATABASE MANAGEMENT SYSTEMS

practice on SQL statements1

DATABASE MANAGEMENT SYSTEMS

practice on SQL statements3

DATABASE MANAGEMENT SYSTEMS

Introduction to RDBMS and Keys

DATABASE MANAGEMENT SYSTEMS

Relational algebra ,calculus and set operations

DATABASE MANAGEMENT SYSTEMS

SQL Joins

DATABASE MANAGEMENT SYSTEMS

SQL Views

DATABASE MANAGEMENT SYSTEMS

Subqueries

DATABASE MANAGEMENT SYSTEMS

Triggers

DATABASE MANAGEMENT SYSTEMS

Canonical cover on FD's

DATABASE MANAGEMENT SYSTEMS

Functional dependency

DATABASE MANAGEMENT SYSTEMS

Functional dependency2

DATABASE MANAGEMENT SYSTEMS

Introduction to Normalization

DATABASE MANAGEMENT SYSTEMS

Lossless and Lossy decomposition

DATABASE MANAGEMENT SYSTEMS

Normal forms

DATABASE MANAGEMENT SYSTEMS

Serializability