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