Simplified Approach to DBMS: The Complete Package

Simplified way to learn Data Base Management System

Created by: Parteek Bhatia
Professor, CSED, TIET, Patiala, India

What Will I Learn?

• Understanding the meaning of term DBMS
• File Based System Vs. Data Base Management System
• Hierarchical, Network and Relational Data Models
• Concept of different types of keys like Super Key, Candidate Key, Primary Key and Foreign Key
• Designing of Entity Relation Model
• Conversion of ER Model to Tables
• Normalization of Database
• Transaction Management
• Concurrency Control
• SQL: Creation of Tables
• SQL: Alteration of Tables
• SQL: Insertion, Updation, Deletion and Retrieval of Data
• SQL: Joining of Tables
• SQL: Grouping of Data
• PL/SQL:: Get chance to enroll in PL/SQL Course completely free after completion of this course

Requirements

• Zero prior technical experience is required!
• All you need is a computer/Mobile Phone with good Internet connectivity!

Target audience

• Student taking DBMS Course
• BE, BTech, MTech, MCA, BCA, MSc Students
• Students preparing for placements and interviews
• Students preparing for GATE, UGC and other competitive exams