Simplified Approach to DBMS: The Complete Package

About 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 fieldwant to prepare for University examinationswant to prepare for placement interviewssoftware professionals who want to quick start there carrier as a Database expertin a short time span.What topics will this course cover?Basics of DBMSsComparison of DBMS with File Based SystemThree Level Architecture of DBMSDifferent models of DBMS- Relational, Hierarchical, Network Data models with Data operations on them.Understanding Primary, Foreign Key, Super Key, Candidate key and Artificial keyDesigning ER ModelConcept of Entity, Entity Set, Strong and weak entity, Total and Partial DependenceConversion of ER Model to TablesLearn Normalization from scratch.Concept of Functional Dependence, Fully Functional Dependence, Transitive Dependence and Multi Value DependenceTransaction ManagementFull SQL: Creation of TablesInsertion, Updation and Deletion of DataAlter TableJoining of TablesCartesian Product, Inner Join, Outer Join and Self JoinGrouping of Data in SQL