• 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

Databases are the spine of all major applications today! Whether internet-based, financial, social, administrative or intranet applications, without databases they all are namesake! Oracle, Microsoft SQL Server, have emerged as leading commercial systems whereas MySQL, PostgreSQL have led the open-source.

While DBMSs differ profoundly, they resemble a common set of models, design paradigms and a Structured Query Language (SQL). With this course, our main intention is to cover these details.

Who is the course for?

This course is designed for learners who are:

• beginners in this field

• want to prepare for University examinations

• want to prepare for placement interviews

• software professionals who want to quick start there carrier as a Database expert

in a short time span.

What topics will this course cover?

• Basics of DBMSs

• Comparison of DBMS with File Based System

• Three Level Architecture of DBMS

• Different models of DBMS- Relational, Hierarchical, Network Data models with Data operations on them.

• Understanding Primary, Foreign Key, Super Key, Candidate key and Artificial key

• Designing ER Model

• Concept of Entity, Entity Set, Strong and weak entity, Total and Partial Dependence

• Conversion of ER Model to Tables

• Learn Normalization from scratch.

• Concept of Functional Dependence, Fully Functional Dependence, Transitive Dependence and Multi Value Dependence

• Transaction Management

• Full SQL: Creation of Tables

• Insertion, Updation and Deletion of Data

• Alter Table

• Joining of Tables

• Cartesian Product, Inner Join, Outer Join and Self Join

• Grouping of Data in SQL

Who this course is for:

• 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