Simplified Approach to DBMS: The Complete Package

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